save worksheet data to alternate closed workbook - next row

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

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.
 
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.
Click to expand...

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
 
Back
Top