Clear contents daily

[Kthtmllr88]

I have a workbook with 10 sheets. I need to clear contents in the same range of cells (A10:I41) on each sheet everyday before the start of business. I tried to record a Macro button but because my team can only use the web version of 365 Im needing to clear the contents based on the date change (daily). Any ideas? It seems simple enough but I'm stumped.

 

[alansidman]

deleted. VBA is not an option for Web based version.

However, you may want to look at this link

Automate your tasks with the Automate tab—now in Excel for Windows and Mac

The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel..

techcommunity.microsoft.com