I am completely new to VBA and it seems like a really neat thing to be able to utilize. Here is what I am trying to do. I have two sheets: Sheet 1 is called 'Master Sheet' and sheet 2 is called 'Customer Sheet'. On the master sheet, there is a cell that has a data validation dropbox with three options in the box. The options are called 'Option A', 'Option B', and 'Option C'. If 'Option A' is chosen on 'Master Sheet', I want rows 17-19 hidden on 'Customer Sheet'. If 'Option B' is chosen, I want rows 9-14 & 21-25 hidden on 'Customer Sheet' and so on.
I am looking for this to happen automatically if possible. I have a decent understanding of programming principles, I just cannot seem to find a way to
A) Make this happen automatically or
B) Make this work across multiple sheets.
Please help with this if you can!
I am looking for this to happen automatically if possible. I have a decent understanding of programming principles, I just cannot seem to find a way to
A) Make this happen automatically or
B) Make this work across multiple sheets.
Please help with this if you can!