Creating and Hiding TAB's Systematically.

[shephardfamilyenterprise]

I would like to create a tab for the departments that exist in our pull for the dump into excel, below is the structure. How do I do this systematically?

IF ‘FW FILE DUMP_DEPT ‘!A1:A211 = ‘DEPARTMENT’!A2:A211 THEN SHOW TAB on Worksheet that = department name in Department listing.
ELSE HIDE TAB that DOES NOT equal ‘FW FILE DUMP_DEPT ‘!A1:A211 on Worksheet
END IF;

This is to prevent the customer from printing blank tabs that do not have data that correspond to it. The last formula worked great!!! Thanks.

 

[shephardfamilyenterprise]

 

[shephardfamilyenterprise]

?

 

[shephardfamilyenterprise]

?

 

[shephardfamilyenterprise]

Need Help.

 

[Norie]

I'm sorry but your post isn't clear, to me anyway.

 

[shephardfamilyenterprise]

I hope this help.....

I'm sorry but your post isn't clear, to me anyway.

What I want to do is create a tab systematically if a list of departments are not listed from a file dump. Let's say that cell A1:A211 has all the departments and appear in worksheetA. How can I code in excel to to capture those departments listed and create a tab in worksheetB?

 

[Norie]

Sorry that doesn't make sense.

You want to create tabs in a worksheet?

Do you actually mean a workbook?

 

[shephardfamilyenterprise]

Sorry that doesn't make sense.

You want to create tabs in a worksheet?

Do you actually mean a workbook?

Yes, automatically.