My first time here - Hi Everyone - hoping someone can help solve my EXCEL problem.
Firstly, I don't have a great deal of experience with Excel, and I'm currently using MS Excel 2007.
I have in the region of 200 .xls files in a network folder, all with the same format, which contain corporate details of a number of previous clients. What I would like to do is extract the email address for each client (always in cell B13) and import all email addresses into a single file (could be another .xls file or maybe some other file type).
Is there an "easy" way to do this? All constructive suggestions welcome.
Thanks in advance.
Bookmarks