excel printing

[neilwebb]

hi all

i am using excel 2002 and windows xp.

i have a spreadsheet with 2 seperate worksheets. sheet 1 has data
inputted into it from a software package called winwedge. it is purely
numerical data. the data is inputted into excel one number at a time.
an example of a number would be 50.123. this would occur approximately
50-75 times a day and this data needs to be kept for statistical
analysis.

sheet 2 is purely for printing out the individual data once it has been
imported into worksheet 1. i need sheet 2 to print out the data
automatically when it is entered in sheet 1.

i have solved this problem with a little help using a macro. as soon as
data is entered into sheet 1, it prints out what is in the print area of
sheet 2.

my problem is that i dont know how to set the print area up so that it
only prints the newest piece of data that has been inputted into sheet
1

how do i set this up??

 

[Dave Peterson]

I guess it depends on how that sheet2 is laid out.

Maybe you could record a macro that sets the printarea and then modify it to use
just the new stuff. And use it in a procedure to print.