I have a requirement where i will take excel from previous month and do certain actions and paste the data in the existing excel for current month. The same will be used for upcoming months as well.
I don’t want to delete the sheet, as i require column names static.
I need to delete the data and paste the new data, sometimes it has 100 rows and the formula will be in 101row, sometimes the row differs same as the formula row.
Kindly help how to resolve this.