Hiya,
I am considering the possibility of using some VBA to lookup a range values from a different worksheet and use the returned result as the comment in the same range of lookup cells.
This would need to update on worksheet change.
I've attached an example of what I would imagine the spreadsheet would look like. It should lookup the values in 'MainTable'$A$2:$A$6 on 'Data'$A$2:$A$6. If it finds the value, it should return a concatenation of the relevant "Field2 - Field 3 - Field 4" in the original lookup table. Replace any comments that are currently in there.
Is that possible?
Many thanks
I am considering the possibility of using some VBA to lookup a range values from a different worksheet and use the returned result as the comment in the same range of lookup cells.
This would need to update on worksheet change.
I've attached an example of what I would imagine the spreadsheet would look like. It should lookup the values in 'MainTable'$A$2:$A$6 on 'Data'$A$2:$A$6. If it finds the value, it should return a concatenation of the relevant "Field2 - Field 3 - Field 4" in the original lookup table. Replace any comments that are currently in there.
Is that possible?
Many thanks