You wrote:
hi bruce

thanks so much for the help with the automatic printing in microsoft
excel.

the code that you sent works a treat!! However......

it only works for the first time on a new sheet.

what i want to be able to do is import say 100 numbers per day and each
one of them print off individually. how do i get sheet 2 to print off
just the new data and not the other data??

i have enclosed a copy of the sheet that i have deigned. you will see
the red numbers on sheet 1. each of these numbers needs a seperate
print out, but we also need to keep the numbers for SPC and chart
values. i hope i am explaining this clear enough??

in summary

when winwedge inputs the data to excel, i need it to print that data on
sheet 2 - it does this now thanks to your code

what i now need it to do is be able to do that up to 100 times per day
and print out each individual value but also keep them all for SPC.

i hope you understand this, if not, please conact me with any
questions

regards

What you ask will require specific coding to read the current row, set
the print area to that row only, print the sheet then clear the print
area. You will need assistance from others in the forum with better
VBA skills than I possess. I am reposting this hoping someone will
jump in with some ideas.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382388