Can we have a look at the two files please?

"Robert Sadler" wrote:


I intern with the Salvation Army and am looking to update some of their
workbooks.

The story:
We have clients that pay so much for program fees. When they fall
behind their name goes onto a worksheet called Fees.xls

We also have a worksheet that shows all who are currently living at the
shelter called Recap.xls

Each night Recap.xls is updated with new clients.

Both worksheets are set-up the same, A1 on Fees.xls contains the same
info as Recap.xls. The only difference is some names are red on
Fees.xls where they are not highlighted on Recap.xls

The big question!
Recap.xls is updated by our shelter staff each night where Fees.xls are
updated (Turning some names red) twice monthly by our admin staff. Our
admin staff is always asking us to keep the names current on Fees.xls.
We have such turnover being a homeless shelter it would take twice the
time each night to update them both.
Can I just "Link" the info from A1 on Recap.xls to A1 on Fees.xls and
have Fees.xls update automatically when it is opened?

Thanks so much for your help!
God bless,
Robert


--
Robert Sadler
------------------------------------------------------------------------
Robert Sadler's Profile: http://www.excelforum.com/member.php...o&userid=18238
View this thread: http://www.excelforum.com/showthread...hreadid=509205