Need Macro to repeat number set

[Latha Mani]

Hi friends

I have many set of numbers in column A and Coulmn B each set separated by space.I need to repeat each set to n number of times.Please help

Thank you

[Kaper]

You have not specified what is n. and if it changes for each set. I assumed it is constant and that always there is a blank row between sets. Also assumed that nothing in the worksheet is affected by inserting extra rows.T

ry this:

Please Login or Register  to view this content.

[Latha Mani]

Hi kaper

The n differs for each set and also no of items in each set may vary but all the sets are separated by spaces.No problem in inserting many number of rows.

[Latha Mani]

I dont want spaces while repeating the number sets.

Thanks.

[Latha Mani]

Hi

Do u have any doubt on my query?

[jindon]

My guess.

Please Login or Register  to view this content.

[Latha Mani]

Hi jindon

I shows error

[Latha Mani]

Sorry i mean code diplays error

[jindon]

Are you on Windows XP?

Otherwise, should work.

[Latha Mani]

s..windows XP

[jindon]

The try this

Please Login or Register  to view this content.

[Latha Mani]

Thank you..it works

[Latha Mani]

Hi

Can i change number of times for each number set..

Thanks

[jindon]

How do you allocate the numbers?

[Latha Mani]

How do you allocate the numbers?

After every set which is separated by spaces i need a automation to ask "how many" for each

[jindon]

Please Login or Register  to view this content.

[Latha Mani]

Superb..thanks