VBA code to take input values and update worksheet linked to current values

[Nlhicks]

Current Values Formulas take the search Criteria Values of From, To and Circuit number and look in another sheet to find the correct line based on the criteria.

=INDEX('Facility Ratings & SOLs (Lines)'!B:B,SMALL(IF(ISNUMBER((SEARCH(C3,'Facility Ratings & SOLs (Lines)'!J:J))*(SEARCH('Update Spreadsheet'!C4,'Facility Ratings & SOLs (Lines)'!K:K))*(SEARCH('Update Spreadsheet'!C5,'Facility Ratings & SOLs (Lines)'!AK:AK))),MATCH(ROW('Facility Ratings & SOLs (Lines)'!J:J),ROW('Facility Ratings & SOLs (Lines)'!J:J)),""),ROWS('Facility Ratings & SOLs (Lines)'!$A$1:A1)),COLUMNS('Facility Ratings & SOLs (Lines)'!$A$1:A1))

=INDEX('Facility Ratings & SOLs (Lines)'!C:C,SMALL(IF(ISNUMBER((SEARCH(C3,'Facility Ratings & SOLs (Lines)'!J:J))*(SEARCH('Update Spreadsheet'!C4,'Facility Ratings & SOLs (Lines)'!K:K))*(SEARCH('Update Spreadsheet'!C5,'Facility Ratings & SOLs (Lines)'!AK:AK))),MATCH(ROW('Facility Ratings & SOLs (Lines)'!J:J),ROW('Facility Ratings & SOLs (Lines)'!J:J)),""),ROWS('Facility Ratings & SOLs (Lines)'!$A$1:A1)),COLUMNS('Facility Ratings & SOLs (Lines)'!$A$1:A1))

=INDEX('Facility Ratings & SOLs (Lines)'!D:D,SMALL(IF(ISNUMBER((SEARCH(C3,'Facility Ratings & SOLs (Lines)'!J:J))*(SEARCH('Update Spreadsheet'!C4,'Facility Ratings & SOLs (Lines)'!K:K))*(SEARCH('Update Spreadsheet'!C5,'Facility Ratings & SOLs (Lines)'!AK:AK))),MATCH(ROW('Facility Ratings & SOLs (Lines)'!J:J),ROW('Facility Ratings & SOLs (Lines)'!J:J)),""),ROWS('Facility Ratings & SOLs (Lines)'!$A$1:A1)),COLUMNS('Facility Ratings & SOLs (Lines)'!$A$1:A1))

Not sure where to start with taking the user input and making a change to the existing number but when it changes it should show up in the current values with the changed value.