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:
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: