I have a workbook with 2 sheets, a data sheet "Data" and a calculations sheet "Calcs". Looking to add a command button on "Calcs" sheet. When button is activated the macro finds all rows on "Data" sheet that are "Yellow" and updates range of cells in column x with the current date. At the same time the data from cells a1, b1,c1 (on "calcs" sheet) is copied to cells f1, g1,h1. (x & a1... & f1... are just examples not actual cell id's. And finally once command button has been activeted and run I want to deactivate the command button so it cannot be used again if there is data or value is number 0 in cells f1,g1,h1. The command button will be in cell f8.