Currently stumped with a project I'm working on. I have a worksheet with a column of uniquely named security IDs, and a column next to it with a name of a corresponding workbooks. That other workbooks listed have a table containing some of those securities in column a, and in column b is the name of a tab which contains information on cash flows from those securities. In all there are 8 separate workbooks containing the cashflow information.
I would like to automate the process of searching for the cashflow information. Is there a way to open the specific sheet using the security ID as a catalyst? I was trying to think of a way to run a macro where it would open the sheet using the sheet value from an iferror(vlookup...) string to cycle through the workbooks. I'm unsure how to perform the open sheet function and am unsure if the iferror vlookup search is the most efficient way to do this. Any advice is much appreciated.
I would like to automate the process of searching for the cashflow information. Is there a way to open the specific sheet using the security ID as a catalyst? I was trying to think of a way to run a macro where it would open the sheet using the sheet value from an iferror(vlookup...) string to cycle through the workbooks. I'm unsure how to perform the open sheet function and am unsure if the iferror vlookup search is the most efficient way to do this. Any advice is much appreciated.