I've spent about 4 hours trying to get a formula in a set of columns/rows to properly behave. I've attached the WB and am hoping someone will take a quick look and see what I have done wrong. There are two Name Ranges (Industry and Columntable).
The use is simple. I want to select an industry (right now there are but 2 -- Banking & Insurance). Once selected, all the ASSOCIATED records, only for that industry, are displayed and you can then see the relationship of the cells. I want to be able to then change or update an individual record so that it is reflected back in the Data Base.
Attached how I would do.
I changed your name definition and I separated the index column (A).
You need to confirm the formula in this column with Ctrl+Shift+Enter.
Thank you! What you provided me works! There are two things that need to be taken into consideration.
1.) How do I get it to not execute if the max. number of industry records are reached? So in Insurance there are 13 records and on Banking there are 16 records. Is there a way to not have the formulas show up if there is no associated industry record?
2.) I'm going to have to figure out how I can update a record in the maintenance tab that automatically updates the DB....but I'm going to hold that for the next question.
Attached how I would do.
I changed your name definition and I separated the index column (A).
You need to confirm the formula in this column with Ctrl+Shift+Enter.
Cheers,
Kris