save worksheet data to alternate closed workbook - next row
 

Need to save data on sheet "apples" when code is run to workbook in
specifc location/directory.
Behind the scenes, i need it to open the workbook, find next available
row on sheet "archive", paste data, save, close workbook. Exception:
if "archive" sheet is full, go to sheet "archive_2" and paste to next
available row.

save worksheet data to alternate closed workbook - next row
 

On Oct 15, 10:15*am, "J.W. Aldridge"
wrote:
Need to save data on sheet "apples" when code is run to workbook in
specifc location/directory.
Behind the scenes, i need it to open the workbook, find next available
row on sheet "archive", paste data, save, close workbook. Exception:
if "archive" sheet is full, go to sheet "archive_2" and paste to next
available row.

The macro recorder can be your friend. Record a macor while doing it
manually and then clean up the macro. Post back with your macro and
results and additional questions