Post Data entry Sheet stored permanent in other sheet as database

Copper Contributor

Hi Folks,
I have 3 sheets in excel book. sheets CDN, USD which will be used as data entry. Database sheet will be used to store data permanently.
Whatever and whenever Entries are made in CDN, USD sheet should be stored here in database sheet.
Even the entry has been deleted from CDN USD, it should still remains in this database sheet.
Thanks in advance.

 

One thing that i don't want: i don't want to convert the CDN, and USD sheet into the formatted table.

following is the sample data of sheet CDN

0 Replies