hi Subhash
where is file ?
On 01/02/2010, Dilip Pandey wrote:
> Hi Subhash,
>
> You have forgot to attach the files. Please attach the file and explain
> your query as well. Thanks.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B Com(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gm
Hi,
If I understand correctly, I would use a dynamic named range.
This link shows the method.
http://www.contextures.com/xlNames01.html#Dynamic
Regards - Dave.
> Date: Mon, 1 Feb 2010 03:55:39 -0800
> Subject: $$Excel-Macros$$ Dynamic criterion range for Advanced filtering
> From: phi...@eya
Yes, more or less its same as WorkSpace. JitBit records keystrokes and repeats
them any no of times. It also has a little customization capability like if
then, defining window/application name, reading clipboard text etc.
Regards,
Alokeshwar
+1 617 710 8441
__
I am doing analysis of 8 possible conditions and would like to insert
a custom icon based on the number in the cell. The intent is to
provide a graphical representation for each cell's value. I've tried
the icon sets available with coditional formatting. I like the
concept, but would really like to
Dear K.Sri,
I just learning for macro but may can help you
Please try
Sub Macro1()
Range("R4").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-4]=""debit"",RC[-7],)"
Range("S4").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-5]=""credit"",RC[-8],)"
Range("R4:S4").Select
Selec
Hi Subhash,
You have forgot to attach the files. Please attach the file and explain
your query as well. Thanks.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Mon, Feb 1, 2010 at 4:15 PM,
To automatically track the criterion range area for advanced filtering
when adding a value on the next row in the criterion range (so that I
can filter Value A OR Value B), I want to make the criterion range
dynamic. However, when repeating the Advanced filter command after
inputting Value B on th
I have two databases in a worksheet, the second's headers are on Row
40. On highlighting the second's headers and data, the Dataform
correctly picks up the related fields.
However, when running VBA code, the dataform defaults to the fields of
the first database in Row 1.
A workaround this proble
Dear All,
please give me count fourmula in thes sheet
--
Subhash
Pratham Mumbai Education Initiative
9870914252
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi Ankur, could u pls send me the VBA e-books to my id...
thanks in advance.
rgds
ash@
On Sat, Jan 30, 2010 at 4:10 PM, ankur wrote:
> hi chetan
>
> i had send some ebooks at your email id plz check it
>
>
>
> On 30/01/2010, chethan wrote:
> > Hi Everybody,
> >
> > i am very new to the world
10 matches
Mail list logo