Hi there, I'm quite new to VBA and was trying to find a solution from previous threads to this question but I couldn't.
I would like to find a value on the left column and return a range of values on the same row: a sort of vlookup but returning a range instead of a single value.
In the simplified example below it would be: look for Animals in column B, copy Bird, Horse, Cat, Dog and paste them in another sheet. Then repeat for colours and paste Blue, Red, Yellow, Green in the second sheet below the previous.
Is it possible with a VBA vlookup or is necessary another function?
thanks!
Marc
I would like to find a value on the left column and return a range of values on the same row: a sort of vlookup but returning a range instead of a single value.
In the simplified example below it would be: look for Animals in column B, copy Bird, Horse, Cat, Dog and paste them in another sheet. Then repeat for colours and paste Blue, Red, Yellow, Green in the second sheet below the previous.
Is it possible with a VBA vlookup or is necessary another function?
thanks!
Marc