Macros to copy datas from different excel document to one worksheet

[u767]

I am trying to copy datas from different excel document and paste it to fist sheet of a new document.

I managed with a macro but unfortunately i am getting few problems in that. Pasted below the macro which i am using

Please Login or Register  to view this content.

When i execute this macro the output is like the first column get copied from the first document and first two lines copies from second document and first 4 lines get copies from the third document.

I have pasted a sample data.

Help me out with this.

[arlu1201]

Updated code -

Please Login or Register  to view this content.

[u767]

When i executed you updated macro i am getting a error stating

Runtime error 1004 Application defined error or object defined error.

When i debug the error it points out ".Range("A2:U" & Range("A" & Rows.Count).End(x1Up).Row).Copy _
Master.Worksheets(1).Range("A" & Rows.Count).End(x1Up).Offset(1, 0)" this line

[arlu1201]

You dont even have that code line in your above code.

Try the code i posted in post 2 and let me know if you get any errors.

[u767]

I copied you whole macros and pasted it. after which i got this error

Please Login or Register  to view this content.

[arlu1201]

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[u767]

Thanks!!!

I have pasted your updated macro but when i execute it nothing happened.


Attached the document after running the macros and the sample records.

[u767]

arul help me!!!!!

[arlu1201]

Updated code -

Please Login or Register  to view this content.

[u767]

Thanks its working now

[arlu1201]

Am glad its solved.