Hiding/Unhiding certain rows by Command

[Hakkology]

Hello there, this will be my first post in this forum. I have been employed for a month as a field engineer and been doing my best to improve my excel to create more room for action. There are a couple things that I would like to do and i could use a bit of an advice.

Our project has two phases with about 400 items. For the first phase, we need about 100 items and the second phase, all 400 items.
I will be managing a daily report page which allows our managers to track both phases of the project clearly.

For more information, I'm working as a field engineer for a Company that builds high voltage overhead transmission lines. For the project I am currently employed, only 100 of the towers need to be built as the other 300 towers are already built for assembly, but all towers will have to be used when we get to stringing phase.

So I would like to create some sort of Hide/Unhide mechanism that hides the 300 unnecessary items for the first phase of the project. A command line with an tick box or simply a text field (you write "show" or "hide") that hides those unnecessary items and reveals them depending on the phase of the project we are currently in and the person interested in tracking the project.

Could I get some suggestions on how to act on this kind of situation ?

Thank you and have a lovely Christmas.

[AliGW]

Welcome to the forum.

This will require VBA (code), so I've moved the thread accordingly.

[Hakkology]

Thank you for moving my question to the approriate thread, in time I hope that I shall be able to familiarize myself more with the structure of this forum, as i am planning to use and share more in the future.

To give a bit more detailed information, I could say the following;

400 items are listed with their specific details as rows.
Once the trigger happens (the button is clicked or "show" is written)
If DXXX row has "Complete" on column X;
Hide the row.
If DXXX row has anything else on column X;
Show the row.

Again thank you for the help.
Really appreciate it.

[AliGW]

A sample Workbook might be more helpful.

There are instructions at the top of the page explaining how to attach your sample workbook.

[LeoTaxi]

Could be like this

Please Login or Register  to view this content.

Double click on X1 to hide, right mouse click to show

Kind regards
Leo