Moving row from one worksheet to another

[edwedw]

Hi,

I would like a sub routine that moves the data from row of the active cell to the "archive" worksheet. The data on the active row to be moved to the archive sheets is columns A-H, J-K and N to S.

I also need the line thats been removed from the active worksheet to be replace with a blank line with the formulas in the yellow cells.

My attempted sub is named converted, but obviously doesn't work.

Thanks for your attention, hope I have made sense.

[Leith Ross]

Hello edwedw,

This macro will successfully archive the data from the active row.

Please Login or Register  to view this content.