Hi All,
I am creating a file on a monthly basis where the file has multiple sheets with a data sheet where the data being picked from data sheet with a Sumifs formula in each sheet.
Since im changing the data sheet each month with a new data available for the current month from the system.
Hence i need to copy paste the formula from for (ex) May month cell to June Month cell and replace the name in the formula from DATA_MAY to Data_June.
Can anyone help with a dynamic formula or a coding which will help me in picking up the formula automatically once i pasted the data in the sheet.
Excel Gurus please help me in automating this activity since this takes 4 hours on very month end (4 hours each day from 1st to 5th every month)
Enclosed the file for your reference.
Thanks in advance
Bookmarks