HI
i have a sheet with a simple database with one row per item. i have a sheet formatted as a certificate. from the data base sheet i wish to select a cell and copy the info into a cell on the certificate then select another cell on the same row on the data sheet and copy to a cell on certificate sheet. so on data sheet cell a2 would be copied to cell j7 on cert sheet. b2 on data sheet to c7 and e2 to g7. then print the cert. next go back to data sheet and repeat for the next row until it reaches a empty row. so basically im printing a cert for each row of the data base. ive named the data sheet DATA and the certificate sheet CERT i was going to use a simple macro via a shortcut key.