Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copying values of named ranges

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Copying values of named ranges

Resolved · High Priority · Version 2007

Reply Tue 20 Sep 2011, 16:40Delegate Grahame said...

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

For upcoming training course dates see: Pricing & availability

Reply Mon 26 Sep 2011, 12:02Trainer Mark said...

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

Reply Mon 26 Sep 2011, 12:36Delegate Grahame said...

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

Reply Thu 6 Oct 2011, 10:39Trainer Mark said...

RE: Copying values of named ranges

Hello Graham,

you can send the file directly to me at mm
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

Wed 12 Oct 2011: Automatically marked as resolved.

Excel articles

· Using Excel For Simple Home Accounting And Budgets
· Some Examples Of Excel Text Formulas
· Do You Need To Run Excel 2007 In Compatibility Mode?
· Interesting Things About Charts In Excel 2003
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series

Please browse our web site to find out more about
excel+and+powerpoint+courses+uk and other Microsoft training courses.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips