Hello,
This is the problem:
In Sheet1 I made drop down menu with some text data from Sheet2.
For example five colors: blue, yellow, black, white and red.
How:
In Sheet2 those colors are in one column, each color in it’s own cell, one below the other, so I selected those cells, named that range (if that selection of cells is called “range” in Excel?) “Colors” and then in Sheet1 in a specific cell I did: Data/Validation/Settings/Validation Criteria-Allow: List-Source: =Colors.
So now I have a drop down menu in Sheet1 from which I can choose any of those five colors that are in one column in Sheet2.
Among other things in that Sheet2 I have also things that are of some specific color.
Those things are also in columns of their own.
For example I have a column with six things that are of the same color, each thing in a single cell, one below the other.
So I want when I pick a single color from a drop down menu in Sheet1, those things that are of that color (data from a column in a Sheet2) to appear below that cell in Sheet1, in six cells to be specific, each thing in it’s own cell, just like the way that they are in that column in a Sheet2.
Cells are exactly the same in size and in Format.
Please help, my English is not so good, neither is a knowledge of Excel for that matter, I hope that I explained well enough what is my problem.
Bookmarks