Hello everyone,
I am working on a VB project that I need to vlookup some data from some workbooks. My first thought was just to copy the sheets to my current workbook and use this helpful function:
Vlookup. Excel Vlookup Across Excel Worksheets. Custom VLookup Formula/Function
To do the vlookuping across all the sheets. However, this is getting to be problematic. The Excel files that I am copying are each over 25 MB and it is really taking the macro a long time to run.
Anyone have any suggestions as to how to accomplish this vlookuping without copying all the data over to the new workbook.
I need to be able to look across 6 or 7 sheets for the thing I am using vlookup on. There will only be one of each entry so I don't have to worry about multiples. I also can't be certain at runtime how many worksheets are on the books that I was previously copying so I need something that looks through all the sheets in a given workbook.
Anyone have any suggestions for this?
I am working on a VB project that I need to vlookup some data from some workbooks. My first thought was just to copy the sheets to my current workbook and use this helpful function:
Vlookup. Excel Vlookup Across Excel Worksheets. Custom VLookup Formula/Function
To do the vlookuping across all the sheets. However, this is getting to be problematic. The Excel files that I am copying are each over 25 MB and it is really taking the macro a long time to run.
Anyone have any suggestions as to how to accomplish this vlookuping without copying all the data over to the new workbook.
I need to be able to look across 6 or 7 sheets for the thing I am using vlookup on. There will only be one of each entry so I don't have to worry about multiples. I also can't be certain at runtime how many worksheets are on the books that I was previously copying so I need something that looks through all the sheets in a given workbook.
Anyone have any suggestions for this?
