Re: $$Excel-Macros$$ Re: Need Help in Cross tab

2010-08-21 Thread shariqcool4u
Vodafone -Original Message- From: "Kishan Reddy, K" Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 02:17:56 To: MS EXCEL AND VBA MACROS Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need Help in Cross tab Hello Shariq, I don't under

$$Excel-Macros$$ Re: Need Help in Cross tab

2010-08-21 Thread Kishan Reddy, K
Hello Shariq, I don't understand why can't you use pivot table. Actually, it is simple with pivot table. Just drag the date to the rows header. drag the hours to the column header. LoadId to the data area. If you get sum on loadId, double click on it, and change it to count. The only differe