Create Links Between Cell Ranges (Quickly)
The Paste Special feature can be used to quickly link to range of cells from another sheet.
In the example below, we have a table on the sheet labelled First. We want to link to the bottom row from the sheet labelled Second
Select the desired range for linking b9:D9, then select Edit - Copy
Now go to the sheet from where we will be linking. Select the start cell of the new range (corresponding to B9 )
Now select Edit - Paste Special.
The Paste Special dialog is shown below. Select the Links option on bottom left.
The end result. The equations are for illustration. This may seem like overkill for a few cells - but can be very useful if yu have a very large range of cells that you need mapped to another spreadsheet.
January 12th, 2008 at 3:26 am
This is fine, but I don’t want the data from the other sheet replicated,
I simply want to do a vlookup on it by using the named block instead of having to remember the inclusive cell coordinates such as:
list of property addresses with a property ID like:
A B
1 PID Address
2 1 425 Jones St
3 2 357 Smith St
4 3 999 Adams St
… the other 397 listings
400 400 633 Johnson St
The cells A2..B400 are named _props they are in the properties.ods calc sheet.
In my Workorder sheet I want to assign address number 3 to be mowed.
Ordinarily using quattro Pro I would use the following assuming the cell
at k5 is “3″
=(vlookup($k$5,[filename]SheetName:_props,2)
I cannot locate any similar syntax for referring to a named block
in another calc file.
Naturally I can’t have multiple copies of the data in _props floating around,
I only want it edited and updated and increased in the one file to avoid
errors.
I just want to use the information in _props in other sheets. My biggest complaint in Quattro Pro is that I can’t open in a separate instance so I can
alt-tab back and forth for human lookups.
Maybe I’m approaching from the wrong direction.
Thanks.
vlookup(k5;L:\Properties.odsProperties.A2:J1010″