Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

2010-02-01 Thread asha abraham
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

$$Excel-Macros$$ Please help me fourmula

2010-02-01 Thread subhash tambe
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

$$Excel-Macros$$ Dynamic criterion range for Advanced filtering

2010-02-01 Thread Philip
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

$$Excel-Macros$$ Dataform applied to a database not starting in Row 1

2010-02-01 Thread Philip
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

Re: $$Excel-Macros$$ Please help me fourmula

2010-02-01 Thread Dilip Pandey
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,

Re: $$Excel-Macros$$ Cash Statement :Need help

2010-02-01 Thread worawat kh
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

$$Excel-Macros$$ Any way to use customer icons with conditional formatting?

2010-02-01 Thread TD
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

Re: $$Excel-Macros$$ Copy Excel Data from sheet and fill in already opened internetexplorer and submit and repeat for 10 similar postings

2010-02-01 Thread Alokeshwar Tiwary
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   __

RE: $$Excel-Macros$$ Dynamic criterion range for Advanced filtering

2010-02-01 Thread Dave Bonallack
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

Re: $$Excel-Macros$$ Please help me fourmula

2010-02-01 Thread ankur
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