Hello Mr. Excel gurus!
I've searched for hours for a solution with no luck. Sometimes I can cobble a macro together but this is out of my league.
I have a file with a value in cell A4 that I need to lookup on tab "Sch H" in a closed file (X:\Folder\file.xlsx) and return the values in that row for columns CO, DQ, DR, EB, EH, EV, and FC. The closed file has some circular references (not my doing), is around 30 megs, and has probably fifty tabs. So it would be best to not have to open the file if possible.
Can one of you VBA masters please help me with a macro or point me in a direction where I could modify an existing one? Like I said, I have searched but couldn't find anything like what I am looking to do.
Thank you for your assistance.
I've searched for hours for a solution with no luck. Sometimes I can cobble a macro together but this is out of my league.
I have a file with a value in cell A4 that I need to lookup on tab "Sch H" in a closed file (X:\Folder\file.xlsx) and return the values in that row for columns CO, DQ, DR, EB, EH, EV, and FC. The closed file has some circular references (not my doing), is around 30 megs, and has probably fifty tabs. So it would be best to not have to open the file if possible.
Can one of you VBA masters please help me with a macro or point me in a direction where I could modify an existing one? Like I said, I have searched but couldn't find anything like what I am looking to do.
Thank you for your assistance.
