sunshine292
New Member
Hi,
I've been scraping my brain over this and I'm lost. I get excel spreadsheets (financials, weekly numbers) every week and I need to update my annual reporting spreadsheet so that I can provide it to my boss. Now my boss wants to improve efficiency and the ability to "push a button" which will automatically update the spreadsheet with the numbers. I do not want to do a cell reference, as the annual reporting spreadsheet gets emailed to others (we do not have a shared drive location).
I am wondering if anyone knows a macro that can automatically copy data from one workbook and paste it to an exact location in another workbook.
Thank you in advance for your help. I am very appreciative.
I've been scraping my brain over this and I'm lost. I get excel spreadsheets (financials, weekly numbers) every week and I need to update my annual reporting spreadsheet so that I can provide it to my boss. Now my boss wants to improve efficiency and the ability to "push a button" which will automatically update the spreadsheet with the numbers. I do not want to do a cell reference, as the annual reporting spreadsheet gets emailed to others (we do not have a shared drive location).
I am wondering if anyone knows a macro that can automatically copy data from one workbook and paste it to an exact location in another workbook.
Thank you in advance for your help. I am very appreciative.