+ Reply to Thread
Results 1 to 27 of 27

print area poser

  1. #1
    Registered User
    Join Date
    06-20-2005
    Posts
    18

    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

  2. #2
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  3. #3
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  4. #4
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  5. #5
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  6. #6
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  7. #7
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  8. #8
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  9. #9
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  10. #10
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  11. #11
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  12. #12
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  13. #13
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  14. #14
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  15. #15
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  16. #16
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  17. #17
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  18. #18
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  19. #19
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  20. #20
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  21. #21
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  22. #22
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  23. #23
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  24. #24
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  25. #25
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

  26. #26
    Ron de Bruin
    Guest

    Re: print area poser

    Hi

    Do you want to print 50 pages with one row
    Am I correct ?



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "neilwebb" <[email protected]> wrote in message
    news:[email protected]...
    >
    > 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=386067
    >




  27. #27
    Dave Peterson
    Guest

    Re: 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=386067


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1