Link last 15 days of data.

[Analystbycuriosity]

Data sample:
08/12/2017 6.2 6.5
09/12/2017 6.3 6.8
10/12/2017 6.4 6.7
11/12/2017 6.3 6.6
daily values are added one below the other in sheet 1

i have to copy last 15 days data in sheet 2 daily.
say, 2 columns & last 15 rows
27/11/2017 6.2 6.7
to..... ....
11/12/2017 6.3 6.6
How do i link data of sheet 1 to sheet 2 so that the next day without manually copying, it shows
28/11/2017 6.1 6.7
to.... ... ...
12/12/2017 6.5 6.8
Please Help!

 

[steve the fish]

Plenty of ways to do this. Heres one. Lets say your data in columns A:C of Sheet1. In Sheet2 cell A1 place:

=TODAY()-14

in A2:

=A1+1

in B1:

=VLOOKUP(A1,Sheet1!$A:$C,2,1)

in C1:

=VLOOKUP(A1,Sheet1!$A:$C,3,1)

This way has a couple of caveats. Your data is in order ie the dates are earliest to latest. Also there is only one result per date in your data.

 

[Analystbycuriosity]

=TODAY()-14

My data excludes weekends