hi
im new to excel but learning.
i have a very simple database on one sheet. i also have a sheet formatted to print as a certificate. i wish to copy the info from cell a1 on database sheet into cell c7 on the second sheet,then cell a2 to c7 then e2 to g7. so i have populated the cert from certain cells from the first row. next print the cert and clear the contents. then go to the next row and repeat for that row. it needs to stop when it reaches an empty row.
im stuck on getting it to go back to the data sheet and select the next row. im hoping i can fit it all in one macro
any help would be gratefully received.