Copying values of named ranges

Dear Mark

Thank you for your response.

We are not concerned about the visual aspects.

I have a workbook containing say 50 named items:

Cost_1
Cost_2
etc.

and these names are hooked up to a complicated economic model.

Separately I send another workbook to each country in Europe for them to populate the fields with the same names:

Cost_1
Cost_2 etc

I have been entering the cost data for each country by hand and often errors are made so I thought it would be easier if VB code could ask the name of the "source" workbook, then check to see which names match on each sheet and replace the "target" name with the value from the source name.

Can you tell me how to send you a file confidentially as I cannot post this on the public domain.

Thanks

Grahame