Software

General discussion

Gravatar
Locked

MS Windows Excel linking data from different files

By wjchoi ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by chitosunday In reply to MS Windows Excel linking ...

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

gravatar
Collapse -

by wjchoi In reply to

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.

gravatar
Collapse -

by chitosunday In reply to MS Windows Excel linking ...

Can you give specific example so i can test my formula

Back to Software Forum
3 total posts (Page 1 of 1)  

Start or search

Related Forums