Hi,
I've been trying to find a way to look up a value from a list and return all entries from another worksheet, and when it's found it will move to another search criteria and repeat the same. Tried to use the index - array and small function but it will only return the first search criteria.
Tried to look for a VBA code but couldnt find one that matches what I'm looking for.
I have two worksheets
1) Result
2) Data (more than 50000 entries)
In the worksheet Result in column V I have search entries that I want to lookup, in column W I can see how many times this entry have been repeated in the worksheet Data
What I want the VBA to do is to look up the search criteria in column V (i.e cell V2) in worksheet Data and copy the enire row from column D in worksheet Data to the worksheet Result starting from A2 and repeat until all entries are found. When this is done the VBA will look up the entries for the next search criteria in column V (i.e cell V3) and continue until as long as value in column V>0 (because the value in column V is formula)
If the VBA works correctly the result should look like this
Many thanks in advance for the help!
I've been trying to find a way to look up a value from a list and return all entries from another worksheet, and when it's found it will move to another search criteria and repeat the same. Tried to use the index - array and small function but it will only return the first search criteria.
Tried to look for a VBA code but couldnt find one that matches what I'm looking for.
I have two worksheets
1) Result
2) Data (more than 50000 entries)
In the worksheet Result in column V I have search entries that I want to lookup, in column W I can see how many times this entry have been repeated in the worksheet Data
What I want the VBA to do is to look up the search criteria in column V (i.e cell V2) in worksheet Data and copy the enire row from column D in worksheet Data to the worksheet Result starting from A2 and repeat until all entries are found. When this is done the VBA will look up the entries for the next search criteria in column V (i.e cell V3) and continue until as long as value in column V>0 (because the value in column V is formula)
If the VBA works correctly the result should look like this
Many thanks in advance for the help!
