Hello kind folks,Im trying to set up a workbook that copies cells A-J into another workbook if cell K is a certain number.Say if Cell K1=1 then copy cells A1-J1 into different workbook and so on.Cell K1 might be updated daily and all workbooks are copied to another each week.Thanks for your help.............................Lou