Hello,
I've read through a number of threads on how to hide rows in Excel via macros, but none of them seem to answer my specific situation. Hope you can help me:
I have two sheets. Sheet 1 "Roadmap" shows in a grid when which newsletter is going to be sent. Sheet 2 "Mailings" lists all the different newsletter types. In column "O" in Sheet 2, there is a dropdown for each newsletter type where one can choose whether the newsletter is "active" or "inactive". When the newsletter in Sheet 2 is set to "inactive", I want to hide the corresponding row in Sheet 1.
Further details:
- The list in Sheet 1 starts with row 9
- The list in Sheet 2 starts with row 4
- The order of the newsletters in the two lists is the same (so 9 corresponds to 4, 10 to 5, 11 to 6 etc.)
- The list won't be longer than 50 rows
- The macro can either run automatically or on button click
- I have Excel 2013 running on Windows 7
Hope everything is clear
Thanks for your help!
Laurent
I've read through a number of threads on how to hide rows in Excel via macros, but none of them seem to answer my specific situation. Hope you can help me:
I have two sheets. Sheet 1 "Roadmap" shows in a grid when which newsletter is going to be sent. Sheet 2 "Mailings" lists all the different newsletter types. In column "O" in Sheet 2, there is a dropdown for each newsletter type where one can choose whether the newsletter is "active" or "inactive". When the newsletter in Sheet 2 is set to "inactive", I want to hide the corresponding row in Sheet 1.
Further details:
- The list in Sheet 1 starts with row 9
- The list in Sheet 2 starts with row 4
- The order of the newsletters in the two lists is the same (so 9 corresponds to 4, 10 to 5, 11 to 6 etc.)
- The list won't be longer than 50 rows
- The macro can either run automatically or on button click
- I have Excel 2013 running on Windows 7
Hope everything is clear
Thanks for your help!Laurent
