Delete content from Excel table

(0) Share

Report

Posted on by nandayellow

Hi,

I'm trying to automate to delete the table´s content every Friday.

We order food and every Friday late afternoon we would like to delete our orders from the currently week, so on Monday the excel sheet would be clear for the next food order.

So, basically we have Monday to Friday columns and the food options are in the rows named from Number 1 to Number 10.

The plan is to be able to select B2:F43 and delete it.
Help? 🙂

Thanks in advance

Categories:

Connector development

I have the same question (0)

All responses (3)

Answers (0)

Sort by

nandayellow 10 on at

Like (0)

Report
Copy link

Link copied!

Hi, sorry Im very very new...
How do I get to put the vbscript there? I try find in action "run" could not find anything...and in the excel options nothing either. I upload a file, so you can see what I see.
Thank you 🙂

Was this reply helpful? Yes No
nandayellow 10 on at

Like (0)

Report
Copy link

Link copied!

No, Im using Power apps, cloud flows 🙂

Was this reply helpful? Yes No
nandayellow 10 on at

Like (0)

Report
Copy link

Link copied!

Hi, I've done it in the Power Automate Desktop, thank you.
Now is just missing to set the recurrence, I'd like to have automatic done on Fridays at 4 pm.
Could you help me with that too? 🙂 Thanks

Was this reply helpful? Yes No