Change data based on date field

I have a file, a portion is attached, where I want to paste the value of the formula (in this case, just that of the external data) once it has grabbed the data from an external source.

If the first time I open the file is Jan 15, I want it to grab the data in columns C, E and G from Jan 1 to Jan 14 and paste each cell's value in the same cell. Any data on Jan 15 or past Jan 15, I don't want the value (hasn't been collected yet).

If I open the file again on Jan 18, I need the data from Jan 15 to Jan 17.

I have this macro which works well for grabbing the data and pasting the value, but I am struggling doing this based on the date.

Please Login or Register  to view this content.

Any suggestions on limiting this by date in the first column?

I have a file, a portion is attached...

No attachment. Are the dates stored in a header row of some sort ?

Given you have external links obviously this is hard to validate but I think you're saying you want to leave the formulae in place for future dates, correct ?

Based on your existing code, perhaps then:

Please Login or Register  to view this content.

the above assumes date value is always in 1st column of sheet - if this is not the case then obviously things get a little more complicated and we'd need more info.