Linking values within an Excel workbook
 

I have a master list of items that changes often i.e. I add or delete lines
and records frequently. My problem: How do I permanently link to a particular
value in a cell even after the file has been resized or resorted and that
cell now appears at coordinates different from where I first referenced it?

Very confusing!

Thanks for any assistance

Jerry M.

Linking values within an Excel workbook
 

In the Excel help menu, look at Offset or Indirect.


Regards,
Ryan---

--
RyGuy


"Jerry M." wrote:

I have a master list of items that changes often i.e. I add or delete lines
and records frequently. My problem: How do I permanently link to a particular
value in a cell even after the file has been resized or resorted and that
cell now appears at coordinates different from where I first referenced it?

Very confusing!

Thanks for any assistance

Jerry M.