save worksheet data to alternate closed workbook - next row

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.
 
D

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.
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find last row in workbook sheet & move data to it from another sh 5
Cell values to an array, then array transpose to another workbook 8
Import multiple workbooks to current workbook in specified row number 0
Cutting row data and pasting into next available row on different tab 2
Copy and Save in specific way 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
How to prevent a graph update 2

Top