search unique text

  1. K

    search cells for unique part and paste in new column -- difficult VB

    Hello, i am new to the boards and am struggeling with some macro i would to use. I've looked for some examples but cannot find what i would need. The current table is as follows: <tbody> ID Column header 1 recorded power 2200W 2 diameter 8 mm 3 lenght 15 mm 4 lenght 5 mm 5 lenght 10...
  2. N

    Macro challenge: verify on change that value is unique !!

    I need to setup a macro to run on cell change (e.g. by using "Private Sub Worksheet_Change(ByVal Target As Range)"). Case: technician will use bar scanner to scan several batches. Some times there are two batches with the same master ID and in these cases I need the code to find the next vacant...

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