Hello
I have one excel file with 4 sheets.
all 4 sheets have the same columns.
the first three sheets have different values but all contains in the first column a serial and all the other colums contain data about each serial
and the fourth sheet use index match to show all the information of the serial i type to it.
i want to use the fourth sheet to update values of specific codes.
for ex.
if i type in the first column in the fourth sheet:
746746746
11111111
54646544564
5465456465444
it will show all the information regrading these serials but unfortunatly i cant update values in this sheets because the index match formula will be destroyed.
i just want to make the values update easier.
maybe a vba code or something else.
thank you very much!
I have one excel file with 4 sheets.
all 4 sheets have the same columns.
the first three sheets have different values but all contains in the first column a serial and all the other colums contain data about each serial
and the fourth sheet use index match to show all the information of the serial i type to it.
i want to use the fourth sheet to update values of specific codes.
for ex.
if i type in the first column in the fourth sheet:
746746746
11111111
54646544564
5465456465444
it will show all the information regrading these serials but unfortunatly i cant update values in this sheets because the index match formula will be destroyed.
i just want to make the values update easier.
maybe a vba code or something else.
thank you very much!
