Forum Discussion
OLD Dog looking for a Better Way to Link Worksheets & Workbooks and Create Reports than AutoSum
So for a long time I have just used AutoSum to link up a field from another worksheet or workbook and it's pretty tedius. So this old dog is trying to find a better way. The project is a Reporting...
Hard to tell.
It sounds like you might want VBA to help import the data, create a backend table of data, then your reports can run from that. My bread and butter but is complicated depending on structure of workbook.
Maybe a way more up your street if you understand links, and willing to learn power query.
1. Setup a "backend" table to get your data into 1 row on the individual workbook.
2. On your "Main" workbook, make a folder query to pick up .xlsms with those tables.
I've attached some examples
You will need to amend one of the folder path to your folder.
Hopefully this helps?
Alistair Blades - Bespoke Excel