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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,211,792
Messages
6,104,000
Members
447,889
Latest member
birdman15

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
Back
Top