I have to automate an excel sheet. In the excel there is column and row called “Column1 and Total”. I need to copy the entire Total row to another sheet but the position will changed (In the Total Row) Eg : Today Total row is in (A67), Tomorrow Total row will change to (A68)
Here with attached excel sheet.
Can anyone please advise me how to do this.
Sample.xlsx (8.1 KB)