Posting this with the hope that I am not the first person to come up with this idea, and I hope I can be as clear and concise as possible in explaining it...
On worksheet 1, I have a set of data rows, arranged by location. On worksheet 2, I have laid out cells with vlookups to capture the various pieces of that data, based on location chosen from a cell list.
Is it possible to construct a macro or VBA that will copy any comments associated with cells on worksheet 1 related to the vlookup value selected on worksheet 2?
The end result should be that, when I selected a different location from the list on worksheet 1, the values relating to that location populate from worksheet 2 to worksheet 1(they do already), as do any comments that may be in any of those selected cells (they don't).
Thanks for any help hat comes my way!
On worksheet 1, I have a set of data rows, arranged by location. On worksheet 2, I have laid out cells with vlookups to capture the various pieces of that data, based on location chosen from a cell list.
Is it possible to construct a macro or VBA that will copy any comments associated with cells on worksheet 1 related to the vlookup value selected on worksheet 2?
The end result should be that, when I selected a different location from the list on worksheet 1, the values relating to that location populate from worksheet 2 to worksheet 1(they do already), as do any comments that may be in any of those selected cells (they don't).
Thanks for any help hat comes my way!