Cells duplcating by x times ..

**mattoxford** · 09-19-2011, 02:15 PM

Hi,

Need some urgent help

I have some work that is pending, which I am beign judged on

I have a list in one excel sheet
For example

D0001
D0002
D1266
D7770

I have 1900 entires, and not in running order (for example 9,10,12 ) , so I cant drag the cells down

I need it to be like
D0001
D0001
D0001
D0001
D0001
D1266
D1266
D1266
D1266
D1266
D1266

in a different excel sheet

Please help :D

**Andrew-R** · 09-19-2011, 02:22 PM

Hello, and welcome to the forum - unfortunately before anybody you can help you need to read the forum rules and comply with rule #1, which prohibits generic "please help" titles. Give your thread a more descriptive title and somebody will be happy to assist.

**mattoxford** · 09-19-2011, 02:33 PM

hope thats better ...
sorry for not reading the rules

.

Time is against me on this one

**MaczaQ** · 09-19-2011, 02:38 PM

my idea is - copy manualy your all data from source sheet to other sheet and then sort it with key in column with Your indexes - You don't need VBA for that.

Best Regards

**mattoxford** · 09-19-2011, 02:42 PM

confused

**watersev** · 09-19-2011, 03:00 PM

hi, mattoxford, check attachment, run code "test"

The code does standard sorting available at two mouse-clicks

**mattoxford** · 09-19-2011, 03:12 PM

I have attached how it should work

Sheet 1 shows the values

D3084

Sheet 2 I need it duplcating x 6 then move onto the next cell

That make more sense