How make Copy the last row and paste in another sheets with formula/ apps script-CodePudding

I have the following problem:

I have 2 spreadsheets (Date_imported; Data) one in which I get the data from a database and I used the IMPORTRANGE formula and in the other ("Data") I want to bring the last value from the X column. In the spreadsheet Date_imported for each day, new data is added at the end. I tried different scripts but unfortunately without success. I am just starting out on this programming language.

CodePudding user response：

try:

=INDIRECT("Sheet1!"&
 ADDRESS(MAX(ROW(Sheet1!A:A)*Sheet1!A:A<>""); 1)&":"&
 ADDRESS(MAX(ROW(Sheet1!A:A)*Sheet1!A:A<>""); COLUMNS(Sheet1!1:1)))

CodePudding user response：

I want to take the latest values for Index 1,2,3 from the "Data" spreadsheet and automatically put them into the "Application" Index 1,2,3 spreadsheet. Thanks !

Index 1:

=vlookup(A3;sort(Date!A2:C;2;0);3;0)

Index 2:

=vlookup(A4;sort(Date!D2:F;2;0);3;0)

Index 3:

=vlookup(A5;sort(Date!G2:I;2;0);3;0)