Forum Discussion
Link cells and Workbooks
Hello, I'm trying to create a summary page in excel that automatically updates when I create invoices in excel. I want the summary page to pick up the invoice number, date and amount. I don't wan...
If invoices are in the same format you may collect all workbooks with invoices in one folder and use Power Query to pickup and summarize required information.
It all depends on which Excel version/platform you are.