Thank you for looking at my question,
I started in on this and very quickly realised I was in over my head,
I have data in a worksheet, the Project is in Range("A2") and the Item is in Range("B2")
In the On-Click event of a userform button I need to :
1. Check Directory "Projects" to see if there is a workbook named with the value in Range("A2") - if it isn't there create it.
2. Create/Overwrite a worksheet in the target workbook named after the value in Range("B2") with the values and conditional formatting from the source worksheet.
Any help you can offer will be greatly appreciated.