Grahame has attended:
Excel VBA Intro Intermediate course
Copying values of named ranges
How can I capture the value of a named range in one spreadsheet, check to see if that same name exists in another spreadsheet and copy the value if it does and produce a list of the names where they are not transferred across
RE: Copying values of named ranges
Hello Grahame,
What you are asking is possible, but will take some thought to its approach and coding. It may help if you can send over a sample book so we can view what you are wanting to achieve visually.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
RE: 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
RE: Copying values of named ranges
Hello Graham,
you can send the file directly to me at mm@stl-training.co.uk
I will pass the details to a colleague who can assist as I'm away for a while.
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
