You're welcome.
Regards - Dave.
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: shariqcoo...@gmail.com
Date: Sun, 22 Aug 2010 07:15:09 +
Thanks Dave
Thanks for your help.I have not checked the sheet coz I'm not on my lap
10 15:10:50
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help in Cross tab
Hi,
I have re-done your sheet using VBA.
It will accommodate as many rows as needed on the report sheet, and up to
10,000 rows on the DATA sheet (although
Sender: excel-macros@googlegroups.com
Date: Sat, 21 Aug 2010 18:16:12
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help in Cross tab
Thanks Andy. You're welcome.
Regards - Dave.
Date: Sat, 21 Aug 2010 15:33:03 +0530
Subjec
: $$Excel-Macros$$ Need Help in Cross tab
Hi Shariq
I've done this with worksheet functions, not VBA.
The original formula is in B3 on the Report sheet. It's then just copied down,
then copied across.
If you really need it in VBA, it can be done easily enough, but this way
updates instantl
Thanks Andy. You're welcome.
Regards - Dave.
Date: Sat, 21 Aug 2010 15:33:03 +0530
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: aind...@gmail.com
To: excel-macros@googlegroups.com
Hey Dave,
This is great!! you never stop amazing me with your simple solutions to co
Hey Dave,
This is great!! you never stop amazing me with your simple solutions to
complex problems..
Keep it up man!!
You are a pillar of our group...
Cheers!!!
Andy
On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack
wrote:
> Hi Shariq
> I've done this with worksheet functions, not VBA.
> The ori
