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!
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.
> 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!
> 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.
> > 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!
> 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 <peter...@verizonXSPAM.net> 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.
> > > 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!
|
