I need a macro where I use the vlookup formula to get data from a different sheet, where multiple values may be retrieved, then inserting data into the next cell over (to the right) creating a running list. Eg:
Lookup value is in column a. Retrieve data and put into column b. When more data is retrieved, data in column b moves over to column c and newest data is held in column b. Either done automatically as a value is retrieved in vlookup, or alternatively, if the macro has to be manually run (eg assign to a button), when data retrieved has no value, cells are not moved to the right. To help you understand better, I am looking up a result (vlookup by location in col a) and I want to keep the most recent result in column b, moving data to the right whenever a new result is retrieved. I hope I explained this ok.. If not, just let me know and I'll c if I can give u a visual example. Hope u can help!
Lookup value is in column a. Retrieve data and put into column b. When more data is retrieved, data in column b moves over to column c and newest data is held in column b. Either done automatically as a value is retrieved in vlookup, or alternatively, if the macro has to be manually run (eg assign to a button), when data retrieved has no value, cells are not moved to the right. To help you understand better, I am looking up a result (vlookup by location in col a) and I want to keep the most recent result in column b, moving data to the right whenever a new result is retrieved. I hope I explained this ok.. If not, just let me know and I'll c if I can give u a visual example. Hope u can help!
