I am trying to put together some code to do the following
1. Open OLDDATA workbook (using the dialog box, file name and path will be different every time)
2. Copy all rows except row1 from OLDDATA, olddatasheet (this is the only worksheet in the file) to the workbook that the macro was run from (workbook=NEWDATA, sheet=newdatasheet. this will always be called the same). newdatasheet will already have data so i need it to copy to the next available row
3. Close OLDDATA workbook without saving
Can anyone help? my attempt is below...
Please Login or Register to view this content.