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??


--
neilwebb
------------------------------------------------------------------------
neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450
View this thread: http://www.excelforum.com/showthread...hreadid=386060

Do you ever order a home delivery takeaway pizzas, accept the first that
turns up at your door and send the rest away because you already have
one?

My point? Don't post the same question under each different category.
It will get seen whichever category it's under and it won't **** off
someone who is prepared to answer your question.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386060

You've gotten a couple replies to your different threads in .excel.

neilwebb wrote:

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??

--
neilwebb
------------------------------------------------------------------------
neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450
View this thread: http://www.excelforum.com/showthread...hreadid=386060

--

Dave Peterson