I am in need of some assistance with an issue I am having with copying a row from one sheet within my workbook and adding it to another sheet.

I have two sheet within my workbook and I will call them Sheet A and Sheet B. Now Sheet A is used to pull values from Sheet B using vLookup based on a part number. When I do the lookup based on the part number

I have on occasion needed to edit some of the values of said lookup. What I am done editing I have a row at the bottom of my Sheet A at row 28 that uses “=CELL” to pull the edited data down and this is the row I want to add to Sheet B.

What I am looking at doing is creating a button that will automatically look at Sheet B and if the record based on the part number already exist it overwrites that row with the new data, if that row doesn’t exist it adds the row to the bottom of Sheet B

I have been looking all over for help with this with no luck. Would someone point me in the right direction.