How do I make a button to print data from a row?

[Guest]

i am working on a inventory log for my work. I need to be able to take a
range of data from a row and copy it to another sheet and print tags for
data with out having to copy and paste..

Coil No. Gauge Width Type Finish Color Texture Date Rec. Weight


i would like to take the info from these fields and move and print with a
button or check box. can you help?

 

[NickHK]

"to take a range of data from a row and copy it to another sheet"
Record a macro whilst you perform this manually.
If you need some flexibility in the Paste (e.g. to the end of the current
data), post back with requirements.

"and print tags for data with out having to copy and paste"
Not sure what this means. Which "tags" ?

NickHK

 

[Dave Peterson]

Are you doing lots of these tags?

If you are, you may want to look here:
http://contextures.com/xlForm03.html
(From Debra Dalgleish's site)

 

[Dave Peterson]

PMFJI, I bet that tags are physical tags--paper/labels printed with information
from the database worksheet.

Not anything to do with Tags in excel.

Sometimes, a cigar is just a cigar <vbg>.