+ Reply to Thread
Results 1 to 3 of 3

List selection populations multiple cells including formatting

  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    Surrey
    MS-Off Ver
    2010
    Posts
    9

    Wink List selection populations multiple cells including formatting

    Morning folks,

    Hands up, I'm abit of an excel amateur. Hoping for abit of guidance and assistance.

    -I've got a drop down list with 20 options.

    -Each time the list of dropped down and 1 of the 20 options are selected I want the cells below to paste a selected cells layout I have created on sheet 3.

    Basically, 1) is this even possible 2) how to do it?

    I have my list of options on sheet 1, and I have my cell layouts per option on sheet 3.

    Example:

    If I select "Increase/Decrease in pipe depth greater than 50%" from the list on sheet 1, the beige space below needs to populate the 3 boxes on sheet 3 that can be found under the same title "Increase/Decrease in pipe depth greater than 50%".

    Any and all thoughts on the matter are welcome.

    cheers.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-08-2014
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    87

    Re: List selection populations multiple cells including formatting

    Looks like you've got a good start; a few comments to get started:

    - Passing the format from Sheet 3 to Sheet 1 is going to require VBA/macro. Is that agreeable to you?

    - Including your drop-down content on Sheet 1 (T12:T31) is helpful for visibility, but limits your flexibility. I'd suggest moving it to a separate sheet before you proceed.

    If you're comfortable with some VBA, a slight restructure of your file may be all you need...awaiting your confirmation before giving it any more attention.

  3. #3
    Registered User
    Join Date
    02-19-2018
    Location
    Surrey
    MS-Off Ver
    2010
    Posts
    9

    Re: List selection populations multiple cells including formatting

    Good morning Eibi,

    I'm absolutely open to ideas.

    The whole idea is try to keep the layout as simple as possible. It must remain as user friendly (idiot proof) as possible for the avoidance of human error.

    I confirm please tinker with it how you see fit to achieve my vague outline.

    I'm excited to see the outcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help having a drop down list change multiple cells depending on the list selection
    By jennis7242 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 08-12-2017, 01:20 PM
  2. Replies: 0
    Last Post: 06-22-2017, 08:37 AM
  3. Replies: 1
    Last Post: 10-18-2016, 03:25 AM
  4. Replies: 6
    Last Post: 10-29-2015, 03:38 PM
  5. [SOLVED] From drop down list selection populate multiple Cells
    By logcabin123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2012, 12:43 PM
  6. Multiple selection from pick list - only some cells work
    By markfranklin99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2012, 11:20 PM
  7. Replies: 8
    Last Post: 07-02-2009, 07:13 PM

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