| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Excell Spread sheets
Hi,
We are trying to link data from workbook to workbook. We are doing this so that individual workstations can update their own work and have this update the master workbook. After we link one cell, we would like to use the copy function by dragging the bottom right hand corner. We have some luck with this dragging across and pulling the links. However when we try to drag down the links do not follow. We then must go cell to cell to tie the link again. This takes time. I know we must be just one formula symbol away from successfully dragging the links. Here is what our formula looks like now......Cell = [TOMS ACCOUNTS CONTROL SHEETS.xls]Monthly Accounts'!$F$12 What do we have to add to this formula so that we may copy up and down and side to side by dragging the links? Thanks! Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Excell Spread sheets
Try taking the $ symbols out...
"TomLama" wrote: Hi, We are trying to link data from workbook to workbook. We are doing this so that individual workstations can update their own work and have this update the master workbook. After we link one cell, we would like to use the copy function by dragging the bottom right hand corner. We have some luck with this dragging across and pulling the links. However when we try to drag down the links do not follow. We then must go cell to cell to tie the link again. This takes time. I know we must be just one formula symbol away from successfully dragging the links. Here is what our formula looks like now......Cell = [TOMS ACCOUNTS CONTROL SHEETS.xls]Monthly Accounts'!$F$12 What do we have to add to this formula so that we may copy up and down and side to side by dragging the links? Thanks! Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Excell Spread sheets
Thank you Caroline! Worked like a charm!
"Caroline" wrote: Try taking the $ symbols out... "TomLama" wrote: Hi, We are trying to link data from workbook to workbook. We are doing this so that individual workstations can update their own work and have this update the master workbook. After we link one cell, we would like to use the copy function by dragging the bottom right hand corner. We have some luck with this dragging across and pulling the links. However when we try to drag down the links do not follow. We then must go cell to cell to tie the link again. This takes time. I know we must be just one formula symbol away from successfully dragging the links. Here is what our formula looks like now......Cell = [TOMS ACCOUNTS CONTROL SHEETS.xls]Monthly Accounts'!$F$12 What do we have to add to this formula so that we may copy up and down and side to side by dragging the links? Thanks! Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excell spread sheet | Excel Discussion (Misc queries) | |||
| archiving spread sheets | Excel Discussion (Misc queries) | |||
| The history of spread sheets | Charts and Charting in Excel | |||
| Charts from Spread sheets | Excel Discussion (Misc queries) | |||
| linking selected data between Excell sheets | Excel Discussion (Misc queries) | |||
Linear Mode
