Main file Would look like this
Column A Inbuond Outbound Sales Quality
01-Feb-12 Value
02-Feb-12 Value
03-Feb-12
.
.
.
.
I fill the values in columns B , C etc looking at the file which i download everyday.The download file looks like this
Column A Inbuond...
I download reports daily and save it in a common folder. In that folder i have excel file template with all the dates of the month in a column. I enter the data against each respective date based on the file i download. I want to create a macro or automate which help enter the data automatically...