View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default 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.