For each row in C1:C100 that has anything in it I need to take what’s in column H and paste special valve into column A, so if C1 had something in it, it would take what’s in H1 and paste special valve in A1 then check the other rows, if there is not anything in column C it should go to the next row. I am using excel 97. thanks