Incrementing number based number range

Hi Dear forum members,

I have data like Table A and want to split data as mentioned in Table B. The numbers between the range should increment and copy to next row along with County, Price.

I have huge data like this . I am able to split data by semicolon but unable to increment numbers.

Kindly provide macro for this scenario. Thanks in Advance

Table A
County Range Number Price

USA 632295-632298; 632340-632348; 632395-632399 2.5
India 6346580-6346585; 6346590-6346598;6346599-6346620 3.5
Sweden 6346621-6346630; 6346633-6346639; 6346641-6346649 2.8


Table B

County Range Number Price
USA 632295 205
USA 632296 205
USA 632297 205
USA 632298 205
USA 632340 205
USA 632341 205
USA 632342 205
USA 632343 205
USA 632344 205
USA 632345 205
USA 632346 205
USA 632347 205
USA 632348 205
USA 632395 205
USA 632396 205
USA 632397 205
USA 632398 205
USA 632399 205
India 6346580 3.5
India 6346581 3.5
India 6346582 3.5
India 6346583 3.5
India 6346584 3.5
India 6346585 3.5

Thanks Glenn,

I have attached sample data sheet to this thread. I have huge data like "632295-632298" this number range. The range should increment by one and should add in next cell.

Please see the sample test data that is attached. The data in Table A should display as Table B in test data sheet.


Thanks
Rams

Try

Please Login or Register  to view this content.

Thank you Jindon,

I tried your code and it's working as I expected.

Thanks a lot.

Rams

You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.