I was curious if there is a way to dynamically reference a worksheet in a different excel file without using the INDIRECT function. At this point I am using INDIRECT but it requires that the worksheet I am referencing be opened so I am trying to see if there is a way to dynamically reference without having the sheet being referenced open. Thanks for the help!
Bookmarks