Hi all, please could someone help a newbie poster?
Basically I've a workbook which is full of sheets copied from a master, plus a summary sheet, an archive sheet and the master. I want to create a macro which will take certain data from sheet n, copy just that data into the next available row on the archive sheet, then delete sheet n without losing the newly added data in the archive.
Is this possible? The problem I seem to be having so far is referencing a sheet which has just been deleted!
Thanks in advance.
Basically I've a workbook which is full of sheets copied from a master, plus a summary sheet, an archive sheet and the master. I want to create a macro which will take certain data from sheet n, copy just that data into the next available row on the archive sheet, then delete sheet n without losing the newly added data in the archive.
Is this possible? The problem I seem to be having so far is referencing a sheet which has just been deleted!
Thanks in advance.