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.
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
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
MS Windows Excel linking data from different files