I have 30+ Excel files in a folder, each containing various data and texts and one table at the bottom located around row 30.
Each table is preceded 2 rows above by the text "The list below displays the transaction level details based on the filters selected above".
The header is constant for all tables and has 18 columns but row numbers vary. Sometimes there is no table but the text "The list below displays the transaction level details based on the filters selected above" is still present.
All tables are ended with text below the last row stating "Report Run Date: DD MMM YYYY HH:SS" even when a table is not present.
How can I extract all these tables into one sheet?
Thanks in advance.
Each table is preceded 2 rows above by the text "The list below displays the transaction level details based on the filters selected above".
The header is constant for all tables and has 18 columns but row numbers vary. Sometimes there is no table but the text "The list below displays the transaction level details based on the filters selected above" is still present.
All tables are ended with text below the last row stating "Report Run Date: DD MMM YYYY HH:SS" even when a table is not present.
How can I extract all these tables into one sheet?
Thanks in advance.
Attachments
Last edited: