How to hide/unhide rows based upon cell value from another worksheet

swhitesides

New Member
Joined
Apr 17, 2009
Messages
16
One sheet of my workbook is a master summary sheet where data is entered. Column A contains numbers that we use as a VLookup Reference key for other sheets in this workbook. Example:
Master Summary Sheet
1 Bob
2 Fred
3 George
4
....
105

Now, I want other sheets in this work book to only display certain rows that correspond with data input from the master summary sheet. Example
1 Bob (may have up to 15 corresponding rows listed beneath name)
2 Fred (may have up to 15 corresponding rows listed beneath name)
3 George (may have up to 15 corresponding rows listed beneath name)
4 (Hidden until data entered on master summary sheet, then
automatically displayed along with corresponding rows)
... (Hidden until data entered on master summary sheet, then automatically displayed along with corresponding rows)
105 (Hidden until data entered on master summary sheet, then automatically displayed along with corresponding rows)

:eek: I'm sure that a macro can do this. I need the macro to be private, which I'm having issues for it to automatically hide & unhide as data is entered or deleted.

Any help would be greatly appreciated! Please ask if any clarification is needed! Thank you.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top