How Do I ......?

[barrowhill]

I wish to link a cell in one worksheet (A) to pick up the contents of another
cell in a different worksheet (B). This needs to be a fixed link in that
wherever the cell "appears" in worksheet B (worksheet B gets sorted). the
link is always pointing to it.

I hope this is understandable ???

Thanks in anticipation

Tom

 

[Dave R.]

You can use
=SheetB!$A$1

If rows/columns are inserted or deleted on sheet B (or if cells are moved),
that formula will change accordingly. If you don't want it to ever change,
try
=INDIRECT("SheetB!A1")

Sorting shouldn't change the cell at which the link is pointing with either
of these.

 

[Bob Phillips]

='Sheet B'!A1

will pick up cell A1, and will change as Sheet B is sorted.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

hi,
here is one i use
=('S:\PUBLIC\Ae-pc\FY05\[WorkOrderJan.xls]MPX'!$A$4)

 

[barrowhill]

All,

Thanks for your prompt replies. I'm (already) using your suggestions and
it is working. It's what I want it (the spreadsheet) to do that I'm
confusing myself on !!! Perhaps I'm looking for the complicated solution
rather than the easy one. I need to rethink. If still not doing what I
would like then I'll be back for help.

Many thanks to you all

Tom

hi,
here is one i use
=('S:\PUBLIC\Ae-pc\FY05\[WorkOrderJan.xls]MPX'!$A$4)

-----Original Message-----
I wish to link a cell in one worksheet (A) to pick up the contents of another
cell in a different worksheet (B). This needs to be a fixed link in that
wherever the cell "appears" in worksheet B (worksheet B gets sorted). the
link is always pointing to it.

I hope this is understandable ???

Thanks in anticipation

Tom

.