Excel 2007 : How to copy certain cells to a different workbook, if a single cell is#

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

Gonna bump this one.If anyone has the time to help.Thanks Lou