Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2007

Tip: Looking for answers? Try searching our database.

first tab to other tabs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mo - 29 Mar 2007 21:46 GMT
Help Pls.
i want to enter data in the first tab, without retyping them in individual
tabs have the automatic sepeared in other tabs.
exp.
column
a             b          c                   a        b            c        
     a        b            c
global  300 pcs  10 boxes      global  300 pcs  10 boxes      island  400
pcs  20 boxes
island   400 pcs  20 boxes     global  200 pcs    5 boxes      island  300
pcs  10 boxes
island   300 pcs  10 boxes
global   200 pcs    5 boxes

all vendors                                             global              
             island

Thank You
Anne Troy - 29 Mar 2007 22:10 GMT
Duplicating data like this doesn't work well in Excel. You'll be better off
just using the Subtotals and Autofilter features.
http://www.officearticles.com/excel/getting_subtotals_in_microsoft_excel.htm
http://www.officearticles.com/excel/using_autofilter_in_microsoft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
> Help Pls.
> i want to enter data in the first tab, without retyping them in individual
[quoted text clipped - 14 lines]
>
> Thank You
Gary''s Student - 31 Mar 2007 12:28 GMT
You can set up links in the other tabs that reference the data in your first
tab.
Signature

Gary''s Student - gsnu200713


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.