Forum Discussion
Extract specific cell data from multiple files into a new file
Hi all. I'm about a 6 out of 10 on excel knowledge, but learning everyday. Is there a way to extract specific cell data from multiple files and list that data into a new worksheet? Example: If...
mathetes I had heard of this possible scenario and as you noted, also realized the hurdle of the source files having different names. Hmmm..... I'll try with at least one file to see if I can get that to work and then move on to the next hurdle. Thanx again.
Part of it will depend on what you want that summary file to do, how dynamic the whole system is--how frequently the source files change or whole new sets are created. In my case, I just download fresh (investment related) data but continue to use the same set of file names for a very finite set of source data.
Is it possible for you to post some sample files, both of your intended summary sheet and one or two source files?