Thank you guys for your reply
What I did was make it to a table. it only worked at the H rows my problem now is that every time I insert a row in the table1 created only row H automatically copies the formula . other rows like I and J isn't copied automatically left blank
the formula inside my H rows is
VLOOKUP(G20,'COMPANY TRN'!$A$2:$B$136,2,FALSE)
the formula inside my I rows is
J22*0.05
Sorry Im looking for no VBA on this one