I have production planning Sheet (Week.xlsx)
In column A I have starting week of the production, in column B I have end week of production.
What I would like is to get is macro, that will display all the weeks between "start week" and "end week".
I have macro that displays all the numbers between stated figures (eg. 32-36, it inputs 32, 33, 34, 35, 36), but if my start week is 52 which is the last week in the year I would like macro to display eg. 52-3, 52, 1, 2, 3.
Please see attached file.
Many thanks.
Bookmarks