Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bdubs
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet change with pivot table Richard Excel Discussion (Misc queries) 3 February 20th 06 10:20 PM
Change Source / Update Now buttons not available stickboy Links and Linking in Excel 0 February 16th 06 10:33 PM
Worksheet Change event DoctorG Excel Discussion (Misc queries) 4 February 15th 06 12:53 PM
Worksheet Revision Date only once that day mikeburg Excel Discussion (Misc queries) 0 August 16th 05 12:39 AM
Update second worksheet with changes in original worksheet ZB Excel Worksheet Functions 0 January 26th 05 06:11 PM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"