Add blank row in excel spreadsheet based on day of week

maryfrecker01 When you want to add an empty row based on some criteria, you're talking Visual Basis programming which is NOT "easy for dummies". You're also talking about "massive spreadsheets" and importing data via copy/paste. Such a manual process is prone to error is you're not careful and comfortable using Excel. It sounds more like a task for "Get&Transform" a.k.a. Power Query. But, that's NOT "easy for dummies" either.

Rather than inserting an empty row, could you live with highlighting Mondays (or changes in week numbers) in your data set (sorted by date)? That could be done with Conditional Formatting, relatively easy, provided your data is clean and consistent.

Can you upload a sample of your data (deleted any private and confidential information), spanning a couple of weeks and indicating how you want to separate/highlight the weekly data? Then, it may become clear how your data looks like with regard to structure, formatting, sorting, etc. No guarantees for an "easy" solution, though.