Sriram Iyengar
New Member
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)
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)