multiple worksheet search

  1. S

    VB Macro Solution for searching specifics worksheets and entering data

    I am new to MACROs and VB. However, I am building a master personnel data base with automations. In the core worksheet we will input data metrics regarding performance etc. In four other worksheets that break the students down by their class and each year the data migrates (freshmen to...
  2. A

    Search multiple worksheets for search term and paste results in a new workbook

    Hi Guys, I am looking for a little bit of help. I have managed to write some code which enables me to search for some text via an input box. I can then copy the relevant column and also copy columns A and B on the same worksheet. I then paste this information into a new worksheet named...
    • Andy15
    • Thread
    • multiple worksheet search new workbook opening
    • Replies: 7
    • Forum: Excel Questions
  3. 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...
    • AmraEx
    • Thread
    • match multiple workbook search multiple worksheet search reference cell return a value
    • Replies: 0
    • Forum: Excel Questions
  4. X

    Using 3 sheets to build finance report

    Very stuck here. Need to build a report based off of a template (contains specific headers): <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Bill code Product ID First Name Last Name Item No. Date ordered date sold sales Qty Payment...
  5. K

    vba code for finding all rows across multiple sheets

    Hello all !! I KNOW this has to have been answered in forum... but I have spent hours on here and I just can not find it even though I thought I saw it. (ever have one of those days. I am not an expert at all in VBA but I am in need of a code that will search multiple tabs (worksheets)...

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