How to search multiple workbooks for a specific value in a specific cell

I'm trying to search through multiple worksheets (that are closed) to see if a value in cell B12 (of every worksheet) matches a value in a seperate worksheet (which is in a seperate workbook)

Hi

1) Where is the file being searched? In the same place as the file that you wish to compare?
2) Can the closed file be opened for testing?
3) Is there a fixed number of sheets in the closed file, and do they have a constant name?
4) What do you want to do with the result of the test?

I'm sure there are more details required, so how about giving us some more details on exactly what you want to do so we can offer some assistance.


rylo

Hi
The info you gave is insufficient.The attached book has macro which pulls all B12 values from all workbooks of the folder where you save this workbook. Tell us what do you want it compared with
Ravi

2)Can the closed file be opened for testing?

The closed file can and will be opened periodically.

3) Is there a fixed number of sheets in the closed file, and do they have a constant name?

New sheets will be added to the file, but they will all start with 'Invoice' followed by their invoice # (e.g., Invoice29)

4) What do you want to do with the result of the test?

I have one file that contains a sheet (InventoryOut) with an array of Invoice #'s on the vertical axis and names of different rental items on the horizontal axis.
Within this same file I have a sheet that is used as an Invoice template. What I mean by this is that it has all the columns with amount and type of rental and the formulas which automatically calculate the total dollar amounts. This sheet has a button that saves the sheet into a different workbook specifically for completed Invoices and then clears all the data just inputted so as to have an empty Invoice sheet again. This Invoice Sheet also contains a cell with an Invoice# in it that automatically goes up by one each time an invoice is saved.
My next task is to add a macro to the save invoice button that matches the invoice# in the Invoice sheet to the corresponding row that contains the invoice# in InventoryOut. Then copy the rental amounts into their corresponding rental type column.
After explaining my problem in more depth I think my original question is irrelevant, and my modified question is contained in the aforementioned paragraph.

Any help would be greatly appreciated.

Hi
From the invoice sheet, which cells are to be picked to get Rentx,REnt y and rent z values for invoice out sheet
Ravi

All cells under description will be either rental x,y, or z. I want to take the values from the quantity column and and put those quantities in the correct row and column of the InventoryOut sheet

I have a problem similar to this one and I think I can get my solution from here.

Basically I have a master excel file where I want to import, on a daily basic, from different Excel files in a specific folder, from specified Cells.

I want for example, on Master.xls, to import cells A1,B8,C9 from All the files in the folder c:\Documents\Reports\, to the cells A1, A2, A3 (in that order) in the main Master.xls

Here is a schematic attached to show what i want in a visual way.

Originally Posted by ravishankar

Hi
The info you gave is insufficient.The attached book has macro which pulls all B12 values from all workbooks of the folder where you save this workbook. Tell us what do you want it compared with
Ravi

I have taken this file and modified it to pull the information instead of from B12, to pull it from E76.

This does exactly what I want it to do!!!

What I want to change is basically to import the data E76 to A1, E77 to A2 and so on.

ALSO, How can I make it so that it doesnt put in the cells the name of each file??

Oh ok, sorry about that!!! Since it was all the same you know...

You need to have save button that will post all relevant information to the inventory sheet, including the invoice number. You don't need to put the invoice numbers in un til they are used.

The problem with that solution is that I forsee having problems modifying a saved invoice, and still I'm not sure how to post all the relevant information into the correct columns, possibly with the FIND function.

Any ideas?

who is hijacking the post? you can see i have only posted about 5 times. you told me about the rule, i accepted the rule, accepted responsibility and apologized and then i did what you told me to do and posted in a new thread.

i will keep reading this because its exactly what i want to do, but ill ask my questions in "my thread"

I need to find the row with the invoice # and the column that contains the correct rental description. I'm using the array in InventoryOut to automatically update the inventory not just as a place to keep all the old invoice data.