Creating an Excel Database in Separate Workbook
Hi,
I'm trying to take data from a spreadsheet by copying it, and then open a
new spreadsheet (that is saved on the c:\ drive), find the last row of data
in the spreadsheet, paste the data from the original spreadsheet, and then
save and close the database sheet.
I know this would probably be more efficient with Access, but the users will
not have access to Access, so I need to use Excel.
Any help with coding would be greatly appreciated.
Thanks,
Brian
|