IP Tool Guide
IP Tool (Excel Macro) — Step‑by‑Step Run Guide (English) 1) What you need (Prerequisites) Microsoft Excel Desktop (Windows/Mac) is required. (Macros do not run in Excel Online / browser Excel.) The tool file must be macro‑enabled : *.xlsm When you open the file, you must allow macros by clicking Enable Content / Enable Macros (if prompted). 2) File structure (Do not change headers) Open the tool file. Go to the sheet named Input . Confirm the columns (row 1 headers) are exactly: Site | Hub | Network | gateway | IP ✅ Only the gateway column is mandatory input. 3) How to enter input In Input sheet, fill Column D (gateway) with values like: IPv4 example: 10.71.149.94/28 IPv6 example: 1234:56:84:789a:0:BcA:0:a001/120 You may also fill Site and Hub columns if you want (optional). Leave Network and IP columns empty — the tool will fill them...