I'm trying to out do myself, I have a basic form built out with drop downs and blanks.
So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex. Sheet3!B25) But I'm trying to make a vba that will goto said location and replace the value with the value in the cell from the form (ex. Sheet1!B7)
So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex. Sheet3!B25) But I'm trying to make a vba that will goto said location and replace the value with the value in the cell from the form (ex. Sheet1!B7)