I have a 'Summary' Excel file that is to read information from numerous other workbooks. These other workbooks are all set up identical. They are basically forms filled out by each employee (Name, address, education, experience, etc.) and saved in the same common folder.
The 'Summary' file reads the common folder and lists all of the files saved in that folder. I would like to have a lookup in the 'Summary' file to pull over certain data automatically as the files are saved in the common folder.
I can link over the information cell by cell for each individual file but that is obviously too time consuming. Is there a way to have a formula pull the data over to the 'Summary' file automatically as the common folder is updated?
Thanks,
Chad
The 'Summary' file reads the common folder and lists all of the files saved in that folder. I would like to have a lookup in the 'Summary' file to pull over certain data automatically as the files are saved in the common folder.
I can link over the information cell by cell for each individual file but that is obviously too time consuming. Is there a way to have a formula pull the data over to the 'Summary' file automatically as the common folder is updated?
Thanks,
Chad