I am looking for VBA expert.
The requirements are to make an excel file which will manage all the mac address in the given range.
Generate the make adress in the given range (must be by the HEX rules of course !)
Generation will be in the column every MAC has a row
Another column will have the MAC with his checksum of the mac respectively to the MAC row, 2 checksum types :
1-CheckSum Modulo 256
2-(CheckSum 2s Complement)-1
example MAC : 11-22-33-AA-BB-CC
checksum row will be : 11 22 33 AA BB CC 97 68
Please have a look sample excel file.