REVscene - Vancouver Automotive Forum


Welcome to the REVscene Automotive Forum forums.

Registration is Free!You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! The banners on the left side and below do not show for registered users!

If you have any problems with the registration process or your account login, please contact contact us.


Go Back   REVscene Automotive Forum > Vancouver LifeStyles (VLS) > Gaming, Computer Tech & Electronics
Advanced Excel Q - Fetching Cell Values from Multiple .xls files Advanced Excel Q - Fetching Cell Values from Multiple .xls files
Register FAQ Calendar

Gaming, Computer Tech & Electronics Fortnite.CounterStrike.CallOfDuty.Dota.MineCraft.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news...

Reply
 
Thread Tools
Old 10-14-2010, 01:58 PM   #1
I don't like cheese but I love milk!
 
Ferra's Avatar
 
Join Date: Nov 2002
Location: Van
Posts: 1,980
Thanked 895 Times in 243 Posts
Failed 105 Times in 49 Posts
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)
Advertisement
Ferra is offline   Reply With Quote
Old 10-18-2010, 08:17 AM   #2
I don't like cheese but I love milk!
 
Ferra's Avatar
 
Join Date: Nov 2002
Location: Van
Posts: 1,980
Thanked 895 Times in 243 Posts
Failed 105 Times in 49 Posts
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?
Ferra is offline   Reply With Quote
Old 10-18-2010, 08:23 AM   #3
Da Vinci's real masterpiece: The Mona Diesel
 
Jsunu's Avatar
 
Join Date: Nov 2007
Location: Richmond
Posts: 1,797
Thanked 563 Times in 247 Posts
Failed 15 Times in 15 Posts
You might be able to use vlookup:

http://en.allexperts.com/q/Excel-105...ple-sheets.htm
Jsunu is offline   Reply With Quote
Old 10-18-2010, 08:49 AM   #4
MiX iT Up!
 
tiger_handheld's Avatar
 
Join Date: May 2006
Location: vancouver
Posts: 8,150
Thanked 2,075 Times in 871 Posts
Failed 642 Times in 183 Posts
you can link it- but it would not be efficient for for 1000 .xls files.
__________________

Sometimes we tend to be in despair when the person we love leaves us, but the truth is, it's not our loss, but theirs, for they left the only person who couldn't give up on them.

Make the effort and take the risk..

"Do what you feel in your heart to be right- for you'll be criticized anyway. You'll be damned if you do, and damned if you don't." - Eleanor Roosevelt
tiger_handheld is offline   Reply With Quote
Old 10-18-2010, 09:11 AM   #5
Need my Daily Fix of RS
 
Join Date: Feb 2010
Location: Nu Joisy
Posts: 275
Thanked 142 Times in 39 Posts
Failed 28 Times in 19 Posts
have you considered a database instead?
Vinny G is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


All times are GMT -8. The time now is 05:41 AM.
Contact Us - REVscene.net - Archive - Privacy Statement - Top

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