Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel printing
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=386058 |
#2
|
|||
|
|||
Hi
See http://www.rondebruin.nl/print.htm#Print -- Regards Ron de Bruin http://www.rondebruin.nl "neilwebb" wrote in message ... 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=386058 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Problems printing templates in Excel XP | Excel Discussion (Misc queries) | |||
Printing - different machines, same excel, printer and driver | Excel Discussion (Misc queries) | |||
How to prevent user from printing in Excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |