I'd like to ask how to add, copy and display next to another sheet. For example, I have a data in column A on rows 1 to 4 and a button named save inside sheet 1. When I enter the save button, the data in sheet 1 will copy to sheet 2 on same column and row.
When I have new data, it will add up to to row 2 from row1 under sheet2.
The data should be like this:
Sheet1
Name Address Age Birthdate
Sheet2:
Row1:Name Row1:Address Row1:Age Row1: Birth date;
Row2:Name Row2:Address Row2:Age Row2: Birth date