Named Cell Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a range of cells (A1:B5) in worksheet #2 is given a name, and a cell A1
in worksheet #1 equals cell A3 in worksheet #2, does that mean that the
single cell in worksheet #1 is automatically linked (or tied to) the named
range in worksheet #2?
 
Not automatically no, the name is just a 'handle' to the rage that it refers
to.
 
I guess that depends on why you want it automatically linked, and what
exactly you understand by this. If you mean that A3 updates dependent on
something happening in that range, that is easily achievable with worksheet
event code.
 
Yes, that's what I mean. How would I do this? And is the reverse also
possible (single cell within named range in 2nd sheet equals single cell in
1st sheet)?
 
Need more info confused.

What changes in the named range will generate what change in A3? What is the
name?
 
I have a rather large table that lists different categories and many tasks
for each category. I then named a separate sheet for each category and listed
the tasks. Each of the tasks are separated out into individual tables that
list the steps to perform each task. In order to save typing time (and to
make sure the tasks read the exact same way), I set the table headings to
equal the corresponding tasks on the original table. I've also named each
table in the attempt to "group" the cells together. If I have to move one of
the tasks around on the sheet #1, I want the steps to stay with the task on
the subsequent sheets (if it's possible, I would also like for the tasks on
the subsequent sheets to stay in the same order as the tasks on the first
sheet). Hopefully, I'm explaining this clearly enough. I'm not even sure if
this can be done, but if it can, it will be well worth it. Can you help?
 
Back
Top