aravindhan_31
Well-known Member
- Joined
- Apr 11, 2006
- Messages
- 672
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi,
I have values in column A in Sheet 1 starts from A2 like below. A1 has the header as Data
A1 - Data
A2- B
A3 - H
A4 - I
...
...
...
A100 - BZ
All the above values lilke B,H, I, BZ etc are the Column B, Column H, Column I, Column BZ of sheet2.
I want to keep only these columns visible and hide all other columns in sheet2.
in future if I add the value in sheet1 A5 as 'AZ' then make this column also visible and hide rest everything.
on whole, I want to hide all the columns except the columns which are entered in sheet1 A1 to A100
I have values in column A in Sheet 1 starts from A2 like below. A1 has the header as Data
A1 - Data
A2- B
A3 - H
A4 - I
...
...
...
A100 - BZ
All the above values lilke B,H, I, BZ etc are the Column B, Column H, Column I, Column BZ of sheet2.
I want to keep only these columns visible and hide all other columns in sheet2.
in future if I add the value in sheet1 A5 as 'AZ' then make this column also visible and hide rest everything.
on whole, I want to hide all the columns except the columns which are entered in sheet1 A1 to A100
