Hello,
I am looking to produce a list as follows
Week 1
Week 1
Week 1
Week 1
Week 1
Week 1
Week 1
Week 2
Week 2
Week 2
Week 2
Week 2
Week 2
Week 2
etc
Basically the week number is listed 7 times before incrementing by 1.The whole process would begin on row 2
This continues on until the column previous does does not have any data in it ( a blank cell)
How would i do this? Looking to do this byVBA
Help much appreciated.
Kind Regards,
Bookmarks