Hi guys,
I have no experience with Macros or VBA and am looking for a macro (or set of them) that will hide and unhide some rows based on the results of corresponding cells. I have the cell contents set via a "Yes" or "No" drop down box.
I have attached my spreadsheet that has three worksheets.
The first worksheet has three columns, one with an identifier, one with the name corresponding to the identifier, and then the "Yes"/"No" dropdown in the third. I have 17 of these unique identifiers with corresponding names and dropdowns organized in rows.
The second worksheet has some data relating to the unique identifiers. On this worksheet, I want these rows to be hidden when the corresponding identifier's dropdown is changed to "No" on the first worksheet. Also, when it is changed back from "No" to "Yes", I will need the row to be unhidden.
The third worksheet is the exact same as the second one, except it has some different data but on the same set of identifiers and will need to function exactly as the second worksheet.
I'd be happy to email a $5 Amazon gift card to anyone that could help.
I "Googled" for a little bit and see plenty of examples, I just don't exactly know how to implement them.
Would love to have this resolved within a couple days.
Thanks so much anyone!
Bookmarks