Relative References to other sheets

S

stevevalwa

I have two sheets, lets call them SH1 & SH2. In SH2 I have a reference to a
cell in SH1 and lets say it is SH1!G4 ... Now I decide to sort the data in
SH1 and the data that was in SH1!G4 is now in SH1!G10, but my reference in
SH2 returns the data that is in SH1!G4 and not SH1!G10 as I would expect.
This behaviour is as if I am using absolute references when I am intending to
use relative references.. How do I fix this??
 
B

Bernard Liengme

Excel does not change the reference to cells on the same sheet when sorting
occurs.Maybe you need to use VLOOKUP
happy new year
 

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

Move to next line 1
How to disable a subrouting temporary from an other sub? 4
Run and edit a Macro 1
Help Please 7
Ignore case of text in code 4
drag formula down making chgs on the way (Q2) 5
Little problem with this code... 11
How can I use a loop here? 0

Top