I am trying to reference a series of cells from a "master list" to other lists contained within other files. That way, since the same information appears in multiple files, I can update all of the files simply by updating the "master". The problem that I am running into is that I seem to only be able to do this one cell at a time. When I link cells within the same file, I enter the formula in the first cell, then use the fill function to populate the rest of the column or row. For some reason, now that I am referencing an external file, when I go to autofill the row, all it does is copy the same information that was contained in the first cell, instead of selecting the next cell from the master. I am really hoping that there is a way to autofill this, becuase if not I am going to have to manually enter a TON of formulas.
Thanks!!!
Bookmarks