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

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

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