accounts receivable spreadsheet

  • Thread starter Thread starter Lisamary30
  • Start date Start date
L

Lisamary30

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.
 
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
 
Back
Top