Labels and excel

  • Thread starter Thread starter SoundBytes
  • Start date Start date
S

SoundBytes

Hi
I have an excel sheet that I keep as a log, it looks something like

COMPANY NAME, SERIAL#, TEST PRESSURE, TEST DATE, PART NUMBER

under the heading goes the data, but now I need to print each line off as a
label to attach to the equipment we sell (very small pipes and equipment for
oil rigs) is it possible to print each line of data and the headings (above)
as a single
label? I want to pick a line of data and use the headings to print one label
or many for different bits of equipment or am I asking to much? I use Excel
2007 also 2003 help in either
would be great.

Please be as kind and as simple with your replies and if you ever need a
mechanical engineer I am your man :-)

thanks

Gordon
 
http://savefile.com/projects/808609774
Hi SoundBytes
Find attached link to sample that you referred to, its possible to do but
not practical if your list is long.
To use it you just need to "remove Set print Area" select the next row and
do a "Set print Area" ,your Heading will be on each print, see print
preview.
Like Gord said its not very practical if you have a lot of info to print.
Regards
Cimjet
 
Hi
Thanks for your hard work, the sample and links, I got there in the end

once again thanks :-)
 
Back
Top