hi, is there any way i can take a 'snapshot' of a range of cell values and copy them into a specified range on the same sheet if F50=1? I dont want to just copy them as the cells update and change every minute and i just want the values when F50=1. I would like the same to apply to each open sheet on the workbook, as they all have F50 as a 'trigger' and the cells to be copied are the same range

regards, jamie