data consolidation summary report

[god_karthi]

Hi,
I need to consolidate data required in sheet("3").the data will come from sheet("1").
In attached workbook I made program as working column basis, but I need Row basis.So kindly correct My program as I required.
Note every month category data will come repeat.

I have my macro is given below:

Please Login or Register  to view this content.

[JohnTopley]

Are you not able to use formulae? SUMPRODUCT(By Group/Category/Date/Amount) with table as columns A to E (months in row 5 across columns)

And which amount are you summating?

[god_karthi]

Daer Sir,
Thanks for your valuable reply. Sum product formula i can easy set for that.But I need for macro.
Please kindly help for macro.

Thanks in Advance

Regards,
god_karthi

[JohnTopley]

I am not a VBA expert so I cannot change your code - did you not write it?.

And still don't understand why you need a macro to consolidate as it only appears to do what a formula would do. (I have just run it).

[S O]

did you not write it?.

More than likely not, as there appears to be some cross-posting going on...

[god_karthi]

sorry Sir, I will never do it again.

[god_karthi]

I had asked another form also same question and links is attached here.

http://www.ozgrid.com/forum/showthread.php?t=195599 & http://www.ozgrid.com/forum/showthread.php?t=195512