nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Child Item

Home
Topics
Technology & Internet
Computers & Technology
Computers & Technology

Linking Excel Data

1durks

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.

Find more posts tagged with

excel

microsoft

office

link

documents

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of

Comments

TiGeR KiNgS

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.

1durks

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