I have table1 -> table6
I wanna insert 6 buttons that lets the user only view a specifik table at a time (and a show all button)
Is this possible? The problem is they are expanding, so I cant just do a hide/shows a A9:F1555-kindda-macro
I have table1 -> table6
I wanna insert 6 buttons that lets the user only view a specifik table at a time (and a show all button)
Is this possible? The problem is they are expanding, so I cant just do a hide/shows a A9:F1555-kindda-macro
Are the tables next to each other, above each other, or on separate worksheets? Do they have blank rows or columns in between them? Are they Structured Tables?
Suggest you post a Sample workbook with some typical data.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks