FirstTimeExcel1
New Member
- Joined
- May 12, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello,
Disclaimer: I am mostly new to VBA besides just recently creating the option to select items from a dropdown and then have them displayed as seen in D5, below.
From the picture above, I want to be able to use the strings in row 2 (A, B, C, etc... ) and if they match the strings listed in D5 (A, C in this example), then all other columns get hidden. The reason for this is that there is going to be 20 plus vendors when I put them in, so upon data entry I want only the selected Vendors columns to pop up.
Additionally, I assume this is going to be a Macro, which I have not dealt with. Will there be a "button" I can press, after which I'd click on the cell and it would perform the column hiding?
Let me know if I can clarify!
Thanks,
VBANewbie
Disclaimer: I am mostly new to VBA besides just recently creating the option to select items from a dropdown and then have them displayed as seen in D5, below.
From the picture above, I want to be able to use the strings in row 2 (A, B, C, etc... ) and if they match the strings listed in D5 (A, C in this example), then all other columns get hidden. The reason for this is that there is going to be 20 plus vendors when I put them in, so upon data entry I want only the selected Vendors columns to pop up.
Additionally, I assume this is going to be a Macro, which I have not dealt with. Will there be a "button" I can press, after which I'd click on the cell and it would perform the column hiding?
Let me know if I can clarify!
Thanks,
VBANewbie