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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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,223,883
Messages
6,175,168
Members
452,615
Latest member
bogeys2birdies

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