first tab to other tabs
 

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

first tab to other tabs
 

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/...soft_excel.htm
http://www.officearticles.com/excel/...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Mo" wrote in message
...
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

first tab to other tabs
 

You can set up links in the other tabs that reference the data in your first
tab.
--
Gary''s Student - gsnu200713