Hello...I have a bit of a problem. I need to combine 2 different rows from 2 different sheets without the information switching everytime a sheet is re listed.
Ex.
Sheet 1:
A B C D E
1 Name Due Date Amount Due Paid Owes
2 John Jan 15 $50 $45 $5
3 Mike Jan 13 $60 $59 $1
sheet 2:
A B C D E
1 Name Due Date Amount Due Paid Owes
2 John Jan 15 $50 $45 $5 <---Problem
3Mike Jan 13 $60 $59 $1 <---Problem
I want to add the previous money owed, I was able to add a formula wich will automatically calculate Past Credit by entering: =(Sheet1!E2+Sheet2!(D2-C2))...but if I were to be looking on sheet 1 and wanted to sort by name, due date, amount due, paid, or owes...my info on sheet 2 will change as well, making the info incorrect...How can I combin the 2 rows and lock the information? When the I sort, everyones information gets mixed.
[/u]
Ex.
Sheet 1:
A B C D E
1 Name Due Date Amount Due Paid Owes
2 John Jan 15 $50 $45 $5
3 Mike Jan 13 $60 $59 $1
sheet 2:
A B C D E
1 Name Due Date Amount Due Paid Owes
2 John Jan 15 $50 $45 $5 <---Problem
3Mike Jan 13 $60 $59 $1 <---Problem
I want to add the previous money owed, I was able to add a formula wich will automatically calculate Past Credit by entering: =(Sheet1!E2+Sheet2!(D2-C2))...but if I were to be looking on sheet 1 and wanted to sort by name, due date, amount due, paid, or owes...my info on sheet 2 will change as well, making the info incorrect...How can I combin the 2 rows and lock the information? When the I sort, everyones information gets mixed.
[/u]