Auto Hide/Unhide Based on Results of IF Formula Pulling From Another Sheet

Hi all,

I am really new to VB, I basically know nothing about it. I have a worksheet (we'll call it 'Analysis') that is pulling data from another worksheet (we'll call it 'Dump') in the same workbook that is a dump of exported data from another program. Basically, the exported data can have anywhere from 1-22 columns of data, and I want the 'Analysis' sheet to automatically hide the columns that won't have data if the number of columns of data in the 'Dump' is less than the maximum of 22, which it almost always will be.

Right now, my sheet works out so that I could make the showing and hiding contingent on row 13, columns B through W. That column will either return the name of the column heading in 'DUMP', or it will return a dash. I want columns that don't return a dash to show, and columns that do return a dash to hide. This is the formula that I have in row 13.

=IF(DUMP!F9="","-",DUMP!F9)

I don't know if this makes a difference, but the columns will always populate in order, so if I have two columns, they will always be B and C. Three columns will always be B, C, and D. Etc.

Is there a way for me to do this? Any help is appreciated!

I can't post a sample workbook because is contains confidential information and it would be time consuming to recreate it without that information. Hopefully this screenshot will be enough, if not I can try to create a sample. In this case, I would want columns D - W to hide automatically because row 13 returns a "-" in those columns. Thank you for the help!

ss2.jpg

Originally Posted by davesexcel

Hi, sorry, the site was unavailable to me for 5 days.
Even a screen shot would require somebody to recreate the sheet so they could work on getting you an answer.

When you are asked to supply a sample workbook, that is what it is. A sample.
It should show how your layout is and would include "Phoney" data

No problem.

Ok, I will work on creating a sample, I just didn't know if it could be determined without that. I will try to have it done tomorrow. Can I PM it to you?