I'm a complete newbie when it comes to coding in Excel, so I'm not
even sure I can articulate what I want, but I'll try.
I want to be able to read data from a file without having it
physically open in front of me. Example: I want an automatic macro in
spreadsheet I to read through successive rows of Column A of
Spreadsheet II to see if the value equals Z, then pull data from the
same row, but column B and store it into a certain cell in Spreadsheet
I. I hope that explained it well enough. Also, before this macro
gets ran, I want the user to be able to specify Spreadsheet II's file.
I'm pretty sure I can do what I want if Spreadsheet II is open, but I
wanted to avoid that so if anybody could explain to me how to do it,
I'd appreciate it.