REVscene Automotive Forum

REVscene Automotive Forum (https://www.revscene.net/forums/)
-   Gaming, Computer Tech & Electronics (https://www.revscene.net/forums/gaming-computer-tech-electronics_32/)
-   -   Advanced Excel Q - Fetching Cell Values from Multiple .xls files (https://www.revscene.net/forums/627577-advanced-excel-q-fetching-cell-values-multiple-xls-files.html)

Ferra 10-14-2010 01:58 PM
Advanced Excel Q - Fetching Cell Values from Multiple .xls files
 
Say I have a folder with 1000 excel files in a standard "form" format, and each has different values in the form.

Is there any functions or VBA I can use to automatically fetch a particular cells values (e.g. A5, C8..etc) from all 1000 excel files? (and consolidate them into a list of values on one spreadsheet)

Ferra 10-18-2010 08:17 AM
hmmmmm no one has any clue? anyone knows any good excel forum which might give me the answer?

Or this probably can't be done with just excel?

Jsunu 10-18-2010 08:23 AM
You might be able to use vlookup:

http://en.allexperts.com/q/Excel-105...ple-sheets.htm

tiger_handheld 10-18-2010 08:49 AM
you can link it- but it would not be efficient for for 1000 .xls files.

Vinny G 10-18-2010 09:11 AM
have you considered a database instead?


All times are GMT -8. The time now is 05:29 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
SEO by vBSEO ©2011, Crawlability, Inc.
Revscene.net cannot be held accountable for the actions of its members nor does the opinions of the members represent that of Revscene.net