Visual Basic for copy and paste columns

Hi,

I have an excel sheet which has a column (say column H) which has a list of about 20 number in it. This column updates when I refresh a query from a database connection.

So, here's what I would like to do. The refreshed data in H represents the "Current Position" so each time I refresh this I first need to copy the values for the relevant date (i.e the date I last refreshed the query) in to another column which is headed with the relevant date.

Then I can take the difference between H and my historic position and I have the movement over the time period.

Basically, I want to say, in crude terms, Select, Copy and Paste Values of Columns H in to the Column which is headed with the date that the data was last refreshed. If that makes sense...

I hope someone can help me!!

Many thanks

Rob

Hi

The following code will update as required, just substitute the actual ranges required.

Please Login or Register  to view this content.

Regards

Jeff