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