I have 3 files, A, B, and C. File C is linked to A and B. The first sheet in file C is called Input sheet and is the only sheet in C that is linked to A and B files. I am currently using INDIRECT function on all 50 plus linked cells so that at each new jobs A and B files will have different names and what I do is write the new names of both files into two cells so that the linked cells are updated with the new files names. My problem is that I have to open both A and B and keep them open so that I have the information available in the input sheet which feeds several other sheets.
I am thinking of developing a Macro that by nowing the names of the two files (A and B) it opens both and then copies Input sheet in file C and paste values in the same locations in the input sheet so that file C becomes independant of files A and B.
Bookmarks