need to know if this is possible

want to automatically print data from sheet 1 via a print area in
sheet2

once it has printed the data, i need it to clear this data and read
from another row on sheet 1

all in all i need a single row print area in sheet 2 to read from about
50 different rows in sheet 1.

dont think its possible myself but what do you reckon????

regards

neil


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