Forum Discussion
Repeat Rows
Hello All - I have an scenario where I collate list of Employees for specific month and count based on each manager for a specific month. In order to extrapolate the data for the full financial year, I copy paste the data below the previous month data and another tab in excel calculates based the count for soecific month and specific manager. Scope of data per month if 1300 rows.
Is there a way we can repeat the data automatically or via formula so that I dont have to copy paste data for each month.
Is there a way we can repeat the data automatically or via formula so that I dont have to copy paste data for each month.
That seems an odd question. If the data are the same, such that they can just be repeated automatically, why both copying ever?! Just multiply the data for one month by 12 to get a year's worth; 3 to get a quarter, and so forth.
That said, I'm guessing we're not understanding each other. There may be a way to do whatever it is you're trying to do, but could you give a more clear description of what you're talking about. Ideally, you would post a copy of the workbook (without real names) on OneDrive or GoogleDrive, with a link here that grants access.
