Quote Originally Posted by WinteE
Hi,

See the attached file. It will pick up all data in cell B2 of every file in the same workbook as the active workbook is in.

Let me know if you have any questions about this.

Succes,
Erik
Hi Erik
Thanks for your efforts but I cant seem to get it to work? You also say it will pick up cell b2 of every file in the same work book but I need to extract cells from a given same worksheet in multiple workbooks which are all stored in the same folder. I cant seem to view the code for this macro either when I hit alt+f11?
Thanks
Khuram