Results 1 to 12 of 12

using dropdown lists to populate range of cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    florida
    MS-Off Ver
    mac 2008
    Posts
    63

    using dropdown lists to populate range of cells

    I am working on making advanced sheets for strength and conditioning programming, and i need a bit of help...the first thing I am trying to do is make a dropdown on the actual sheet and being able to select a series of programs they can train with, and when you click it, it will auto populate an entire range of cells with the programming information. on the sheet i have attached, under the Master tab, near the top left where it says "Bench Press", under it it says "Programs". I want to make that cell a dropdown list where you can select either 531 or 5x5, both of which are entire tables set up and ready on the Source tab, and when you click say 531 the entire 531 table from the source tab populates the accompanying tables, or if you click 5x5 it changes the cells accordingly. is this possible, and can anyone help with this? we are working on becoming excel masters in terms of strength and conditioning, this is just the beginning! thanks
    Attached Files Attached Files
    Last edited by tsiguy96; 03-16-2012 at 10:52 AM.

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