Find values

[steffe]

I have many folders with the same excel file, which also have same name (logg). How do I list up these files in excel? I want excel to list up these files with folder names in a specific cell.

Example:

Folder: (Test1) Folder: (Test2)


Folder (Test1) logg cell A1

Folder (Test2) logg cell A1

This should show the value in cell A1, in every folder that has this File (logg).



If you have any ideas how I should go forward here, please let me know.

 

[oldbrewer]

so folders 1 2 and 3 all have files named bob.xls

what is your question related to this scenario

 

[hiker95]

steffe,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


See if any of the below links will help you:

Merging Data from Multiple Workbooks into a Summary Workbook in Excel
Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Use ADO to copy from closed workbooks
http://www.rondebruin.nl/ado.htm

For other code examples see my Dir page
http://www.rondebruin.nl/copy3.htm

Another way is to use this add-in: RDBMerge
RDBMerge, Excel Merge Add-in for Excel for Windows

Transferring data from a closed workbook
Transferring data from a closed workbook

Get data from closed workbooks
Erlandsen Data Consulting