Forum Discussion
Auto repeat the set of data multiple number of times
Hello!!
I have a set of 200 rows of data in excel, As I am making their sales from Jan'22 to May'22, I have to repeat the set of data every day. I am currently manually copying the data so I have to copy the set of data for 150 times. Is there a way using VBA or formula either in excel or in MS Access to copy the set multiple times as per our requirement?
Example: I have below table of data, that I need to be copy/pasted from 01/01/2022 to 03/31/2022. Kindly help me.
| S.No | EMP ID | Employee Name | Date |
| 1 | 123456 | Suresh | 1/1/2022 |
| 2 | 123458 | Mahesh | 1/1/2022 |
| 3 | 124875 | Nag | 1/1/2022 |
| 4 | 125485 | King | 1/1/2022 |
| 5 | 12485 | Solomon | 1/1/2022 |
| 6 | 124 | Jain | 1/1/2022 |
| 7 | 156465 | Jaya | 1/1/2022 |
I have to ask why? just enter the DATA and then report what you need. So in your example you have Employee_Table (columns A:C) then a Data_Table that has EMP ID, Date, value(s)
Then you can use a pivot table, power query, or cell functions like FILTER() to create your "report" or whatever you need.
That all said, you could use this for the date column:
=D2+1+QUOTIENT(SEQUENCE(89,1,0),ROWS(D2:D8))
then highlight the other cells and double click the small dot/box in the bottom right corner
