9!GR@BzyQ37b
03-06-2020, 03:57 AM
Hi,
VBA is new for me and I searching for a solution, but I could find anything yet. Maybe someone would help me.
I would like to use vlookup in vba and the problem is that the vlookup has to search in multiple worksheets. And the worksheets could be variable. So sometimes I have 15 worksheets and sometimes 25.
This is want I want:
On the last worksheet I have in column A een range of numbers. And I want to search a specific value that belongs to one of these numbers. But this values is standing on one of the worksheets.
I've attached an example, so it helps you to understood me.
Thanks for your help!
Costertje
VBA is new for me and I searching for a solution, but I could find anything yet. Maybe someone would help me.
I would like to use vlookup in vba and the problem is that the vlookup has to search in multiple worksheets. And the worksheets could be variable. So sometimes I have 15 worksheets and sometimes 25.
This is want I want:
On the last worksheet I have in column A een range of numbers. And I want to search a specific value that belongs to one of these numbers. But this values is standing on one of the worksheets.
I've attached an example, so it helps you to understood me.
Thanks for your help!
Costertje