I have lots of different excel files with data filled in by technicians who install computers and for each computer, they make an excel file that is pre-made and they just fill it out. So for each computer, I have a different file.
Is there a way to take a new excel file and have it import data from each separate excel file?
For example, Imagine I have excel files named Computer 1 and Computer 2, each of them with the same exact layout but different data, THEN I have another filed named Computer_Summary, also an excel file.
Can I have the data from cells A1, A2, and A3 from both Computer 1 and Computer 2, go into the cells B1, BG2, and B3 in Computer_Summary ?
Thank you so much in advanced for any help you can give me or point me to resources where I can find this information.
Bookmarks