If any one of cells B31 to B46 = Booked I need to copy the sheet named 'Booked' from the workbook I am in to another workbook.
When my Macro creates the second workbook I use:
Dim k As Workbook
Set k = ActiveWorkbook
So I would need to copy the sheet from mt Activeworkbook to k [workbook]
Would appreciate an Experts help