Hi All,

I've been trying to find a a VBA soltion for the following:

I have two worksheets. On worksheet 1 Cell A1 = to Cell A1 on worksheet 2. Whe I run the code I need the Cell on worksheet one now to = cell B1 on worksheet 2 and so forth that it changes everytime run the code. Any help or pointers in the right direction would be apreciated.

Thanks :-)

JMG