How do I get one worksheet to update when others change?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bdubs - 21 Mar 2006 19:38 GMT

I work at a bank and am responsible for updating possible loans. Each
officer enters his/her personal loan info into a seperate WS, the totals of
each officer are then rolled into a summary WS. Is there a way so that the
summary WS updates as the individual officers change their individual
worksheets?

Reply to this Message

Barb Reinhardt - 21 Mar 2006 19:40 GMT

Are the worksheets in the same workbook or separate workbooks?

> I work at a bank and am responsible for updating possible loans. Each
> officer enters his/her personal loan info into a seperate WS, the totals of
> each officer are then rolled into a summary WS. Is there a way so that the
> summary WS updates as the individual officers change their individual
> worksheets?

Reply to this Message