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

[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))

[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))