Good afternoon all,
This may sound like a silly question. I think I've done this before on accident and I absolutely cannot remember what I did or find anything on Google pertaining to it, given I lack the knowledge of what I did to explain it in a Google Search.
I feel like it had something to do with named ranges and data validation, but nothing I see is coming to the solution I'm looking for.
I want to have a few named ranges all with static information. Let's say 1 column wide, 10 rows tall. I want to select some cell on the same worksheet and reference one of the named ranges. When this happens, all of the information inside of that named range is populated from the chosen cell. Best way I could explain it, is a drop down menu without the drop down. It just autofills in the data from a named range.
With the example below. Let's say I have 3 named ranges: LETTERS (A1:A5), NUMBERS (B1:B5), and COLORS (C1:C5)
If I select cell E1 and reference the named range "LETTERS" in some way (INDIRECT?), I want (starting at cell E1) the Named Range of values for LETTERS to populate into the cells below E1. So E1=A, E2=B, E3=C, and so on. Much like what it looks like in column H in the example. (Let's pretend column H is what I want column E to look like.) I'm looking for the data that is displayed there to change based on what Named Range is referenced. Therefore, if I instead referenced "COLORS", then I'd want E1=Red, E2=Green, etc. I'm aware that if I do this, I would always need enough vertical space below the cell that's referencing the ranges to be capable of filling in the cells below it.
If this isn't done with named ranges or anything related to what I said, that's totally fine. Just looking for how to get the outcome I have described.
Thank you for any help!
This may sound like a silly question. I think I've done this before on accident and I absolutely cannot remember what I did or find anything on Google pertaining to it, given I lack the knowledge of what I did to explain it in a Google Search.
I feel like it had something to do with named ranges and data validation, but nothing I see is coming to the solution I'm looking for.
I want to have a few named ranges all with static information. Let's say 1 column wide, 10 rows tall. I want to select some cell on the same worksheet and reference one of the named ranges. When this happens, all of the information inside of that named range is populated from the chosen cell. Best way I could explain it, is a drop down menu without the drop down. It just autofills in the data from a named range.
With the example below. Let's say I have 3 named ranges: LETTERS (A1:A5), NUMBERS (B1:B5), and COLORS (C1:C5)
If I select cell E1 and reference the named range "LETTERS" in some way (INDIRECT?), I want (starting at cell E1) the Named Range of values for LETTERS to populate into the cells below E1. So E1=A, E2=B, E3=C, and so on. Much like what it looks like in column H in the example. (Let's pretend column H is what I want column E to look like.) I'm looking for the data that is displayed there to change based on what Named Range is referenced. Therefore, if I instead referenced "COLORS", then I'd want E1=Red, E2=Green, etc. I'm aware that if I do this, I would always need enough vertical space below the cell that's referencing the ranges to be capable of filling in the cells below it.
If this isn't done with named ranges or anything related to what I said, that's totally fine. Just looking for how to get the outcome I have described.
Thank you for any help!