First time poster and very excited and grateful to have found a place with such genorous and talented members.
My Question.
Ok, I have a combo box list in Sheet1. When a specific division in that list is selected a number that corresponds to that division is changed in a cell in a different tab. For example when I select Div 1 in the drop down, cell A1 in Sheet2 changes to "1". When nothing is selected in the drop down (Blank) the cell is changed to 0.
I would like to create a VBA in Sheet1 that when a specific division is selected the VBA looks at cell A1 in sheet2 and then hides a specific number or rows in sheet1 based on that specified number.
For example.
If Cell Sheet2!$A$1 = "2" then hide rows 2-10 in Sheet1
If Cell Sheet2!$A$1 = "3" then hide rows 11-20 in Sheet1
If Cell Sheet2!$A$1 = "0" then hide rows 21-30 in Sheet1
Please help!!!
thank you.
Also, each time a new selection occurs in the dropdown and the Sheet2 cell A1 is changed to a different number then the previous rows that were hidden should unhide.
My Question.
Ok, I have a combo box list in Sheet1. When a specific division in that list is selected a number that corresponds to that division is changed in a cell in a different tab. For example when I select Div 1 in the drop down, cell A1 in Sheet2 changes to "1". When nothing is selected in the drop down (Blank) the cell is changed to 0.
I would like to create a VBA in Sheet1 that when a specific division is selected the VBA looks at cell A1 in sheet2 and then hides a specific number or rows in sheet1 based on that specified number.
For example.
If Cell Sheet2!$A$1 = "2" then hide rows 2-10 in Sheet1
If Cell Sheet2!$A$1 = "3" then hide rows 11-20 in Sheet1
If Cell Sheet2!$A$1 = "0" then hide rows 21-30 in Sheet1
Please help!!!
thank you.
Also, each time a new selection occurs in the dropdown and the Sheet2 cell A1 is changed to a different number then the previous rows that were hidden should unhide.