Forum Discussion
How to reference data by a name and a date
Hello, My organization sends out a ton of reporting to track various things, but none of it is centralized. I have a spreadsheet that collects a lot of this reporting and centralizes it. A...
An alternative could be Power Query. In the attached file you can enter data in the three blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse. Then select refresh.
The layout of the tables in the screenshot is for illustration. You can drag the small blue dynamic tables to columns M and P for example. Then you can add thousands of rows to the large blue dynamic table.