I have multiple excel sheets that I need to delete the 1st 2 rows of. I have done a Macro where it does the job for a single excel sheet when I manually open the required excel sheet. However, I'd like to automate it so that I can just have all the 1st 2 rows in all the required excel sheets deleted in one go.
Points to note -
1) all excel sheets are split into two folders - for example 100 in one folder and another 100 in the 2nd
2) Made a silly mistake and tried the desktop recorder in power automate and deleted two rows in two excels but when i clicked on run in power automate it again deleted two more rows off the already deleted excel sheets ( should have seen that coming).
Really appreciate your help here guys 🙂 thank you in advance 🙂

Report
All responses (
Answers (