G
Guest
I wrote a previous message, but I didn't know if it was clear. I am trying
to take data from the months of March and April and merge them together to
get one complete spreadsheet of each person's account for each month. Is
there a way to do this? I have been sorting by ID# and doing the rest
manually.
A B C D
1 ACCT BAL
2 NAME ID # MARCH
3 ASHLEY 111-11-1111 88
4 BRIAN 222-22-2222 32
5 CARL 333-33-3333 48
6 DAVID 444-44-4444 92
7 EVAN 555-55-5555 25
8 FRANK 666-66-6666 108
9
11 ACCT BAL
12 NAME ID # APRIL
ASHLEY 111-11-1111 100
BRAD 888-88-8888 28
CARL 333-33-3333 52
DAVID 444-44-4444 105
DERRICK 999-99-9999 74
EVAN 555-55-5555 35
PAUL 454-44-4545 86
COMPLETE END RESULT
ACCT BAL ACCT BAL
NAME ID # MARCH APRIL
ASHLEY 111-11-1111 88 100
BRAD 888-88-8888 0 28
BRIAN 222-22-2222 32 0
CARL 333-33-3333 48 52
DAVID 444-44-4444 92 105
DERRICK 999-99-9999 0 74
EVAN 555-55-5555 25 35
FRANK 666-66-6666 108 0
PAUL 454-44-4545 0 86
to take data from the months of March and April and merge them together to
get one complete spreadsheet of each person's account for each month. Is
there a way to do this? I have been sorting by ID# and doing the rest
manually.
A B C D
1 ACCT BAL
2 NAME ID # MARCH
3 ASHLEY 111-11-1111 88
4 BRIAN 222-22-2222 32
5 CARL 333-33-3333 48
6 DAVID 444-44-4444 92
7 EVAN 555-55-5555 25
8 FRANK 666-66-6666 108
9
11 ACCT BAL
12 NAME ID # APRIL
ASHLEY 111-11-1111 100
BRAD 888-88-8888 28
CARL 333-33-3333 52
DAVID 444-44-4444 105
DERRICK 999-99-9999 74
EVAN 555-55-5555 35
PAUL 454-44-4545 86
COMPLETE END RESULT
ACCT BAL ACCT BAL
NAME ID # MARCH APRIL
ASHLEY 111-11-1111 88 100
BRAD 888-88-8888 0 28
BRIAN 222-22-2222 32 0
CARL 333-33-3333 48 52
DAVID 444-44-4444 92 105
DERRICK 999-99-9999 0 74
EVAN 555-55-5555 25 35
FRANK 666-66-6666 108 0
PAUL 454-44-4545 0 86