I've been researching for an answer but didn't find one solving my problem yet.
- I'm building a file for team members to enter some data for their category (Sales, Marketing, HR, etc.) per quarter (Q1 2022, Q2 2022, etc)
- For now: all categories are displayed in columns: Sales from column C to column H, Marketing from column I to columns P, etc. for the other categories (so the file has many columns to fit all categories).
- I would like to facilitate the usage of the file. Let's say if I write "Sales" in cell A1: I want only column C to H to appear, if I write "Marketing" in cell A1: I want only column I to P to appear, etc.
- Ideally, I would like the macro to run automatically when the text is entered in A1
I've tried to create a macro but it's wrong (the columns are hidden when I enter a value in A1, but when I change the text in A1, nothing happens)
Can someone help please?