From one folder All Excel files Data copy paste

[Abhijeet]

Hi
From one folder All excel files data copy paste in one excel sheet update file name & sheet name in that excel sheet.If any file not copy & paste data then update that file name in Error log sheet.Please give me macro for this problem

 

[SirJB7]

@SirJB7
Hi, myself!
So long...
If started on Sep 7th 2013 (A1), till today Feb 28th 2014 (A2) there are 174 days (B2), with 182 posts (c2)... so if I type in A3:
=A1+1000/C2*B2
I get Apr 20th 2016. The day he'll reach 1000 posts... A new Ninja? @r1c1!!!!!!
Regards!
PS: Note to self: remember your Easter holidays from Apr 19th 2016 to... to...
PS 2: Just hope that I won't find an Easter egg with this note inside: Give me macro.

 

[Abhijeet]

Hi any other person can help for this problem

 

[Lymm]

Abhijeet, I think maybe you need to supply some sample files and and specific questions about any problems you are having trying to do this. Your post above does not explain what problems you are having.