copy a cell value into a table based of the value of adjacent dropdown
good evening all,
having some trouble wrapping my head around this.
I have dropdowns in A4:A7 which draw values from A12:A101. there is a corresponding value in B12:B101 that gets displayed in B4:B7 when a value is selected from the dropdown. i would like to add an “update cell” in C4:C7 that would update the values in B12:B101 when a new value is entered.
i have a stripped down version to show what ive got so far
any help is appreciated
good evening all, having some trouble wrapping my head around this. I have dropdowns in A4:A7 which draw values from A12:A101. there is a corresponding value in B12:B101 that gets displayed in B4:B7 when a value is selected from the dropdown. i would like to add an “update cell” in C4:C7 that would update the values in B12:B101 when a new value is entered. i have a stripped down version to show what ive got so far any help is appreciated GRAWtest.xlsx Read More
