table search

  1. X

    Vbe to search for selected cell value in another table

    The situation is as follows: I have a "main table" which is *full* of data. Im talkin abut 1500 entries. Then i have another table, which is for filtering. I have already figured out how to filter the table for what im looking at. But what i now need is a way to search for a selected value...
    • Xalova
    • Thread
    • excel help find cell value find value same cell value search table help table search vba vba help vba search
    • Replies: 25
    • Forum: Excel Questions
  2. C

    Table Search -> Copy/Paste Code

    Hey all, I'm new to VBA coding and not quite sure where to start with this project nor do I know if it is 100% doable. Below is a image for an overview of what my data looks like: Imgur: The most awesome images on the Internet What I'm trying to accomplish: A table in the "Monthly Cals"...
  3. C

    Conditional formatting- Checkbox tied to partial string lookup

    Trying to get a check box, which is linked to the cell concealed behind it, to have conditional formatting so that when the check box is clicked the value 2 cells to the right (which is a partial string) will be highlighted throughout the schedule. I was thinking this could be done by having...
    • chemjimps
    • Thread
    • check box conditional formatting highlight look up table search
    • Replies: 1
    • Forum: Excel Questions
  4. S

    Need Advice on how to optimize search for records in a table

    I have a table with 60k+ records. I have a VBA code for some function that search for records in this table so I use a WHILE LOOP. The problem is that this goes through each record of 60k+ rcds. So I was wondering if there is a way that search only go to specific (based on key field) records in...

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