Auto generate duplicate Dates

P

pwill

Active Member
Joined
Nov 22, 2015
Messages
406
Hi can anyone help with a formula or macro?

I have Headers in cells "A1"(Date) "B1"(Seq) and "L1"(Next) Sheet1

"B2:B" has a sequence of numbers
"L2" auto generates dates
"L3" has either the letter A or B

I want to auto generate duplicate dates in ("A2:A") down to the last row in column B based on data in cells "L2" and "L3"

ie if "L2" generates the date 01/02/18 and "L3" has the letter A then column A would generate dates as follows


<colgroup><col style="width:48pt" width="64" span="15"> </colgroup><tbody>
[TD="class: xl65, width: 64, align: center"]
[/TD]
[TD="class: xl65, width: 64, align: center"] A [/TD]
[TD="class: xl65, width: 64, align: center"] B [/TD]
[TD="class: xl65, width: 64, align: center"] C [/TD]
[TD="class: xl65, width: 64, align: center"] D [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] F [/TD]
[TD="class: xl65, width: 64, align: center"] G [/TD]
[TD="class: xl65, width: 64, align: center"] H [/TD]
[TD="class: xl65, width: 64, align: center"] I [/TD]
[TD="class: xl65, width: 64, align: center"] J [/TD]
[TD="class: xl65, width: 64, align: center"] K [/TD]
[TD="class: xl65, width: 64, align: center"] L [/TD]
[TD="class: xl65, width: 64, align: center"] M [/TD]

[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"] Date [/TD]
[TD="class: xl65, align: center"] Seq [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] Next [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl66, align: center"] 01/02/18
[/TD]
[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl66, align: center"] 01/02/18
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl66, align: center"] 02/02/18
[/TD]
[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] A [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl66, align: center"] 02/02/18
[/TD]
[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl66, align: center"] 03/02/18
[/TD]
[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl66, align: center"] 03/02/18
[/TD]
[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl66, align: center"] 04/02/18
[/TD]
[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl66, align: center"] 04/02/18
[/TD]
[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl66, align: center"] 05/02/18
[/TD]
[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl66, align: center"] 05/02/18
[/TD]
[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl66, align: center"] 06/02/18
[/TD]
[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl66, align: center"] 06/02/18
[/TD]
[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 13 [/TD]
[TD="class: xl66, align: center"] 07/02/18
[/TD]
[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 14
[/TD]
[TD="class: xl66, align: center"] 07/02/18
 [/TD]
[TD="class: xl65, align: center"] 13
 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 15 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

</tbody>

ie if "L2" generates the date 01/02/18 and "L3" has the letter B then column A would generate dates as follows


<colgroup><col style="width:48pt" width="64" span="15"> </colgroup><tbody>
[TD="class: xl65, width: 64, align: center"]
[/TD]
[TD="class: xl65, width: 64, align: center"] A [/TD]
[TD="class: xl65, width: 64, align: center"] B [/TD]
[TD="class: xl65, width: 64, align: center"] C [/TD]
[TD="class: xl65, width: 64, align: center"] D [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] F [/TD]
[TD="class: xl65, width: 64, align: center"] G [/TD]
[TD="class: xl65, width: 64, align: center"] H [/TD]
[TD="class: xl65, width: 64, align: center"] I [/TD]
[TD="class: xl65, width: 64, align: center"] J [/TD]
[TD="class: xl65, width: 64, align: center"] K [/TD]
[TD="class: xl65, width: 64, align: center"] L [/TD]
[TD="class: xl65, width: 64, align: center"] M [/TD]

[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"] Date [/TD]
[TD="class: xl65, align: center"] Seq [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] Next [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl66, align: center"] 02/02/18
[/TD]
[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl66, align: center"] 01/02/18
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl66, align: center"] 02/02/18
[/TD]
[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] B [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl66, align: center"] 03/02/18
[/TD]
[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl66, align: center"] 03/02/18
[/TD]
[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl66, align: center"] 04/02/18
[/TD]
[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl66, align: center"] 04/02/18
[/TD]
[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl66, align: center"] 05/02/18
[/TD]
[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl66, align: center"] 05/02/18
[/TD]
[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl66, align: center"] 06/02/18
[/TD]
[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl66, align: center"] 06/02/18
[/TD]
[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl66, align: center"] 07/02/18
[/TD]
[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 13 [/TD]
[TD="class: xl66, align: center"] 07/02/18
[/TD]
[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 14 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 15 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

</tbody>

Any help would be apprieciated

Regards

pwill
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Just thought I would add that although they look very similar the difference between A and B is, if L3 has A the date in column A starts with the same date as L2 but only once as this would be added to data on sheet2 giving the duplicacate when added.

If L3 has B the dates start duplicating from the next day after the date in L2

hope that makes sense?

regards
 
Last edited:
Upvote 0
pwill said:
Hi can anyone help with a formula or macro?

I have Headers in cells "A1"(Date) "B1"(Seq) and "L1"(Next) Sheet1

"B2:B" has a sequence of numbers
"L2" auto generates dates
"L3" has either the letter A or B

I want to auto generate duplicate dates in ("A2:A") down to the last row in column B based on data in cells "L2" and "L3"

ie if "L2" generates the date 01/02/18 and "L3" has the letter A then column A would generate dates as follows


<tbody>
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, width: 64, align: center"] A [/TD]
[TD="class: xl65, width: 64, align: center"] B [/TD]
[TD="class: xl65, width: 64, align: center"] C [/TD]
[TD="class: xl65, width: 64, align: center"] D [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] F [/TD]
[TD="class: xl65, width: 64, align: center"] G [/TD]
[TD="class: xl65, width: 64, align: center"] H [/TD]
[TD="class: xl65, width: 64, align: center"] I [/TD]
[TD="class: xl65, width: 64, align: center"] J [/TD]
[TD="class: xl65, width: 64, align: center"] K [/TD]
[TD="class: xl65, width: 64, align: center"] L [/TD]
[TD="class: xl65, width: 64, align: center"] M [/TD]

[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"] Date [/TD]
[TD="class: xl65, align: center"] Seq [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] Next [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl66, align: center"] 01/02/18 [/TD]
[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl66, align: center"] 01/02/18 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl66, align: center"] 02/02/18 [/TD]
[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] A [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl66, align: center"] 02/02/18 [/TD]
[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl66, align: center"] 03/02/18 [/TD]
[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl66, align: center"] 03/02/18 [/TD]
[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl66, align: center"] 04/02/18 [/TD]
[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl66, align: center"] 04/02/18 [/TD]
[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl66, align: center"] 05/02/18 [/TD]
[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl66, align: center"] 05/02/18 [/TD]
[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl66, align: center"] 06/02/18 [/TD]
[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl66, align: center"] 06/02/18 [/TD]
[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 13 [/TD]
[TD="class: xl66, align: center"] 07/02/18 [/TD]
[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 14 [/TD]
[TD="class: xl66, align: center"] 07/02/18
 [/TD]
[TD="class: xl65, align: center"] 13
 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 15 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

</tbody>

ie if "L2" generates the date 01/02/18 and "L3" has the letter B then column A would generate dates as follows


<tbody>
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, width: 64, align: center"] A [/TD]
[TD="class: xl65, width: 64, align: center"] B [/TD]
[TD="class: xl65, width: 64, align: center"] C [/TD]
[TD="class: xl65, width: 64, align: center"] D [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] E [/TD]
[TD="class: xl65, width: 64, align: center"] F [/TD]
[TD="class: xl65, width: 64, align: center"] G [/TD]
[TD="class: xl65, width: 64, align: center"] H [/TD]
[TD="class: xl65, width: 64, align: center"] I [/TD]
[TD="class: xl65, width: 64, align: center"] J [/TD]
[TD="class: xl65, width: 64, align: center"] K [/TD]
[TD="class: xl65, width: 64, align: center"] L [/TD]
[TD="class: xl65, width: 64, align: center"] M [/TD]

[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"] Date [/TD]
[TD="class: xl65, align: center"] Seq [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] Next [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl66, align: center"] 02/02/18 [/TD]
[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl66, align: center"] 01/02/18 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl66, align: center"] 02/02/18 [/TD]
[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"] B [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl66, align: center"] 03/02/18 [/TD]
[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl66, align: center"] 03/02/18 [/TD]
[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl66, align: center"] 04/02/18 [/TD]
[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl66, align: center"] 04/02/18 [/TD]
[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl66, align: center"] 05/02/18 [/TD]
[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl66, align: center"] 05/02/18 [/TD]
[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl66, align: center"] 06/02/18 [/TD]
[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl66, align: center"] 06/02/18 [/TD]
[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl66, align: center"] 07/02/18 [/TD]
[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 13 [/TD]
[TD="class: xl66, align: center"] 07/02/18 [/TD]
[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 14 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 15 [/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

</tbody>

Any help would be apprieciated

Regards

pwill
Click to expand...



Help needed please, I have tried to write my own code if "L3" has the letter A but I don't know how to loop it through to the last row for me?

Code: 
Sub autodates()

Dim dt As Date
Dim dtA As String
Dim dtB As String
Dim lrow As Long

lrow = Cells(Rows.Count, "B").End(xlUp).Row

dt = Range("L2").Value
dtA = Range("L3").Value
dtB = Range("L3").Value

r = 1
r = r + 1
If dtA = "A" Then

Cells(r, "A").Value = dt
Cells(r + 1, "A").Value = dt + 1
Cells(r + 2, "A").Value = dt + 1
Cells(r + 3, "A").Value = dt + 2
Cells(r + 4, "A").Value = dt + 2
Cells(r + 5, "A").Value = dt + 3
Cells(r + 6, "A").Value = dt + 3

End If

End Sub

can anyone help?

regards

pwill
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Excel Pivot Table to see the number of "Lost Calls"
Replies
0
Views
64
Bernie Galve
B
R
  • Solved
Age Group Ranging by gender
Replies
2
Views
259
Raj1979
R
M
  • Solved
Formula Help.
Replies
3
Views
437
Fluff
Fluff
D
  • Question Question
Generating a list of Dates using nested array inside SEQUENCE function?
Replies
2
Views
257
Cubist
Cubist
Dazzawm
  • Solved
Macro To Find Latest Date To Corresponding Data In Column B And Add To Sheet 2
Replies
7
Views
341
Fuji
F

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top