Thanks to everyone who helped last time. I am going to try this again.


I am trying to use a button to take a range of cells on a sheet, copy
and paste over the selected rows (in the next available column) to a
"MasterSheet" and link the cells to the original sheet, incase the
original page is updated.

If I can't do that, would there be a way to copy and paste those cells
onto a "MasterSheet" in the next available column and check that a job
code wasn't already used. If it was already used then to replace the
columns with the new data.

Is there any way I can do that?

Thanks for your help, again.