Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default Auto update 'summary tab' with 'detailed tab'

E.g.: Summary tab is showing:

Customers No Customer Name:
AA1111 ABC
BB2222 DEF
CC3333 GHI

And then few new customers are added on the system which I can export to a
separate tab (Detailed tab). Now I want the above summary tab to pick any new
items been included in my revised/updated detailed tab. If there are no new
customer, the summary tab should remain unchanged and add if there are any
new customers, as soon as I update the detailed tab - the summary tab should
automatically be updated with any new customers (but should not delete any
old customer which are in my summary tab and not included in detailed tab
anymore).
E.g.: The revised detailed tab:

Customers No Customer Name:
BB2222 DEF
CC3333 GHI
DD4444 JKL

ie AA1111 has been disappeared in my detailed tab (which I still want to
appear on my summary tab). DD4444 has been added as new customer (which I
also want to include in my summary tab).
Ie: My summary tab should look like:

Customers No Customer Name:
AA1111 ABC
BB2222 DEF
CC3333 GHI
DD4444 JKL

Thanks
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
Summary sheet auto update SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS Excel Worksheet Functions 0 May 28th 09 01:49 PM
Detailed worksheet value entered automatically in Summary workshee Victoria Excel Discussion (Misc queries) 2 September 26th 07 06:36 PM
Can you tell me how to restore the 'template tab' I deleted? Mary Excel Discussion (Misc queries) 2 October 7th 05 12:27 AM
Excel Worksheets - search for 'tab' Allan Excel Discussion (Misc queries) 4 September 29th 05 01:15 AM
How can I stop my 'tab' key from jumping multiple columns in Exce. Jesse Excel Discussion (Misc queries) 2 April 12th 05 10:16 PM


All times are GMT +1. The time now is 12:53 PM.

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

About Us

"It's about Microsoft Excel"