PDA

View Full Version : Append rows to existing workbook in different folder and save in different location



sindhuja
04-06-2012, 12:46 AM
I need to copy data from existing worksheet to another workbook after the last used row.

The worksheet (sample in sample.xlsx) and the workbook are saved in different location. The user needs to select the workbook to which we need to append the data.

Also in the sheet “subtotal” I need to put the subtotal function for the rows in the sheet named “Master” in master.xlsx (this is the sheet in the master.xlsx workbook to which we need to append the data. Once this is done I need to save the master.xlsx to the path where the user wants to with different name.

Kindly assist with this requirement.