HI,all ,
I am using following macro for extracting the data from sub folders my macro is working fine.
just need a help if macro can update the reference of folder in column "Z" from where the data is copied.
Ex : if data is copied from Folder no - 1 then my reference should be - 1 in column...