macro for printing filled out forms

[asdf_random]

Hi,

I'm trying to write a VBA macro that selects the data across a row from 3 different columns, and then prints. That is, it prints it out on a specialized form with boxes for the name and various other information.

Basically, what I have an excel sheet with 3 columns
Name Info Date
A 1 4/14/09
B 2 ..
C 3
D 4
E 5

And so on. I want to take a row, so like A,I, and 4/14/09 and then print them out respectively in their correct positions on a specialized paper form, rather than having to write out the names and info all in by hand.

Unfortunately, i'm not too experienced with VBA, could anyone help?

Thanks.

[Leith Ross]

Hello asdf_random,

Welcome to the Forum!

If your data is being entered by hand, you should consider using Word rather than Excel. Adjusting Excel's printout to match a preprinted form can be difficult, if not impossible, to do. If your form had been designed from your worksheet layout then it would be easy to have the information align with the boxes on the form.