Range Names That Move With Cell Data

  • Thread starter Thread starter DemiUrgoss
  • Start date Start date
D

DemiUrgoss

Is there a way to assign a range name to a cell, and then have it move with
that cell data if you sort the page?
 
Hi,

If you data is not going to be chaning you can assign a name that will move
with the unchanging name, in some situations.

For example, suppose your range is E1:E10 with the word Apr within the
range, then create a name Apr which is defined as:

=INDEX(Sheet2!$E$1:$E$10,MATCH("apr",Sheet2!$E$1:$E$10,0),0)

However, this has very limited utility.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Thank you for taking the time to respond to my query.

Unfortunately your answer did not help, but it did give me an idea on how I
can adjust my spreadsheet to do what I need.

have a great holiday season!
 

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 VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Set non-continuous PrintArea via Function / Name 0
a data validation list that contains a list of named ranges - not alist from a named range 1
range definition by cells numbers 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Msgbox runing beyond posted cell range. 1

Back
Top