Named Cell Ranges

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?
 
B

Bob Phillips

Not automatically no, the name is just a 'handle' to the rage that it refers
to.
 
B

Bob Phillips

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.
 
G

Guest

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)?
 
B

Bob Phillips

Need more info confused.

What changes in the named range will generate what change in A3? What is the
name?
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Let's try this again.... 5
How to sum more then 31 worksheets cell 4
Excel VBA 1
using named ranges in calculations 2
Linking named ranges 2
How to take text from other cells to create a reference to a name 3
Blank Cell Reference, without if statement 4

Top