Change Data in a table basis the date selected

[Sriram Iyengar]

Hi All,

I am working on an internal report that needs to be sent on a daily basis.

I have an excel file with two sheets

1) Sheet 1 Titled as Consolidated
2) Sheet 2 Titled as Daily

The Day wise data is updated on the consolidated sheet and contains Month wise data from Apr to Oct & day wise data for Nov across all metrics. The sheet titled as Daily, has the snapshot for the previous day which is sent via email.

Primary Ask: I want to automate Sheet 2 (Daily) to pull data from Sheet I once I enter the date.
Additional Good to have feature: If I can embed a button to copy & paste the data into an email (Outlook)

 

[Sriram Iyengar]

Can anyone help a bro ?

 

[vletm]

Do Your Consolidated-sheet layout have to just as it is now?
... do You modify it manually again 1st of December?
Above means that - it should have different layout
How do You feed/update data there?

 

[Sriram Iyengar]

I got this fixed via Xlookup. Thank you everyone

 

[vletm]

I see ...
Anyway, check Your YTD and MTD results (columns AO & AP) . Yours results are ... wild.
I tested something as I tried to ask and offer with Consolidated (2)-sheet.
... mine YTD & MTD results are top of sheet.
PS This sample is not ready at all.