I have 2 pages inside one of my zoho sheet spreadsheets. One of them is the factor of the customer and the other one is the database of all of the customers' factors. I need to have a record by macro that whenever I run it, the information inside the sheet 1 (factor table) converts into the sheet 2 (database table) and below the last row relatively. I need my database auto fill when I run the macro. and new information auto goes in the next row of the database table in the sheet 2.

In the excel I use the Use Relative Reference and all I need will be possible. but in the zoho sheet this button (Use Relative Reference) seems not working. I need to use this feature because I just know how to record macro, not how to create macro and vba. So, plz give me a code or a solution to run what I need to do.

sheet 1 :

2-sheet 2