christopher81
New Member
- Joined
- Apr 23, 2020
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Helloooooo i need help
In sheet ,MENU i have 20 employees G2:G21
And another 12 sheets:
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
in cells A3:A22
are introduced automatically by the method ='MENU'!G2
The help you need is,
while lines 3:22 are hidden, when I write on the MENU G2 sheet any employee name, it automatically unhide on all twelve sheets with the months A3
and the same with the other cells
employee name G3, row unhide 4
employee name G4, row unhide 5
employee name G5, row unhide 6
..................
.................
.................
and hide rows to twelve sheets no text value MENU G2
G3
G4
......
.......
Any help appreciated.
In sheet ,MENU i have 20 employees G2:G21
And another 12 sheets:
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
in cells A3:A22
are introduced automatically by the method ='MENU'!G2
The help you need is,
while lines 3:22 are hidden, when I write on the MENU G2 sheet any employee name, it automatically unhide on all twelve sheets with the months A3
and the same with the other cells
employee name G3, row unhide 4
employee name G4, row unhide 5
employee name G5, row unhide 6
..................
.................
.................
and hide rows to twelve sheets no text value MENU G2
G3
G4
......
.......
Any help appreciated.