Hi Bo_Ry,
Thank you for reply. Very impressive and much appreciated.
This looks good, 90% there, but I was wondering if you can help me on a couple of points.
1) See post #5. The query is filtering by date but each worksheet has a different date (A5), so how do I remove the date restriction and add a column to show the date of the report?
2) How do I change the source so it picks up all worksheets - currently it is just looking at Sheet3? After a bit of research, following Ali's advice, I added:
...but it runs into the date error: "Expression.Error: The column 'Date 06.05.2020' of the table wasn't found."
Thanks
Bookmarks