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

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?

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

Are the worksheets in the same workbook or separate workbooks?

"Bdubs" wrote:

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?