lookup data from worksheet and overwrite with changes

[Gaellus]

I have a big database (worksheet) of hard coded article data.
Now i would like to overwrite the data of one row when there are some changes.
So below i created an input cell which is B11. Here i put the article which I would like to change. This value looks up all the data from the database (format of database is the same as below) and shows it in A11:AH11
A9:AH9 takes over most of the data but also has formulas in it, so here i could change whatever i need, but then i need to copy this changed article row back to the database and overwrite the old.
Is that possible? Lets say the old data is in row 500 of the database.

brandscalculation2.0.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
9	Lighting	750EMMGL30ZQ1210	dfdsf	ewwegweg	Yes	ewfefe	1525731202	0,451	TAB	$ 140	EA	1	30/0902019	23/09/2019	31/12/2019	0	100	100	510	270	225	30,983	0,310	0,043	0,494	1,05	3,0%	0,0%	-	0,484	3,0%	0,014	0,553	0,484
10
11	Lighting	750EMMGL30ZQ1210	dfdsf	ewwegweg	Yes	ewfefe	1525731202	0,451	TAB	$ 25,00	EA	1	30/0902019	23/09/2019	31/12/2019	0	100	100	510	270	225	30,983	0,310	0,022	0,472	1,00	0	0	0	0,472	3,0%	0,000	0,525	0,472
Existing

Cell Formulas
Range	Formula
A9:I9,K9:U9	A9	=A11
J9	J9	=INDEX(FRONTPAGE!I11:M16,MATCH(NEW!F9,FRONTPAGE!H11:H16,0),MATCH(NEW!I9,FRONTPAGE!I10:M10,0))
V9	V9	=S9*T9*U9/1000000
W9	W9	=V9/R9
X9	X9	=W9/1000*J9
Y9	Y9	=H9+X9
Z9	Z9	=FRONTPAGE!K11
AA9	AA9	=FRONTPAGE!M11
AD9	AD9	=(((1+AA9)*Y9)/Z9)*(1+AB9)+AC9
AG9	AG9	=(AD9*FRONTPAGE!L11)*(1+AE9)+AF9
AH9	AH9	=AD9/L9
A11	A11	=INDEX('CP-Database'!$A:$A,MATCH(Existing!B11,'CP-Database'!$B:$B,0),0)
E11	E11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,4,0)
G11	G11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,6,0)
H11	H11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,7,0)
K11	K11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,10,0)
L11	L11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,11,0)
M11	M11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,12,0)
N11	N11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,13,0)
O11	O11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,14,0)
P11	P11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,15,0)
Q11	Q11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,16,0)
R11	R11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,17,0)
S11	S11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,18,0)
T11	T11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,19,0)
U11	U11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,20,0)
V11	V11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,21,0)
W11	W11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,22,0)
X11	X11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,23,0)
Y11	Y11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,24,0)
Z11	Z11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,25,0)
AA11	AA11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,26,0)
AB11	AB11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,27,0)
AC11	AC11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,28,0)
AD11	AD11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,29,0)
AE11	AE11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,30,0)
AF11	AF11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,31,0)
AG11	AG11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,32,0)
AH11	AH11	=VLOOKUP($B$11,'CP-Database'!$B:$AH,33,0)

Named Ranges
Name	Refers To	Cells
'CP-Database'!_FilterDatabase	='CP-Database'!$A$5:$AH$446	A11

 

[Yongle]

Is this what you want ?
Test on a COPY of your workbook

Sub AmendDatabase()
    On Error Resume Next
    Dim dB  As Worksheet:   Set dB = Sheets("CP-Database")
    Dim B   As Range:       Set B = dB.Columns("B")
    Dim wX  As Worksheet:   Set wX = Sheets("Existing")
    Dim itm As Range:       Set itm = wX.Range("B9")
    Dim r   As Long:        r = WorksheetFunction.Match(itm, B, 0)
    If Err.Number = 0 Then
        dB.Range("A1:AH1").Offset(r - 1).Value = wX.Range("A9:AH9").Value
    Else
        MsgBox itm.Value & " not amended"
    End If
    On Error GoTo 0
End Sub

 

[Gaellus]

Perfect!