first tab to other tabs

[Guest]

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]

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
****************************

 

[Guest]

You can set up links in the other tabs that reference the data in your first
tab.