Dear all

I have 9000 sheets + into a folder and I would like to compile them all into different workbooks based on the content of cell B2...

So far I have the following code (which works great) but I do not know how to do multiple IF... or IF within IF... 

Please Login or Register  to view this content.
Where and how would I tell it to check the text content of cell B2 in each of the sheets and if text=blue then copy else do nothing??

Many thanks for sharing your expertise!!