+ Reply to Thread
Results 1 to 6 of 6

Reference an entire worksheet within a work book?

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    Danville, VA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Reference an entire worksheet within a work book?

    Is it even possible to have a drop down list that my customers can use to select 1 of 15 models Each of the models has a different template for options and pricing, but I do not want 15 worksheets spread across the bottom. Can the drop down list reference an entire worksheet and populate it onto my "main" order page?

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Reference an entire worksheet within a work book?

    you could do this with a macro, on selecting the correct model it will be copied into the workbook. or you could set up a group of hyperlinks where the user could click on which sheet they want to use, and be taken directly to that one. But that would require all sheets are visable.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    03-08-2012
    Location
    Danville, VA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Reference an entire worksheet within a work book?

    Macros are out of my league....

    I might have to find another way to get all of the information in there.....

    Do you have any suggestions on how I could learn macros? I dont have time for a full blown excel class. Thanks so much for the reply!

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Reference an entire worksheet within a work book?

    If you provide a sample workbook i can probably help you out with this one, but as for how to learn, there are verious resources out on the internet, but i am self taught. Just kind of had to learn as i went and figure things out, but there are alot of resources available online.

  5. #5
    Registered User
    Join Date
    03-08-2012
    Location
    Danville, VA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Reference an entire worksheet within a work book?

    I see...I am self taught as well, but I've never tackled the macros. I'm not a programmer just a guy who loves excel!

    As for my problem I am going to use the VLOOKUP function. My first page will be the main template. There are very few differences in the size of the quote forms so I think I can make it work like this, but I really appreciate the help!

  6. #6
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Reference an entire worksheet within a work book?

    the problem you will encounter if you use VLOOKUP is that any formula that is intended for use in the quote form, will not work on the main page when you pull it, as it is only refrenceing the other hidden sheet.

+ 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