I have a file open dated 14.04.02.xls, and I need to copy the data from the open file to the correct day (14.04.02) in a weekly file, all the days are all listed on one sheet in the weekly file in columns ( so i can see a running total of the week to date
I need this to be in VB, so I can automate it to work for every previous day for the week.
I need the data for 14.04.02 to be pasted into the 14.04.02 column
thanks in advance for any help on this.
I need this to be in VB, so I can automate it to work for every previous day for the week.
I need the data for 14.04.02 to be pasted into the 14.04.02 column
thanks in advance for any help on this.