print area poser
 

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=386066

print area poser
 

If you are putting the data in Sheet1 with a macro, then at that point,
define the printarea in sheet 2 based on your macros knowledge of where it
put the data in sheet2. then issue the print command.

Beyond that, you information is too vague to imagine what you want to do.

--
Regards,
Tom Ogilvy

"neilwebb" wrote in
message ...

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=386066

print area poser
 

You have a couple of replies to your posts in .excel.

neilwebb wrote:

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=386066

--

Dave Peterson

print area poser
 

both of which agree that you have not provided enough information to provide
much help specific help.

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
You have a couple of replies to your posts in .excel.

neilwebb wrote:

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=386066

--

Dave Peterson

print area poser
 

Yep.

But after reading 7 messages in 5 groups. I wanted to give a warning that the
message was multiposted.

(and "you = OP" in this case??)

Tom Ogilvy wrote:

both of which agree that you have not provided enough information to provide
much help specific help.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
You have a couple of replies to your posts in .excel.

neilwebb wrote:

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=386066

--

Dave Peterson

--

Dave Peterson