I'm working on an easy If macro. I have 13 cells (H10-H22). I just need a macro that says if there is data in H10 copy and paste to another sheet. If data is in H11 copy and past....etc. Sometimes there may only be something in H10, others H10-H22 will all be filled out. The other sheet would just be Sheet2 cell A1-A13. Any suggestions?