accounts receivable spreadsheet
 

i am managing accounts receivable for 2 offices. i have combined 2 files
into one file with 2 worksheets. i need to have the totals from one sheet
auto update to the master sheet whenever i receive payments and make changes.
i cannot figure out how to do this. thank you.

accounts receivable spreadsheet
 

Hi,
I assume you have a column called payment where you enter the information,
and is in sheet2, in sheet1 you have the summary with the payment column as
well and there you need to enter the formula

=sheet2!D2

where D2 is the payment column where you enter it

"Lisamary30" wrote:

i am managing accounts receivable for 2 offices. i have combined 2 files
into one file with 2 worksheets. i need to have the totals from one sheet
auto update to the master sheet whenever i receive payments and make changes.
i cannot figure out how to do this. thank you.