multiple workbook search

  1. C

    Loop through sheets on multiple workbooks

    Hello! This could be a bit complicated, but I am going to try to explain this as best I can. I need a VBA code to loop through most (not all) sheets on about 10-12 different workbooks (I can add more WB names to the code as they are created) and extract a varying range of cells that will be...
  2. M

    Searching cells across workbooks and displaying workbook name

    Hi, Not actually sure if this is going to need VBA or can be solved with a simple excel formula, what I'm trying to achieve is: I have 48 names in workbook 1, I then need to search 43 different workbooks to find out if that name shows up in any one or all of the 43 different workbooks. The name...
  3. R

    If Vlookup is true return a different cell's value.

    I'm looking to be able to run a vlookup or something similar that would check if the requested cells value is there but if it is then it should respond by showing the value of a cell from another column rather than the one it's looking at. What's the best way of doing this? Thinking maybe it...
  4. C

    VLOOKUP from cell selection

    How wold I go about implementing a VLOOKUP that takes it's array range from a cell value? For Example. A1 = Sheet1 B1 = '[C:\Documents\File1.xls]Sheet1' A2 = Sheet 2 B2 = '[C:\Documents\File1.xls]Sheet2' A3 = Sheet 3 B3 = '[C:\Documents\File1.xls]Sheet3' Instead of hardcoding: D1 =VLOOKUP(C1...
  5. R

    Multiple Sheets Filtered By Dropdown

    Hi All, I am looking for some help, I am trying to filter the overall results that i receive on my spreadsheet by a drop down filter. I currently have two separate spreadsheets, One has all my data and the other is an application i am trying to build to analyse data depending on the criteria in...
  6. A

    Searching throughout multiple sheets and returning values between multiple workbooks

    Hello, I would appreciate any help with following. I have two excel workbooks, both containing multiple worksheets. I need to do following: - search the excel workbook 1 for a text from workbook 2 - when it is found - return a value from a specific cell in the sheet in workbook 1 (sheet...
  7. V

    Compare two columns in one workbook with two columns in another work book and return values

    I have a problem and in desperate need of help. I am trying to create an analysis tool to compare the information in two workbooks and return data to the source workbook. For example; I have two work books, one current and one history that I want to compare and return the status and status date...
  8. A

    Comparing data in two excel workbooks and creating a new file removing duplicates.

    Hi, Have been asked by a friend to look at this and I’m struggling. They have an 'invoice statement' with invoice numbers (column A) and a 'invoice paid' again with invoice numbers (column B). I want to have a separate workbook 'Statement II' which will be an update on 'invoice statement'...

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