Linking Excell Spread sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you Caroline! Worked like a charm!

Caroline said:
Try taking the $ symbols out...

TomLama said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag formula down from columns that go acros 3
using the =page! feature to transpose a row to column 0
Link To File That No Longer Exists 1
Automatically naming and linking controls 6
Question on copying formulas 1
Skip and copy formulas 1
Hyperlink to cells in other workbooks keep changing 3
Problem with changing formula linked to another worksheet 10

Back
Top