Help with Work books

guitarstar

New Member
Joined
Dec 20, 2005
Messages
2
Hello, Is it possible for diffrent work books to talk to each other? I run a large car dealership and I keep running daily stats from different departments - in different work books. It would be awesome if I could generate a master book that tallied all the departments...
If someone could help it would be appreciated...
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
That depends on what you mean "talk to eachother"

Files can be linked to other files by selecting a cell in one file (empty cell) and hitting the "=" key for a formula and then just going to the other sheet and selecting which cell you want the value for...

When you click the cell and hit enter, the value from the other workbook is in the first.
Book1
ABCD
1Workbook1
2Workbook2
3
Sheet1
Book2
ABCD
1Workbook2
2
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,129
Members
412,305
Latest member
Mozz
Top