Mr. Walnuts
Board Regular
- Joined
- Aug 8, 2005
- Messages
- 176
I am using the INDEX function currently on a roster I have set up. The way it is set up is as follows:
Sheet 3 = Main database with all information stored. 20 columns, each column's range is named to make indexing easier. Column A contains personnel names, and subsequent columns contain information on the person named in column A.
Sheet 1 contains a header row consisting of 13 of the 20 column titles from the database sheet. Column A on sheet 1 contains list boxes in each cell from the "Names" column in the database sheet. upon choosing a name from the drop box, the index function fills in the cells in the 12 cells adjacent to the name box with the information it indexed on the database.
Here is my question.
If I wanted to use this same methodology for indexing using not only the names column... but I woud like the header row cells to be drop down boxes as well. this way I could not only choose the personnel whose information to index... but also the information. is this posible?
Sheet 3 = Main database with all information stored. 20 columns, each column's range is named to make indexing easier. Column A contains personnel names, and subsequent columns contain information on the person named in column A.
Sheet 1 contains a header row consisting of 13 of the 20 column titles from the database sheet. Column A on sheet 1 contains list boxes in each cell from the "Names" column in the database sheet. upon choosing a name from the drop box, the index function fills in the cells in the 12 cells adjacent to the name box with the information it indexed on the database.
Here is my question.
If I wanted to use this same methodology for indexing using not only the names column... but I woud like the header row cells to be drop down boxes as well. this way I could not only choose the personnel whose information to index... but also the information. is this posible?