formula for updating 1 spreadhseet from another

[Guest]

I have two spreadsheets one for "current accounts" and one for "past due accounts". The "current" spreadsheet list all our receivables from this year even if they are still outstanding, the "past due" spreadsheet list only those that are 30 days or more past due. What I currently have to do is if a vendor pays an invoice update the "current" spreadsheet and then if its a past due go an update the "past due spreadhseet". My question: Is there away to automaticly have the "past due" spreadhseet update itself if I enter a payment on the "current" spreadsheet?

Ex layout of current spreadsheet

invoice number invoice date amount billed amount paid date paid
250.1111 1/1/03 5.00 5.00 7/1/03

layout for "past due" is the same but with the 'amount paid" and "date paid" empty until i manually update

one final thing since i work for a BK law firm I may bill a client 5 times over the course of a few months using the same invoice number so if there is a way to automate this it seems like it would need validation against the invoice number, date, and amount

thanks guys for your help, feel free to email with any suggestions or questions

 

[RagDyer]

First of all, how do you create the "Past Due" sheet ?
Due you retype the data or do you copy and paste ?

You could kill 2 birds with one stone if you populated the Past Due sheet by
simply copying the entire data row of the Current sheet, navigate to the row
of the Past Due sheet and then:
Right click and choose "PasteSpecial",
Then just click on the "PasteLink" button.

Then, when you eventually receive payment and enter the date and amount on
the Current sheet, it will automatically display in the Past Due sheet.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have two spreadsheets one for "current accounts" and one for "past due
accounts". The "current" spreadsheet list all our receivables from this year
even if they are still outstanding, the "past due" spreadsheet list only
those that are 30 days or more past due. What I currently have to do is if a
vendor pays an invoice update the "current" spreadsheet and then if its a
past due go an update the "past due spreadhseet". My question: Is there away
to automaticly have the "past due" spreadhseet update itself if I enter a
payment on the "current" spreadsheet?

Ex layout of current spreadsheet

invoice number invoice date amount billed amount paid date
paid
250.1111 1/1/03 5.00 5.00
7/1/03

layout for "past due" is the same but with the 'amount paid" and "date paid"
empty until i manually update

one final thing since i work for a BK law firm I may bill a client 5 times
over the course of a few months using the same invoice number so if there is
a way to automate this it seems like it would need validation against the
invoice number, date, and amount

thanks guys for your help, feel free to email with any suggestions or
questions