Help with naming

M

Mike Busch

I have different areas on the spreadsheet with naming definitions, and I use
the dropdown menu to select them. Is there any way to set up cells to go to
those named areas? Thank you in advance.
 
G

Gord Dibben

Mike

What do you mean by "cells to go to those named ranges"?

Cell contents, I presume.

You can use formulas to "pull" contents from other cells but formulas cannot
"send" contents to other cells.

Only by VBA code can you send contents.

Give us an idea and small example of what you what done.


Gord Dibben MS Excel MVP
 
Top