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?
- Unfortunately I'm still in the "brainstorming" phase, but the source files/worksheets will be static with fixed cell inputs, its just that the names will change for each file. The source files will contain dropdown options (3-5 to choose), some of which would be choices like "good, marginal, bad, etc..." and from there I'd like to extract key data points for each worksheet and then be able to sort them by the "good, marginal, bad, etc..." ratings.