A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Getting links to follow inserted rows



 
 
Thread Tools Display Modes
  #1  
Old July 14th, 2009, 09:51 PM posted to microsoft.public.excel.links
[email protected]
external usenet poster
 
Posts: 2
Default Getting links to follow inserted rows

Hello-
I have a slightly complicated problem, so I'll try to make it as
simple as possible for anyone who wants to help (which I would greatly
appreciate).

I have a large range of data that needs to be entered into a worksheet
and then reordered in a second worksheet. The second worksheet is
nothing but links that put the data from the first worksheet into the
correct order.

My problem is this: whenever I insert a row into the first worksheet,
the numbers from the second worksheet don't change. I would like to
have a permanent link, for example, to cell A1 in Sheet 1, but when I
move that cell to D12, the link in Sheet 2 suddenly refers to D12.

Can the links be made to refer to a location, rather than a datum?
Thanks!
  #2  
Old July 14th, 2009, 10:12 PM posted to microsoft.public.excel.links
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Getting links to follow inserted rows

These worksheets are in different workbooks, right?

If both workbooks are open when you make the change, then excel will adjust
those links. Remember to save both files when you're done!

If you don't want to open the "sending" workbook, you can name each cell that
gets retrieved. When you insert/delete a row/column, then that named range will
move with the cell. And the formulas that refer to that named range will still
point to that named range.

========
But this kind of stuff scares me.

If possible, I would have a unique key (in column A???) so that I could use
=vlookup() to retrieve values when the key matched.

" wrote:

Hello-
I have a slightly complicated problem, so I'll try to make it as
simple as possible for anyone who wants to help (which I would greatly
appreciate).

I have a large range of data that needs to be entered into a worksheet
and then reordered in a second worksheet. The second worksheet is
nothing but links that put the data from the first worksheet into the
correct order.

My problem is this: whenever I insert a row into the first worksheet,
the numbers from the second worksheet don't change. I would like to
have a permanent link, for example, to cell A1 in Sheet 1, but when I
move that cell to D12, the link in Sheet 2 suddenly refers to D12.

Can the links be made to refer to a location, rather than a datum?
Thanks!


--

Dave Peterson
  #3  
Old July 16th, 2009, 12:12 AM posted to microsoft.public.excel.links
Sam Thielman
external usenet poster
 
Posts: 1
Default Getting links to follow inserted rows

Actually, they're not in different workbooks - I'm just linking from,
for brevity's sake, sheet1 to sheet2.

On Jul 14, 5:12*pm, Dave Peterson wrote:
These worksheets are in different workbooks, right?

If both workbooks are open when you make the change, then excel will adjust
those links. *Remember to save both files when you're done!

If you don't want to open the "sending" workbook, you can name each cell that
gets retrieved. *When you insert/delete a row/column, then that named range will
move with the cell. *And the formulas that refer to that named range will still
point to that named range.

========
But this kind of stuff scares me.

If possible, I would have a unique key (in column A???) so that I could use
=vlookup() to retrieve values when the key matched.



" wrote:

Hello-
I have a slightly complicated problem, so I'll try to make it as
simple as possible for anyone who wants to help (which I would greatly
appreciate).


I have a large range of data that needs to be entered into a worksheet
and then reordered in a second worksheet. The second worksheet is
nothing but links that put the data from the first worksheet into the
correct order.


My problem is this: whenever I insert a row into the first worksheet,
the numbers from the second worksheet don't change. I would like to
have a permanent link, for example, to cell A1 in Sheet 1, but when I
move that cell to D12, the link in Sheet 2 suddenly refers to D12.


Can the links be made to refer to a location, rather than a datum?
Thanks!


--

Dave Peterson


  #4  
Old July 16th, 2009, 12:51 AM posted to microsoft.public.excel.links
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Getting links to follow inserted rows

Are these links formulas like:
=sheet1!a1
or are they hyperlinks (via insert|Hyperlinks)

Sam Thielman wrote:

Actually, they're not in different workbooks - I'm just linking from,
for brevity's sake, sheet1 to sheet2.

On Jul 14, 5:12 pm, Dave Peterson wrote:
These worksheets are in different workbooks, right?

If both workbooks are open when you make the change, then excel will adjust
those links. Remember to save both files when you're done!

If you don't want to open the "sending" workbook, you can name each cell that
gets retrieved. When you insert/delete a row/column, then that named range will
move with the cell. And the formulas that refer to that named range will still
point to that named range.

========
But this kind of stuff scares me.

If possible, I would have a unique key (in column A???) so that I could use
=vlookup() to retrieve values when the key matched.



" wrote:

Hello-
I have a slightly complicated problem, so I'll try to make it as
simple as possible for anyone who wants to help (which I would greatly
appreciate).


I have a large range of data that needs to be entered into a worksheet
and then reordered in a second worksheet. The second worksheet is
nothing but links that put the data from the first worksheet into the
correct order.


My problem is this: whenever I insert a row into the first worksheet,
the numbers from the second worksheet don't change. I would like to
have a permanent link, for example, to cell A1 in Sheet 1, but when I
move that cell to D12, the link in Sheet 2 suddenly refers to D12.


Can the links be made to refer to a location, rather than a datum?
Thanks!


--

Dave Peterson


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.