I am making a workbook in Excel that has multiple sheets. On the first sheet, which is called "Hierarchy" I list categories for companies. We'll call them A, B, C, D, and E. They are in cells A4:A8. On the next sheet "Companies" I list companies, with a column for assigning them into one of those categories. I need to populate a dropdown for that with the values I created on the previous page. I'm stuck though, because although I can do this swimmingly for the first row, I do not know how to get the exact same values to show up in rows below that.
How can I get this dropdown to appear in every row without dynamically changing its dropdown choices?
Currently, I can use Data Validation to pull a list based on a table on the Hierarchy page. However, when I try to copy and paste that dropdown (which uses that A4:A* range) it adds a digit to both the start and stop point, meaning the second row gets a range of A5:A9, the third one of A6:A10, and so on. I don't want the cells it draws from on the table to change. I want them exactly the same, over and over.
How do I accomplish this? |