Results 1 to 5 of 5

Need to create a single pdf that includes 4 pages created from the same Worksheet

Threaded View

button clicker Need to create a single pdf... 06-10-2020, 09:51 PM
Crooza Re: Need to create a single... 06-10-2020, 11:06 PM
ikboy Re: Need to create a single... 06-11-2020, 12:30 AM
jolivanes Re: Need to create a single... 06-11-2020, 12:52 AM
jolivanes Re: Need to create a single... 06-11-2020, 01:37 AM
  1. #1
    Registered User
    Join Date
    12-01-2016
    Location
    Birmingham, AL
    MS-Off Ver
    standard 2016
    Posts
    8

    Need to create a single pdf that includes 4 pages created from the same Worksheet

    Hello friends,

    I need to create a single pdf that includes 4 pages. The data for each sheet is on the same data set. I'd like to retain the row headers (ID) on each page and have a separate unique column on each page. I've included a wb with dummy data. I'm able to accomplish this if i split them up into their own sheets and loop through them(not what i need). however, my actual data set is much larger and would require me to duplicate data on too many extra worksheets. i'm thinking there is a more efficient way to accomplish this without duplicating data on additional sheets. I'm looking for a vba solution.

    ***Id Like to save as 1 PDF file that contains 4 pages
    Pg1 - Has Column A and B
    pg2 - has column A and C
    Pg3 - has column A and D
    Pg4 - has column A and E

    Really appreciate any advice,
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Saving to PDF includes blank pages?
    By taylorsm in forum Excel General
    Replies: 7
    Last Post: 08-04-2016, 12:02 PM
  2. Macro to print specific pages in a single worksheet (2007)
    By nibandit21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2016, 12:49 AM
  3. Replies: 1
    Last Post: 10-24-2014, 06:17 AM
  4. Create Multiple pages in Single word document
    By SathishKumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2013, 01:12 PM
  5. Query multiple pages into a single worksheet
    By chrissmorrow in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-14-2011, 05:36 PM
  6. Formula includes Worksheet Not Yet Created
    By hop17 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2009, 01:00 PM
  7. Single worksheet, multiple pages?
    By Peter in forum Excel General
    Replies: 9
    Last Post: 01-23-2005, 06:06 PM

Tags for this Thread

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