Why does macro keep changing figure already input

[gareth7412]

Hi

I have this macro and it copies and pastes into the next avail column in sheet 2 but when it copies and pastes it overwrites data from previous columns with latest data too when it shouldnt be.

Any ideas?

Please Login or Register  to view this content.

[cytop]

Ignore - misread, but it does seem to work correctly - copies to the next available column on sheet 2 every time it is run.

[carlmon]

Please Login or Register  to view this content.

try that

[gareth7412]

tried that and it comes up with run time error 1004 select method of range class failed.

[carlmon]

Please Login or Register  to view this content.

[rorya]

You've linked the pasted cells to the source. If the source changes, so will all the pasted cells, including previously pasted ones.

[gareth7412]

right so would it work if I was to paste values rather than paste link?

[carlmon]

are the values formulas or just letters/numbers?

[rorya]

Yes it would work