PDA

View Full Version : Help in combining multiple spreadsheets



cux
04-20-2011, 06:09 AM
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.. : pray2:

JKwan
04-20-2011, 07:13 AM
I believe this is what you need.
Alt F11 to bring up your VBA screen then run Consolidate.

GTO
04-20-2011, 07:17 AM
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
04-20-2011, 08:03 AM
hi pal,

U might refer to this thread:
http://www.vbaexpress.com/forum/showthread.php?t=36972&highlight=collates

JKwan code works very well

cux
04-22-2011, 03:50 AM
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 :jsmile: