Next, 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
This is to prevent the customer from printing blank tabs that do not have data that coorespond to it. The last formula worked great!!! Thanks.