Copy data from multiple files in a single master file

[vaibhav tandon]

Check this...

Hi Deepak,

Thanks for this, but its getting error at the line
Set copy_rng = .Offset(1, 2).Resize(WorksheetFunction.CountA(.Columns(c)) - 1, .Columns.Count - 2).

 

[Deepak]

But i didn't..

 

[vaibhav tandon]

But i didn't..

Thanks Deepak! Yes indeed its working in this but I had some data uploaded in my local sheet which is now different from the sample files uploaded. The format, columns everything is same but it loaded with data which I wont be able to share. I think that is causing some problem. If you could help me understand what the following code line is doing then I might understand the problem -"Set copy_rng = .Offset(1, 2).Resize(WorksheetFunction.CountA(.Columns(c)) - 1, .Columns.Count - 2)." It stops with - "run time error 1004 . application defined or object error. It successfully copies and pastes 7 files out of 9 which I currently have.