Software

Ask something
Discussion Locked

MS Windows Excel linking data from different files

0 helpful
3 replies

by wjchoi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to make a excel file that would contain all of the information from other 6 or 7 excel file. To briefly describe the situation, I want to have one main excel file that shows calander, and other 7 files has same calanders as well, for each department. So that when supervisors from each department puts in a employee that is out on one day, they would put it in their own excel file with calander, and it would also make changes to main excel file. I was able to make link from one auxilary excel file to main by using "=[test1.xls]CALANDER!I7" formula. However, I can't find a way to make link to it from 6 other excel file to the main excel file. Can someone please help me out?

3 replies

by chitosunday

You can use plus sign for numbers or an if statement for text
for numbers
=[test1.xls]CALANDER!I7+[test2.xls]calendar!I7
for text
=if[test1.xls]calendar!i7="",[test2.xls]caldendar!I7

by wjchoi

Poster rated this answer.
I need this link to work for more than one file, and what I need is to have all the values in the cells from 6 files to one main file. The answer you posted only comes out as true or false. I need values showing up on main cell, even if source files contains none.

This discussion is closed to new replies.