[FONT="]Hi everyone,[/FONT]
[FONT="] I have just a questions regarding editing data after using a function result.[/FONT]
[FONT="]I have a multi sheet workbook that runs from a master sheet matrix that has numerous cells of data. As such on the first sheet (TOC) I have an Index Match Match formula that when two criteria are entered the result shows what I am looking for. I.e. is employee X trained on PT Y? Answer= Trained/ Not Trained etc.[/FONT]
[FONT="]I am now wondering is there a way that if I edit this result it will edit the master data. As say the result says not trained, if I change this to trained on the search result it will change the master matrix.[/FONT]
[FONT="]The other sheets in the workbook all feed from this master also.
Below is the formula that I used.
=INDEX(Master!B3:GQ420,MATCH(TOC!H6,Master!B3:B420,0), MATCH(TOC!H5,Master!B3:GQ3,0))
I also have a formula hidden that gives the cell address of the INDEX result:
=CELL("address",INDEX(Master!B3:GQ420,MATCH(TOC!H6,Master!B3:B420,0), MATCH(TOC!H5,Master!B3:GQ3,0)))[/FONT]
[FONT="]
So basically is there a function or macro that if I set up a second input section for a user they can then enter a new value for the cell referenced in the INDEX formula
Thanks[/FONT]
[FONT="] I have just a questions regarding editing data after using a function result.[/FONT]
[FONT="]I have a multi sheet workbook that runs from a master sheet matrix that has numerous cells of data. As such on the first sheet (TOC) I have an Index Match Match formula that when two criteria are entered the result shows what I am looking for. I.e. is employee X trained on PT Y? Answer= Trained/ Not Trained etc.[/FONT]
[FONT="]I am now wondering is there a way that if I edit this result it will edit the master data. As say the result says not trained, if I change this to trained on the search result it will change the master matrix.[/FONT]
[FONT="]The other sheets in the workbook all feed from this master also.
Below is the formula that I used.
=INDEX(Master!B3:GQ420,MATCH(TOC!H6,Master!B3:B420,0), MATCH(TOC!H5,Master!B3:GQ3,0))
I also have a formula hidden that gives the cell address of the INDEX result:
=CELL("address",INDEX(Master!B3:GQ420,MATCH(TOC!H6,Master!B3:B420,0), MATCH(TOC!H5,Master!B3:GQ3,0)))[/FONT]
[FONT="]
So basically is there a function or macro that if I set up a second input section for a user they can then enter a new value for the cell referenced in the INDEX formula
Thanks[/FONT]