Fill down variable data

[71Neb]

I have a column that includes two letters, EZ, then the date, followed by rack number, for labels.
These decrement down the column as such:
EZ12151736, EZ12151735, EZ12151734....
When the last two numbers reach 01, it starts over with the previous day:
EZ12141736, EZ12141735....
I have this done for a two week period.
I would like to be able to change the length of the sheet to a variable amount of days.
I can't do one week without either changing the entire sheet manually or throwing away 250 labels.
Is there a way to automate this, by entering a start date, and possibly number of racks per day?

 

[Joe4]

I have this that works, but I need the Sheet1 A10 to be whatever is in Sheet2 C9. A2 won't change.

Sub FillDown()


Worksheets("Sheet1").Range("A2:A10").FillDown


End Sub

You mean like this?

Dim endRow as Long
endRow = Sheets("Sheet2").Range("C9")
[COLOR=#333333]Worksheets("Sheet1").Range("A2:[/COLOR][COLOR=#0000ff]A" & endRow[/COLOR][COLOR=#333333]).FillDown[/COLOR]

 

[71Neb]

Again, Genius.
Thank you
Thank you

 

[Joe4]

You are welcome.