rakupareek
New Member
- Joined
- Dec 29, 2023
- Messages
- 38
- Office Version
- 2016
- Platform
- Windows
Hi
I have a protected worksheet named "P&L
In which 1-4 rows are headings
And row 5-15 available for data entry
I have made drop-down list in range B5-B15 for expenses and F5-F15 for income
Column C and G for Amount
At the start row 6-15 are hide
And row 5 is first row and being always unhide
My question is....
When I select data from drop-down in range B5-B15 next row automatic unhide.
Same rule will apply on range D5-D15
Please suggest me VBA code for this
I have a protected worksheet named "P&L
In which 1-4 rows are headings
And row 5-15 available for data entry
I have made drop-down list in range B5-B15 for expenses and F5-F15 for income
Column C and G for Amount
At the start row 6-15 are hide
And row 5 is first row and being always unhide
My question is....
When I select data from drop-down in range B5-B15 next row automatic unhide.
Same rule will apply on range D5-D15
Please suggest me VBA code for this