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
ening or receiving files with macros.
> Regards - Dave.
>
> > Date: Sat, 21 Aug 2010 13:26:35 +0530
> > Subject: $$Excel-Macros$$ Need Help in Cross tab
> > From: shariqcoo...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > Hi All,
> >
> >
Hi All,
I need your help, as I’m unable to solve the problem which I’m going
to explain you guys……..
Please refer the attached the excel with two tabs “Data” and “Report”
On Data tab I have three columns loaded and Date and hours. Now I need
a macro code to generate a report actually the cross bet
