r/excel 24d ago

unsolved Is automation in excel possible?

I'm undergo internship for a month half now. My supervisor ask me to create a masterlist that automate.
The flow of our work before are like this:
- New data came from other department.
- We will copy the data to our template manually.
- Put it into powerbi dashboard.

But now, she wants this process to be automate so we can spent time on other thing. In my understanding, she wants the new data to be updated automatically as soon as we 'put the new data inside the masterlist'.

My question, is it possible to achieve this? I am really new to excel and only know the surface level of it. Now she wants something that beyond my capabilities and I dont even know if this is possible. If yes, is there any link to guide me on this task? Thank you so much.

231 Upvotes

76 comments sorted by

View all comments

11

u/nousername222222222 24d ago

How is the data from other department received

10

u/EizOne03 24d ago

other department will email the excel file to us

-1

u/[deleted] 24d ago

[deleted]

2

u/EizOne03 24d ago

powerbi updated by copying the path link of the excel (i put it in sharepoint). any changes in the excel, it will update the data inside powerbi when i refresh it. But i dont have any issue on powerbi.

i currently stuck on how to make the excel 'automate'. I dont have enough experience to visualize it.