Gaming, Computer Tech & Electronics Fortnite.CounterStrike.CallOfDuty.Dota.MineCraft.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news... |
 |
10-14-2010, 01:58 PM
|
#1
|
|
I don't like cheese but I love milk!
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)
|
|
|
|
10-18-2010, 08:17 AM
|
#2
|
|
I don't like cheese but I love milk!
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?
|
|
|
|
|
10-18-2010, 08:23 AM
|
#3
|
|
Da Vinci's real masterpiece: The Mona Diesel
Join Date: Nov 2007
Location: Richmond
Posts: 1,797
Thanked 563 Times in 247 Posts
Failed 15 Times in 15 Posts
|
|
|
|
|
|
10-18-2010, 08:49 AM
|
#4
|
|
MiX iT Up!
Join Date: May 2006
Location: vancouver
Posts: 8,153
Thanked 2,076 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
|
|
|
|
|
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?
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -8. The time now is 05:39 AM.
|
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!
