Share cell data between workbooks
Hi, I have been searching on the internet to a solution to this, but until now I have fallen short on an answer, so would really appreciate some assistance. Can and how do you share cell data between workbooks with excel. I can find a lot of information regarding desktop excel here, https://support.office.com/en-ie/article/create-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f, but nothing on excel online. Many thanks, Greig
Copying Data from a New Workbook
Hi, I am looking to make it quick and easy for my co-workers to compile new close file reports we received each week. Basically, each week my team receives a close file report, which I manually format so they can review the files and close. What I am hoping I can do is when the mater workbook is opened each week that it ask for the workbook we want to pull the data from. It will then copy this data to a new workbook into a format that I will setup by macros and then save this new worksheet into a new workbook for my staff to review and action.