Hello All – I have a business scenario. Each month, I get a EE list file from HR. I have to format that data based on my excel file and paste the data in stipulated columns. Since the file is used for forecast  budget, I copy and  paste the same data from the table for the balance number of months in the financial year. If the above exercise is for 1st month of FY, then I would paste this 12 times against each month to derive the budgets. 

Is there a way we can do a Office Scripts or formula that will simplify this. I would like to format the data once and based on the balance # of months I update / enter, I would like to see that many # of records. 

Any help if this can be done via Power Automate or Office scripts, Pls guide. 

​Hello All – I have a business scenario. Each month, I get a EE list file from HR. I have to format that data based on my excel file and paste the data in stipulated columns. Since the file is used for forecast  budget, I copy and  paste the same data from the table for the balance number of months in the financial year. If the above exercise is for 1st month of FY, then I would paste this 12 times against each month to derive the budgets.  Is there a way we can do a Office Scripts or formula that will simplify this. I would like to format the data once and based on the balance # of months I update / enter, I would like to see that many # of records.  Any help if this can be done via Power Automate or Office scripts, Pls guide.   Read More

​