Autohide rows based on formula in another sheet

J

jocko327

Joined
Nov 1, 2012
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide multiple worksheets based on a formula value in one cell 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Inserting multiple rows in multiple worksheets 1
Changing sheet name based on a cell in another sheet 1
List details in another sheet 2
Save record Into master sheet! 1
Somewhat complex code to copy data from one sheet to another 9

Top