save worksheet data to alternate closed workbook - next row

[J.W. Aldridge]

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.

 

[Don Guillett Excel MVP]

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