Save "Dynamic" sheet in workbook If cell = . To another location

Hi all,
The bellow code is for printing sheets in a work book if cell J8 = True.

Please Login or Register  to view this content.

But now I want to add onto it.

So at the same time it prints, it also saves the sheets it's printing to a different file on the desktop .xls , where the name of the file = Consignment + cell "H11" on all sheets that return a true status in cell "J1"

But saved without the code(unless it doesn't matter), just the info in the cells. This way the newly saved file won't point to a cell on a workbook that is constantly changed.

eg. of file name it's saved as

Consignment
Cell "J1" = True
Cell "H11" = ERO 0001

IE. Consignment ERO0001

Please Login or Register  to view this content.

^^ is just to give an idea of the name etc and location.

If need be I can supply the workbook in question minus some data.

Cheers for the help

Damo

Why are you repeating the Printout line 3 times? Something like this

Please Login or Register  to view this content.

Try this amended code

Please Login or Register  to view this content.

This should work

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.