Macro to Automatically Update a sheet based on values in another sheet on daily basis

[sammy7187]

Hi,

I want the values of X and Y in sheet 1 to get updated on a daily basis based on the values entered in sheet 2 for the corresponding date.
I have attached a sample of the workbook. Im quite new to macros so help would be really appreciated. Thanks in advance.

[LalitPandey87]

In Cell B5 Paste below code :

=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),2)

In Cell C5 Paste below code:

=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),3)

[LalitPandey87]

You can try this also:

Paste below code in Cell B5 and drag it to Next cell (C5):

=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),MATCH(B$4,Sheet2!$B$4:$D$4,0))

[snb]

you can simply use a querytable.

[sammy7187]

Thank you so much! You saved my day

You can try this also:

Paste below code in Cell B5 and drag it to Next cell (C5):

=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),MATCH(B$4,Sheet2!$B$4:$D$4,0))