Print macro

[rehtnap2008]

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.

[JBeaucaire]

So, on the DATA sheet, we'll start at row2 and move down, yes?

Try this:

Please Login or Register  to view this content.

[rehtnap2008]

hi
the debugger stops the process on the sub printcerts() i cut and paste ur code as sent into a shortcut key macro.

[JBeaucaire]

The debugger highlights which line of code?

It would quickest if I could just look at your sheet with the macro installed and behaving unexpectedly. Click GO ADVANCED and use the paperclip icon to post up your workbook with some sample data still in it.

[rehtnap2008]

hi
this should be it

[JBeaucaire]

I've highlighted some code above...these appear to be missing from your copy/paste. Recopy the code into your sheet.

[royUK]

I can't see why you need VBA, this could be done with VLOOKUP

[rehtnap2008]

sorry my fault redone but still fails

[JBeaucaire]

Actually, it does work for me as far as cycling through and printing all the individual sheets...but your merged cells cause the final line of code to fail. So change that to:

Please Login or Register  to view this content.

...should be good to go from there.

[JBeaucaire]

I can't see why you need VBA, this could be done with VLOOKUP

VBA is required to put the values in the correct cells at the top of the form and print, then repeat ad nauseum for all the values listed on the DATA sheet all in one step.

[JBeaucaire]

If it's the SHORTCUT you're trying to get added...

1) Press ALT-F8 from the main worksheet
2) Click once on the macro
3) Click on OPTIONS
4) Put in the shortcut key

[rehtnap2008]

hi
sorry for delay in replying my excel crashed. it was the shortcut id done wrong.
now i can see how the code works its so much easier.
thanks for bearing with me.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)