Hi,
I made a form for entering data.
I used "Power Automate", so all of the entered data is stored in an excel file.
I created some extra worksheets for filtering data, using a pivottable, pivotchart & slicers.
And hereby my problem.
My company wants a report on a daily base. I can do this manually by selecting the date using the slicer on the sheet "Dag Overzicht". I want this to go automatic.
And after that i want to mail the results to a mailing list. Also automatic. For example: everyday at 08:00 AM.
I hope that it is possible...
I made a form for entering data.
I used "Power Automate", so all of the entered data is stored in an excel file.
I created some extra worksheets for filtering data, using a pivottable, pivotchart & slicers.
And hereby my problem.
My company wants a report on a daily base. I can do this manually by selecting the date using the slicer on the sheet "Dag Overzicht". I want this to go automatic.
And after that i want to mail the results to a mailing list. Also automatic. For example: everyday at 08:00 AM.
I hope that it is possible...