donyc1
03-23-2011, 10:41 AM
Hi everyone.. I have been trying to finish a project and been stuck on below part for some time.. I am looking for some help/advice.. Would be very much appreciated..
I have 2 tabs in a spreadsheet:
1) profits1 (has 3 columns(A, B, C) : account, id, profits) - contains 50 rows
2) profits2 (has 3 columns(A, B, C): account, id, profits) - contains 400 rows (50 rows contain profits already on data1.)
My profits are identified by 2 identifiers "account" and "id" ("id" is unique but it I have 5 static accounts so i can have a case of 5 same ids across 5 different accounts)
the problem where I am stuck:
I need to look remaining profits that are NOT on profits tab based per account/id and transfer them in the profit column(cell C3) on row 51 which then needs to be populated all the way down on data1.xls
Any help/advice would be greatly appreciated!
thanks so much
I have 2 tabs in a spreadsheet:
1) profits1 (has 3 columns(A, B, C) : account, id, profits) - contains 50 rows
2) profits2 (has 3 columns(A, B, C): account, id, profits) - contains 400 rows (50 rows contain profits already on data1.)
My profits are identified by 2 identifiers "account" and "id" ("id" is unique but it I have 5 static accounts so i can have a case of 5 same ids across 5 different accounts)
the problem where I am stuck:
I need to look remaining profits that are NOT on profits tab based per account/id and transfer them in the profit column(cell C3) on row 51 which then needs to be populated all the way down on data1.xls
Any help/advice would be greatly appreciated!
thanks so much