Hello
Need help with a macro to extract ip address from sheet2,sheet3... matching with the range in subnets in sheet1.
In this sample file attached, have 2 sheets(sheet1,sheet2)
Sheet1 has ip address with subnet (/xx)
Sheet2 has ip address and other data
In some cases, i have ip address in different column in other sheets,if ip address matches ip from the range in subnet, it must extract complete row to sheet1
Help is appreciated.
Need help with a macro to extract ip address from sheet2,sheet3... matching with the range in subnets in sheet1.
In this sample file attached, have 2 sheets(sheet1,sheet2)
Sheet1 has ip address with subnet (/xx)
Sheet2 has ip address and other data
In some cases, i have ip address in different column in other sheets,if ip address matches ip from the range in subnet, it must extract complete row to sheet1
Help is appreciated.