How to automatically paste or store new data in a new row below old data using formula (without macro)

[Adiadidas]

Hi, i wanna make a transaction sheet that need to store/save every transaction, so how to automatically paste or store new data in a new row below old data using formula (without macro)?

Thankyou

	Transaction				Transaction History
	Code	Product	Quantity		Code	Product	Quantity
	FT-010	Banana	10​		FT-010	Banana	5​
	FT-020	Mango	5​		FT-010	Banana	5​
	FT-030	Lemon	15​		FT-030	Lemon	10​
					FT-020	Mango	10​
					FT-010	Banana	10​
					FT-020	Mango	5​
					FT-030	Lemon	15​

 

[Adiadidas]

need help, the Xl2bb addin didn't work on my excel 2019