Automation of Excel report

[aparnawangu]

Hi All,

On daily basis i am sharing one excel report with the management.It contains an excel sheet and an summary sheet as well.
The excel sheet data i am getting from our internal reporting tool every day fresh dump and then in summary sheet is linked to the main sheet.
I want to automate this report now through VBA so that i can save a lot of time.

The problem is that in the main excel sheet also i have to do mapping everytime with a master excel file which contains some more fields.I am doing that with vlookup and for some #NA cases entering the data manually.

Pls suggest how can i automate this task.I am very new to VBA.

Regards,
Aparna

[Paul Cherian]

Can you provide a sample document for further analysis?