Searching and returning cell data from closed workbooks.

awakening

New Member
Joined
Nov 26, 2005
Messages
2
Hi

I have searched everywhere for this and apoligise if it is on the board already. I would be grateful for any help.

I need to create a workbook that has a cell for users to enter a seven digit ID number. When the number is entered, Excel will search through Row B of multiple Excel files and folders (all closed) for that number. If the number is found, the sheet will then return the name of the file, the name of its folder and the data that lies in the cell adjacent the number in Row C (which is a client's name).

Thanks

Chris
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
Welcome to MrExcel Board!

Do you know what the sheet names will be? When I've done this from a closed workbook, I had to know the worksheet names ahead of time.
 

awakening

New Member
Joined
Nov 26, 2005
Messages
2
Thanks for the welcome.

The folders being searched will be called 'CR', 'Store' and 'Destroyed'. All three will be located in folder 'Archives'. The files in these folders will be called Box 1, Box 2, Box 3 etc...

Ideally the sheets used in these files would just be default - Sheet 1. Only one sheet is used in each. If they need to to be changed so they are unique, they can be the same name as their file (eg Box 1).

Thanks

Chris
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
Here's one way. Very slick, Nimrod! There's other posts out there, for sure, if you search the board. HTH
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,809
Messages
5,833,790
Members
430,233
Latest member
cbutts

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top