Update & Archive New Information

[James bolton]

Hi,

I assume this should be quite a simple Macro, but really having trouble coming up with something.

Attached is an example workbook with 3 sheets, 1 is the daily datasheet, the 2nd is the daily import and 3rd is the archive.

I'd like to programme the button in DataSheet so that it updates the price from the one found in daily import - and highlights them in yellow.

Also would like to be able to archive the prices daily, but I guess I may come back to that later as I would also like know how to do this in the most efficient way possible, with a large dataset and over a long period of time it would be too large to run efficiently.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[James bolton]

Sorry for the delayed response, this brilliant code works perfectly by the way.

Just have a question in regards to the I& = and J& =, first time I've seen something like this, what do they do ? Is it just another way of declaring a variable ?

 

[NARAYANK991]

Hi ,

See this for more details :

http://stackoverflow.com/questions/10890892/use-of-symbol-hash-in-vba-macro

Narayan

 

[Marc L]

Hi !

Yes, it's the original BASIC way to declare a variable …
And it's explained in VBA inner help !
​