Macro - copy a range of cells - paste as "values" to column - then next column - etc.

Hi all,

I have a Range: C3:C22... that is updated from another Worksheet.

I wish to have a MACRO that will copy the Range C3:C22... and Paste the 'Values' into D3:D22 (not to be updated).

The next time C3:C22 is updated with new Data... and the MACRO is run... and the 'Values' of C3:C22 are Pasted into E3:E22 (not to be updated).

The next time C3:C22 is updated with new Data... and the MACRO is run... and the 'Values' of C3:C22 are Pasted into F3:F22 (not to be updated).

...and so on... Pasting each time into the next Open Column to the right... simply a running tally.

Thanks so much to everyone wiliing to help!

MIGARDEIN

Please Login or Register  to view this content.