getting specific info from all *.xls in a given folder

K

Kronos

Hi all,
Does anybody know if there is any possiblity to get some specific
information from all the workbooks (on first worksheet) that exist in a
particular folder (let's say C:\Data).

To give some exemples:
- how to get all cells K25 (f. ex) from all these workbooks listed on one
new worksheet one under another?
- how to get directly the average of all above-mentionned cells?
- how to get all cells K22:K25 (one under another)?
- how to get all the cells that have somewhere in the same row the cell that
contains a specific name (f. ex "Bill Gates")?

Any ideas???
Thanks in advance for all hints!

Kronos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
Run macro on all files in a specific folder 3
Search other sheets for numbers & color them 10
VBA Macro Training in Chennai 0
Ignoring a runtime error 1
Snake pre-defined range from multiple worksheets. 0
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file 10
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1

Top