• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter all Tables in a work book -Dates

TurboDieselOne

New Member
Good Day
thanks in advance for this. I have a workbook with over 80 tabs containing tables - identical in headers.
Header column 3 contains a date I want to filter all these tables with a between date so between and including the 01/08/22 to 07/08/2022.
I know it has something to do with Listobjects
Can any help?


Many thanks
 
TurboDieselOne
Send a sample Excel-file with some sample data.
Questions:
Why do You would like to filter over 80-sheets in one time, if You could see only one sheet in time?
Why do You have over 80-sheets? Could those all be in one sheet? ... and You could filter it as needs
... it's same as previous question ... You could see only one sheet in time.
 
TurboDieselOne
Send a sample Excel-file with some sample data.
Questions:
Why do You would like to filter over 80-sheets in one time, if You could see only one sheet in time?
Why do You have over 80-sheets? Could those all be in one sheet? ... and You could filter it as needs
... it's same as previous question ... You could see only one sheet in time.

I am not permitted to send a sheet.
 
« No arm, no chocolate ! »​
So just activate the Macro Recorder & operate manually …​
 
TurboDieselOne
What do You mean?
Cannot You answer to my questions?
Cannot You attach an Excel-file?
Cannot You create a sample Excel-file which has few sheets with sample of Your used tables?
Notice that word sample has underlined.
 
Back
Top