Range Names That Move With Cell Data

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

Shane Devenshire

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
 
D

DemiUrgoss

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

Cell data entering slow! 0
Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Pasting a cell into bookmarked table from excel vba 1
Place picture in Excel cell 0
Need Help with a VBA subroutine 0
A find formul looking at two named ranges for two strings 8
range definition by cells numbers 3

Top