Help in combining multiple spreadsheets

[cux]

Please help me in combining 3 spreadsheets into 1.
example I have a header: ID package service username password
each username and password is in the separate spreadsheet with the ID.
example spreadsheet:

ID_______package_____service_____ username_____ password
Z1234_________A________service1
_______________________service2
_______________________service3
Z1357_________B________service1
_______________________service2
_______________________service3

spreadsheet 1(service1):
ID______username____password
Z1234______abc___________123
Z1357______def___________456

spreadsheet 2(service2):
ID______username____password
Z1234______ruy___________909
Z1357______moy___________789


spreadsheet 3(service3):
ID______username____password
Z1234______pop___________254
Z1357______tin____________036


so i need to combine all services username and password in the spreadsheet. I have thousands of rows. I am newbie here in the forum. It takes a lot of time to copy and paste all of these things. So I wonder if someone is interested to help me or any suggestions? care to help, I would really appreciate it a lot..

[JKwan]

I believe this is what you need.
Alt F11 to bring up your VBA screen then run Consolidate.

[GTO]

Hi there,

Welcome to vbaexpress! I am sure that you will be glad you joined, as there are great folks here :-)

Reference your question, could you attach a small example wb, with everything listed as the real one has it? I think this would make it much easier to see what you want and help you explain what the "after" should look like.

Thank you,

Mark

[halimi1306]

hi pal,

U might refer to this thread:
http://www.vbaexpress.com/forum/show...light=collates

JKwan code works very well

[cux]

wow! I just checked this forum. I thought no one replied since I'm not getting any email notifications. Thank God I checked this. Anyway, I'll check that out. Thanks a lot