Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one work book to another....
I am linking cells from one workbood to another....I'm doing this by entering
= in the destination cell then clicking on the cell in the master and hitting enter. This way I can only do one cell at a time....is there a way to link multiple cells at one time to speed up the process...I have approximately 30,000 cells that I need to link...please help.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one work book to another....
In the top left cell for the link,
just change the absolute* cell references to relative eg from: =[Book1]Sheet1!$A$1 to: =[Book1]Sheet1!A1 Then you can fill across and down to link correspondingly *absolute cell refs seem to be the defaults inserted by Excel when you click to link sheets across books -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Chris" wrote: I am linking cells from one workbook to another....I'm doing this by entering = in the destination cell then clicking on the cell in the master and hitting enter. This way I can only do one cell at a time....is there a way to link multiple cells at one time to speed up the process...I have approximately 30,000 cells that I need to link...please help.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one work book to another....
This doesn't seem to do anything....
"Max" wrote: In the top left cell for the link, just change the absolute* cell references to relative eg from: =[Book1]Sheet1!$A$1 to: =[Book1]Sheet1!A1 Then you can fill across and down to link correspondingly *absolute cell refs seem to be the defaults inserted by Excel when you click to link sheets across books -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Chris" wrote: I am linking cells from one workbook to another....I'm doing this by entering = in the destination cell then clicking on the cell in the master and hitting enter. This way I can only do one cell at a time....is there a way to link multiple cells at one time to speed up the process...I have approximately 30,000 cells that I need to link...please help.... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one work book to another....
Got it....thanks.....chris
"Max" wrote: In the top left cell for the link, just change the absolute* cell references to relative eg from: =[Book1]Sheet1!$A$1 to: =[Book1]Sheet1!A1 Then you can fill across and down to link correspondingly *absolute cell refs seem to be the defaults inserted by Excel when you click to link sheets across books -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Chris" wrote: I am linking cells from one workbook to another....I'm doing this by entering = in the destination cell then clicking on the cell in the master and hitting enter. This way I can only do one cell at a time....is there a way to link multiple cells at one time to speed up the process...I have approximately 30,000 cells that I need to link...please help.... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one work book to another....
"Chris" wrote:
This doesn't seem to do anything.... And why not ? .. with the premise that the links are of course over a contiguous range (surely you don't have 30k discontiguous cells to link to, do you?) Assume you want to link to Sheet1's A1:E10 in Book1.xls within a corresponding range in Book2.xls's Sheet1 With Book1.xls open, In Book2.xls's Sheet1, Place in say, A1: =[Book1]Sheet1!A1 Note that there should be no "$" signs for "A1" in the formula. This was the point in my earlier response on Excel's default behaviour. If you formulate the links via point and click across books, the "$" signs are automatically inserted by Excel. Then just copy A1 across to E1, fill down to E10 to achieve the linkages -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one work book to another....
Good to hear that. Pl ignore my clarification to your earlier comment as it
crossed your 2nd response here -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Chris" wrote in message ... Got it....thanks.....chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Work Book Caption | Excel Discussion (Misc queries) | |||
Creating a work book | New Users to Excel | |||
Making changes in all pages in a work book | Excel Discussion (Misc queries) | |||
master select page field for many pivots in one work book | Excel Discussion (Misc queries) | |||
Breaking of serial check in excel work book | New Users to Excel |