$$Excel-Macros$$ Need a macro to open & copy data from a given path

Hello Experts, I need a macro to open a particular folder from excel and should copy the file name & sheet name & A1 value from each sheet. PFA Thanks Kartik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi

RE: $$Excel-Macros$$ Need a macro to open & copy data from a given path

PFA, first select paths. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kartik Dale Sent: Tuesday, December 17, 2013 1:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a macro to open & copy data from a given path Hello Exp