HI Mumps, if I need to start a new thread please let me know. Figured I start here given you are most familiar with the workbook.
The attached workbook has multiple sheets – I’m currently focused on the “primary core” worksheet.
The way it is designed is to hide or unhide rows based on the value in cell D4. If the value is “YES” then I need rows 6:24 to be visible and rows 25:72 to be hidden. If the value in cell D4 is “NO” then I need rows 6:24 to be hidden and rows 25:36 to be visiable. If the value is MIX then I need rows 6:36 to all be unhidden (this part isn’t working).
Now the fun part, in column A I have it set up to allow a user to hide additional rows that are not needed by inserting a value of “N” in column A of that row and then using the command button in A5 to hide all the rows with an “N” value in column A. When I have the value in D4 set to YES, rows 6:24 are visible and then I enter “N” in column A for 1 or more rows and press the command button in A5 - the rows with an N in column A all hide – this works as expected. However, when I have the value in D4 set to NO and rows 25:36 are visible – I enter the value of N into column A for one or more rows and click the command button to hide those rows – it hides the rows as expected but also makes visible rows 6:24 that do not contain a value N in column A. Is there a way to only hide the rows that contain an N and not make visible the rows that were previously hidden?
Also, I have a command button labeled “hosts” – I’d really like for it to work like the command button labeled “media gateways” – a user would hit the hosts button and it will ask how many hosts are being added – user enters a numeric value of 1 – 7 and it would copy/paste the rows 25:36 that number of times starting in row 37. It would also need to change the name from Host 1 to Host 2, 3, 4, etc depending on the value entered (if possible). If I do a copy/paste then it changes the row numbers of where the media gateways are (row 73) and it breaks that Macro. Is there a way to make this more dynamic so if rows are added/deleted the macro doesn’t break?
If there is an easier way to accomplish this - I’m all ears.