Map user input with table header

[skatey]

I am new to VBA but I have a project to work on so I would appreciate any help .

The 'Jun Report' below is generated on a monthly basis at the end of the month. I need to map (Fries, Coke) into the 'Template' file. The data from the 'Jun Report' has to be mapped according to the month of the report in the 'Template' file.

Jun Report
	Food	Drink
MTD	Fries	Coke

As the monthly report 's file name is the same except for the month. My idea is to create an input box where user can type in the month and the respective month's report opens and copy the data (i.e. Fries, Coke). After that, make use of the user input (i.e. the month) to paste the copied data to the respective column (i.e. Based on the month of the report name) in the 'Template' file.

Template
	Jun	Jul
Food	Fries
Drink	Coke

Many thanks!

[JEC.]

Just to give you a start

Please Login or Register  to view this content.

[skatey]

Thank you for this! It works and I managed to complete the project