Autohide rows based on formula in another sheet

Nov 1, 2012
Reaction score
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