Trigger Auto Hide / Show Rows in other Sheets

Kevin_267

New Member
Joined
Sep 8, 2024
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Good Day to you all,

Newbie here, looking for some advice 😊. I have a spreadsheet linked here (hope it works) Its my works training record for different areas. I could split it down to different positions but I'm sure there's a way to keep it all together. I have browsed through to see if i can find something that resembles what i'm trying to do but just cant quiet get it to work correctly.

When i change the drop down in "Trainee Details K11" it selects the data from "GS" & "EO's" to then put into "GS Syllabus", "GS 1", "TO Syllabus", "EO Tracker" and "1". I hope you're still with me. At the minute the referenced data doesn't fill all the rows and changes depending on which drop down.

Aim- I would love to be able to hide/show rows automatically when triggered by the selection of the drop down?

I really hope this can be done 🙏

Thank you gurus, any questions I will keep an eye out.
 

Attachments

  • 1726211482528.png
    1726211482528.png
    47.5 KB · Views: 8
  • 1726211663357.png
    1726211663357.png
    45.5 KB · Views: 8

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
This is Google sheets and I doubt it is possible in that. Maybe using filter would be a good start? No idea though
 
Upvote 0
Sorry this shouldn't be google sheet it was .xlsm macro enabled Excel Sheet :unsure: I will have to try save it elsewhere or attempt a mini-sheet.
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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
Back
Top