searching sheets

  1. G

    HELP! Trying to search a range for a value and return 1 or 0 on a list

    So I am very new to excel and I have been trying to search a range for a word and return a 1 or zero. Then I need it to loop through the list that will vary in size. I have I keep getting errors. I have been at this for many hours banging my head at it. Here is where the stuff is at: The...
  2. C

    Find a match in one column with other column and then replace it with a value

    Hello, I am trying to match Phone numbers from Customers sheet to the records in Calls_Logs sheet. I want the name in Call Logs sheet to get updated according to matching phone number. I have close to 300000 records so it is impossible for me to do it manually. I tried using this code...
  3. L

    Searching Entire Worksheet with Command Button

    hi I'm new to VBA, but I managed to get this code to work on another sheet, but using it in a new sheet I obviously have to change the range it is searching within (Highlighted in Italics) It needs to be changed to search the entire workbook. Any help? Private Sub cmdFind_Click() On...
  4. P

    Selecting Specific Sheets

    Hello, I have just been sent a timetable for the year. Each day of the year has its own sheet in the Excel document. However, as I am part-time, the only sheets that apply to me are those which say that the top, PT WEEKEND. ITS SO ANNOYING. Does anyone know if it would be possible to perform a...

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