Hi all
This is my first post - I really wish I had found this forum years ago!
I am trying to create an income/expenditure spreadsheet for my sporting club.
What I would like is to have a cell titled "Category" and the next one titled "Sub Category"
In the "Category" cell, there would be a drop down box with a list of categories, and when one is selected, the "Sub Category" cell would display only the sub categories of the specified category.
I have tried to do this with the two links below without much luck - either the sub category cell works correctly for the first row, then after that it is stuck with the category from row 1 or, in the horizontal array example, I only see the first column of the sub category.
I have attached an example spreadsheet
Thanks in advance
Adam
http://excelsemipro.com/2012/04/a-d...-down-list-with-a-horizontal-table-reference/
http://www.excel-easy.com/examples/dependent-drop-down-lists.html
This is my first post - I really wish I had found this forum years ago!
I am trying to create an income/expenditure spreadsheet for my sporting club.
What I would like is to have a cell titled "Category" and the next one titled "Sub Category"
In the "Category" cell, there would be a drop down box with a list of categories, and when one is selected, the "Sub Category" cell would display only the sub categories of the specified category.
I have tried to do this with the two links below without much luck - either the sub category cell works correctly for the first row, then after that it is stuck with the category from row 1 or, in the horizontal array example, I only see the first column of the sub category.
I have attached an example spreadsheet
Thanks in advance
Adam
http://excelsemipro.com/2012/04/a-d...-down-list-with-a-horizontal-table-reference/
http://www.excel-easy.com/examples/dependent-drop-down-lists.html
