Macro for Consolidated Data date wise

[pradeepkodali]

Hi,

I am looking for a Macro which will provide consolidated data in another sheet. I have attached the sample spread sheet for your reference.

I will fill the individual team data every day in Sheets (Ops, Messaging, Storage & Windows) and I will get the consolidated report in Final Report Sheet for every day. I don’t want to save the daily data spread sheet for each date.

Now I want a Macro or VB Script which will copy the TOTAL (mentioned in RED in Final Report sheet) cell data in another sheet (as shown in Sheet1), it should look for system date and copy the data against the date whenever I run the Macro/Script.

I am not sure whether it is possible or not, but want to get suggestions from experts for this query all around the world. I appreciate all your help.

Regards,
Pradeep

[stanleydgromjr]

pradeepkodali,

Your attached workbook with three worksheets is empty.

[pradeepkodali]

Stan,

Sorry about that, some how file got corrupted. I have attached the file again. Please have a check.

Regards,
Pradeep

[pradeepkodali]

Hi,

Can any one help me on this, please?

Regards,
Pradeep

[watersev]

hi, pradeepkodali, please check attachment, run code "test"

[pradeepkodali]

Hi Watersev,

Thanks for your help!! It works like a charm.

Regards,
Pradeep