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