Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I put button on spreadsheet to make it print a specific part? | Excel Worksheet Functions | |||
Make a 'Print button' | New Users to Excel | |||
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET | Excel Worksheet Functions | |||
Using VB to make certain field or button blink auto on new data | Excel Programming | |||
Make button to print Multiple occurences of item based on input | Excel Programming |