Linking Excel Data

1durks · 2010-08-16 16:19:37

Hi, would appreciate if anyone can help with this. I'm trying to create a summary file that will update automatically from source files in excel, ie. I have numerous monthly data entry files that are seperate workbooks (and not worksheets) whose totals are updated within the same file, I want to link the totals of each of…

16-08-2010 04:19PM

#1
1durks

Closed Accounts Posts: 4 ✭

Join Date: March 2010

Posts: 2
Hi, would appreciate if anyone can help with this.

I'm trying to create a summary file that will update automatically from source files in excel, ie. I have numerous monthly data entry files that are seperate workbooks (and not worksheets) whose totals are updated within the same file, I want to link the totals of each of these files to a seperate file.

Can anyone explain how to do this?

Thanks.

Tagged:

excel

microsoft

office

link

documents

0

Comments

#2 16-08-2010 11:44PM

TiGeR KiNgS

Registered Users, Registered Users 2 Posts: 1,435 ✭✭✭

Join Date: April 2008

Posts: 1329

IF I understand you right

copy the cell(s) that you want to link
open the new workbook and paste special (paste link)

This will stay up to date.

0
#3 17-08-2010 08:17PM

1durks

Closed Accounts Posts: 4 ✭

Join Date: March 2010

Posts: 2

Thanks, that worked perfectly, exactly what I needed to know! Cheers.

0