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 fo...
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.