Job description
I will order to make four buttons that will be in the form of a macro in Excel, which will be in short: assign the selected computer with the value of the free IP address and in the other direction released the value of the assigned IP address from the computer, and two search buttons by one value and by another value.
SHEET A - device data (locked with password to edit)
SHEET B - IP addresses in the company (locked with a password to edit)
SHEET C - result sheet (locked with password to edit)
On SHEET A
After selecting a row and clicking on the BIND IP button, we call up the form in the format:
Sheet B data: selection of LOCATION, after selection we move to selection of NETWORK, after selection we move to selection of free IP ADDRESSES (only those with status FREE).
Once the correct IP address is selected, the selected claim from SHEET A would be copied to the resulting sheet with additional columns filled in as selected in the form (SHEET C) and accompanying columns in this sheet
The next time the form is called up, the IP address selection menu could no longer show the previously selected IP address, and in sheet C, the last column STATUS would be in the form of FREEDOM or ACCEPTED
The second form, after calling the FREEDOM IP button, would call up the form in the format:
Data from Worksheet B: IP ADDRESS selection (only those with a status of TAKEN).
The third button searching for IP Address showing the result from SHEET C.
The fourth button searching for MAC Address showing the result from SHEET C.
URGENT. I REQUIRE VERY FAST COMPLETION.
