Share
ReportHi all,
hope you are doing well!
I have a task. Every Monday, I need send out an email with excel file to 5 different plants, this file has 4 blank columns. the planner from these plants need to fill the 4 columns in that file. on Wednesday, I will receive 5 separate files from these 5 plants. then I need consolidate these 5 files into one(Normally I will use vlookup to gother these 5 files into the Monday version). after finishing the file version, I will send out this finished file to plants and demand team.
I would like to create a report in Power BI to have a better understanding of the data, I also would like to save the final version every week so that I can start have some historical data to review
Is there any way I can make this whole process automate? any other tools or platforms I need to use?
Thank you so much for your support and help!!!
All responses (
Answers (
6,643
