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...
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 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.