Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 14th 09, 09:51 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
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   Report Post  
Old July 14th 09, 10:12 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
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   Report Post  
Old July 16th 09, 12:12 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
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   Report Post  
Old July 16th 09, 12:51 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unwanted links come when new rows are inserted Twishlist Links and Linking in Excel 8 October 27th 07 01:27 AM
Unwanted links come with new rows inserted Twishlist Excel Discussion (Misc queries) 0 October 22nd 07 02:18 PM
LINKS TO FOLLOW FROM ONE SHEET (=SHEET2!C3) TO ANOTHER ?? John Excel Discussion (Misc queries) 1 June 21st 07 01:50 PM
Links Don't follow with copy [email protected] Excel Discussion (Misc queries) 1 September 22nd 06 10:37 PM
Inserting rows and having the formula follow workofiction New Users to Excel 1 June 21st 05 04:14 PM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017