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

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?

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

"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

"Teknomek" wrote in message
...
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?

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

Are you doing lots of these tags?

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

Teknomek wrote:

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?

--

Dave Peterson

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

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.

NickHK wrote:

"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

"Teknomek" wrote in message
...
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?

--

Dave Peterson