Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Multiple Worksheets

    I have an Excel 2000 workbook that contains eight worksheets. I want to print three of those worksheets as a report. But I don't want each worksheet to start on a new piece of paper. I'd like the contents of sheet1 to appear (say it takes up 20 rows), then the contents of sheet3 on the same sheet of paper ... and so on. Any suggestions?!

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Worksheets

    Perhaps you can record a macro to take the data you want, and paste it to a newly created sheet. If you need to be able to specify, you can then re-write the code (we can help) to ask the user what s/he needs.

    Hope this helps!

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Worksheets

    Thanks!
    I had looked at doing that. The problem is, the columns on each of the different sheets are different widths, etc., so formatting on the new sheet would be an issue. I could also export the data to Word, though I know that would require VBA, and my knowledge is very limited.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Worksheets

    IC...

    If you right click on the sheet, and select Move or Copy, you can re-create the sheet with the formatting you like at the end of your workbook, it's then just a matter of selecting all cells you would like deleting and pressing 'delete.' The macro will record all this while you're doing it, so you can see how the system interprets your movements, and make changes accordingly.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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