CFO_In_Training
New Member
- Joined
- Oct 29, 2014
- Messages
- 10
Hello,
I have 2 files. file 1 collects information from multiple files, just numbers.
i want to be able to type in a person's name in file 1, and have it use that name in multiple formulas in that file to grab different cells in file 2.
i.e. ='c:\temp\jonsmith_file.xlsx'!C1. I want to be able to concatenate the name from 2 cells, and create the file name location...
thanks in advance!!
I have 2 files. file 1 collects information from multiple files, just numbers.
i want to be able to type in a person's name in file 1, and have it use that name in multiple formulas in that file to grab different cells in file 2.
i.e. ='c:\temp\jonsmith_file.xlsx'!C1. I want to be able to concatenate the name from 2 cells, and create the file name location...
thanks in advance!!