Hi All,
I have 2 excel workbook's moc.xls & product.xls.

In moc.xls I have Baking_powder, Coffee, Cold_Beverages, Cooking_prds as
diffrent sheets and in each sheet I have the columns as follows....

A B C
Fiscal year/period Products Total
MOC 11 2008 CSD
MT
NONCSD

MOC 12 2008 CSD
MT
NONCSD

MOC 01 2009 CSD
MT
NONCSD

MOC 02 2009 CSD
MT
NONCSD
and so on........

In product.xls I have the data as follows.....

A B C D E F

Products Fiscal year/period MOC 11 2008 MOC 12 2008 MOC 01 2009 MOC 02 2009
Baking_powder CSD 872.1430000 634.2780000 - -
MT 634.2780000 450.5190000 - 441.0790000
NON-CSD 27,257.6850000 - - 29,874.8730000
Coffee MT 57,291.6380000 50,218.9150000 44,918.4620000 54,963.0090000
NON-CSD 200,429.8260000 25,509.5120000 -18,464.5840000 36,327.2910000
Cold_Beverages CSD 39,845.2710000 19,276.5840000 9,733.2720000 9,404.9280000
MT 28,048.5780000 12,190.9350000 5,329.5180000 6,241.5160000
NON-CSD 13,864.3480000 49,923.3500000 95,780.9700000 90,578.8540000
Cooking_prds MT 6,543.5950000 5,685.3880000 5,674.5460000 6,023.5630000
NON-CSD 12,740.3760000 332.5570000 327.8850000 1,962.6270000

as follows.... my query is I want a macro to copy the data from product.xls
to moc.xls in column C, such a way that if Baking_powder sheet is activated I
want CSD,

MT & NONCSD of respective column to be coppied in moc.xls eg: if I select
Baking_powder sheet I want the Baking_powder CSD of that fiscal year/period
to be

coppied in moc.xls of fiscal yerar/period column.

Out put should look as follows:-
Baking_powder sheet activated
Fiscal year/period Products Total
MOC 11 2008 CSD 872.1430000
MT 634.2780000
NONCSD 27,257.6850000

MOC 12 2008 CSD 634.2780000
MT 450.5190000
NONCSD -

MOC 01 2009 CSD -
MT -
NONCSD -

MOC 02 2009 CSD -
MT 441.0790000
NONCSD 29,874.8730000

like wise I want in all the sheets for Coffee, Cold_Beverages & Cooking_prds.

TIA