Excel Forum

Link Data from one Workbook to another Workbook

Don Jingle

New Member

Members

Forum Posts: 1

Member Since:
March 27, 2021

Offline

March 27, 2021 - 11:30 am

How to sum up the total amount from Workbook 1 and Workbook 2, then I wanted to post the result in Workbook 3.

I am expexting that if the total amount in Workbook 1 and 2 changes, the total amount in Workbook 3 should change authomaticaly.

I am using Microsoft Excel 2016.

Lionel Baijot

Member

Members

Forum Posts: 114

Member Since:
September 9, 2020

Offline

March 27, 2021 - 9:13 pm

Hi,

Answering the question at time X is very easy. The problem will come as soon as the data will be modified, will evolve, will grow... The easiest way would be to use Power Query which will allow you to automatically retrieve the data from your files 1 and 2 and add them in file 3.

You could already see these two links:

BR,

Lionel

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: RAQUEL ACION, Dana Friedt, Nada Perovic

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Forum Stats:

Groups: 3

Forums: 24

Topics: 6218

Posts: 27266

Member Stats:

Guest Posters: 49

Members: 31901

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen