$$Excel-Macros$$ Macro Help

Dear All, Please find attached a file. It contains four sheets. Sheet branches contains details for branches, sheet data contains data for the branches and sheet report contains the rough format in which I need the report to be in. My quest is that when ever a new branch is opened, for example,

$$Excel-Macros$$ Pivot Problem

Dear All, I have to apply pivot on a data that reaches approx 1.5m rows and is spread on 15 columns. If I divide the data in two parts of 0.8m rows each, I can not do a complete analysis. Any suggestions?? Regards, ZAC --

$$Excel-Macros$$ Macro Required

Dear Group, I have excel sheets containing sales data on daily basis (from about 150 sites) (The columns are similar in all the daily sale files but rows change from time to time as new sites either become operational or stop working). I wish to consolidate all the data in one excel file in such

Re: $$Excel-Macros$$ Formula Guide Require !!

Thanks Shayam for the link to the great site... But does anyone knows any site from where I can download the details of these functions.. I want to read them at my leasure time at home as it is impossible to go through them during the office hours.. Thanks ZAC On Tue, May

Re: $$Excel-Macros$$ Urgent Help Required in a macro

Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer me to a good course from where I can learn to write macros... On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Zac, Can I suggest a simpler approach? Using the

$$Excel-Macros$$ Urgent Help Required in a macro

Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would

Re: $$Excel-Macros$$ Fwd: Urgent Help Required in a macro

is possible and someone in group should help you out on same, Please submit a separate query with detailed example. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 8:38 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Dear Ayush, Thanks for the file

Re: $$Excel-Macros$$ Re: Pivot Problem

for such a massive task. Access can handle larger database queries. Even if you use Access to perform all your summerizing and then export it back to excel for the presentation parts, I think you you come out with far less stress. -Good Luck Michael On Apr 12, 2:41 pm, Chaudhry Zahid Ali chaudhry.zahid

$$Excel-Macros$$ Pivot Problem

Hello Group, *Overview:* I have a issue to discuss. I have got an excel sheet which contains over 150,000 trial balance account subheads made up of data from different branches (All Branches). So there are multiple account heads that are repeating. I have constructed a Pivot table out of the data

$$Excel-Macros$$ Date Problem

Hi, I have got a little problem that I need to solve I have a sheet with multiple transactions. The columns include Date and amounts. There are multiple amounts against a single date I need to extract the amounts which are appearing against every date, but the last amount in every