Forum Discussion
VBA code: report value in a selected column
My sense is that you're trying to accomplish something that can fairly readily be done with some of the new dynamic array functions. Or by using Power Query. That is to say, the VBA code is probably unnecessary. Excel has really remarkable abilities to extract data from tables according to specified criteria.
It's not really clear, though, what the desired results are. Could you back up and describe--in plain ol' English words-- what you're trying to do when you combine the customer data with the car data?
hi mathetes,
what I’m trying to achieve is reporting the missing values of columns A respective to each row in cars and customers, meaning the customer name for the orange colored rows and the inventory number for the green colored rows.
As you see from the image, for every entry in “result”, it only reports the car, color and interior.
