dupplicate rows based on data in a column.

[taylor58285]

I have a spreadsheet of 18 columns and 1800 rows.
I deed to duplicate all columns of a given row based on the data in a specific (Tickets)column. Any help is appreciated.
Similar to AK216 January 2013
My example

A B C D E F G H I J K etc.
Tickets Name Date Item Qty
1 Joe 12/22/2013 Soup 24
3 Sue 12/29/2013 Shrimp 12
2 Jack 02/11/2014 Beans 36

Desired Result
1 Joe 12/22/2013 Soup 24
3 Sue 12/29/2013 Shrimp 12
3 Sue 12/29/2013 Shrimp 12 all columns to be duplicated
3 Sue 12/29/2013 Shrimp 12
2 Jack 02/11/2014 Beans 36
2 Jack 02/11/2014 Beans 36

 

[taylor58285]

hiker 95

I did a little experimenting and got it to wok Wednesday. I eliminated the line "Option Explicit" in your code. It now is working. Thanks for your help ad I am sorry I strung you along for so many days.

 

[hiker95]

taylor58285,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.