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?

"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" <(E-Mail Removed)> wrote in message
news:51FAD7F5-0D8A-43FA-9E8B-(E-Mail Removed)...
> 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?

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)

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

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" <(E-Mail Removed)> wrote in message
> news:51FAD7F5-0D8A-43FA-9E8B-(E-Mail Removed)...
> > 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