Hope someone can help me,
I have spent many hours trying to come up with a vlookup macro function that would search for a chosen value on all the workbooks in a certain folder and give me the output. The issue is that on all those other workbooks they all have many sheets so the function would have to loop through all the sheets in every workbook to find the value. So to summarize:
take value from all inputs in column A starting from A2, vlookup on all different workbooks (and worksheets inside those workbooks) for this value, give me the desired values in the 5th collumn from those workbooks back in the original worksheet I ran the macro from on Column B.
Please help as I have spent MANY hours trying to get this done with no success...
I have spent many hours trying to come up with a vlookup macro function that would search for a chosen value on all the workbooks in a certain folder and give me the output. The issue is that on all those other workbooks they all have many sheets so the function would have to loop through all the sheets in every workbook to find the value. So to summarize:
take value from all inputs in column A starting from A2, vlookup on all different workbooks (and worksheets inside those workbooks) for this value, give me the desired values in the 5th collumn from those workbooks back in the original worksheet I ran the macro from on Column B.
Please help as I have spent MANY hours trying to get this done with no success...