Forum Discussion
Repeat data multiple times
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.
Another possible solution could be Power Query with From Folder connector in which you keep monthly files. Once done, next times only to add another file to the folder and press Refresh All.
It's hard to be more concrete without knowledge of how exactly data is structured in input and output files.
- depending on what you need and how your worksheet/book is set up you could just have the 'template' have fomulas in each of the months that use the data from prior month so as you paste the data in to the month(s) and overwrite the default formulas in that month, the other months will automatically fill in/update.
MichelleRanMSFTMicrosoft
Hi SankhlaY1926 - thanks for reaching out! Have you tried using the Office Scripts recorder to record the manual formatting and copy/paste steps you do, and see if the generated script meets your needs? If not, could you share some more detail about the structure of the data you receive and the specific steps you want to automate? I can help suggest a solution from there.
