Sixthsense,

The below line is entered / update by this macro in sheet "PartsData".


Set myCopy = inputWks.Range("UpdateEntry")
Set myView = inputWks.Range("View")
"UpdateEntry" is named range of data to be update from sheet "Input" to sheet "PartsData".

Hope, i clear myself on this.