C
Confused
I was asked for more information originally....so here it is:
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?
:
Need more info confused.
What changes in the named range will generate what change in A3? What is the
name?
-- HTH RP
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)?
:
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.
-- HTH RP
Would there be way to do this?
:
Not automatically no, the name is just a 'handle' to the rage that
it refers to.
--
HTH
RP
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?
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?
:
Need more info confused.
What changes in the named range will generate what change in A3? What is the
name?
-- HTH RP
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)?
:
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.
-- HTH RP
Would there be way to do this?
:
Not automatically no, the name is just a 'handle' to the rage that
it refers to.
--
HTH
RP
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?
