Hi
It's not clear to me what you're asking.
First of all we need to see the workbook you're trying to load. Please upload it.
Are you saying that the file you load looks like the data in B3:B7 on the Data sheet and that this will have a date somewhere and that date should be placed in A2?
Then finally the data you've loaded should be added to the appropriate column of the History sheet.
And if so which cells. C4:C6 or D4:D6 or something else?
As an aside your line of code needs to be inside a procedure. i.e. a
I'd also consider turning the history sheet through 90 degrees so that the dates are down column A and the values down columns B:D. This is a more 'natural' way of keeping a database and will simplify any future analysis you may require.
Bookmarks