Create a list from numbers in several sheets (Problem)

[phillipe124]

Hi,

I am wanting to create a list in a spreadsheet based on information which has a number tagged to it, example below:

23 RAD 380.0/390.0
24 DIA 53.0

So I want to take 23 and the information and then 24 with the information it comes with and place it on another sheet - fairly easy.

The trouble is some sheets where I get the information from will have the numbers laid out in the style as described below.

23/24 RAD 380/390
1+2+3+4+5 DIA 95.0

How do I get the macro to recognise that 1, 2, 3, 4 and 5 are separate numbers as are 23 and 24?

I don't want to add them as 23/24 I want to add them as separate numbers on my new sheet......

Any help if possible, appreciated.

Thanks

Phil

[StephenR]

Phil - I suggest you attach a workbook with more sample data and illustration of desired results.

[phillipe124]

In the sheet "Control Plan" I want to take the characteristic numbers, plus the other information in the cells next to them and dump then in another workbook.

The trouble is, numbers 1,2,3,4,5 etc need to be separate, not all together as one. How can I separate them? I.E. recognise them as single numbers and not a whole bunch of numbers together as they are typed.

[StephenR]

Can you do the illustration of results bit too as it's not clear what is going where? Should be straightforward with a macro.

[phillipe124]

Very rough example of results attached.

Thanks...

[StephenR]

I'm afraid I didn't really follow that, but see if this starts you off. It puts results on "Sheet1":

Please Login or Register  to view this content.

[phillipe124]

Hi,

That works a treat on separating the numbers with a "/" between them, however when it comes to the sheet which has 1+2+3+4+5 etc it isn't recognising the numbers at all. It just bypasses them.

Is there any way to separate these numbers too, i.e. make another variable as well as "/" for defining if numbers are there and needs to be recognised and separated?

Thanks again.

[StephenR]

Are those the only two possible separators? Pre-empting, but if so:

Please Login or Register  to view this content.

[phillipe124]

Thanks for your help, that works just great now.

All I have to do now is work out how it does what it is doing!

Phil

[snb]

Another approach

Please Login or Register  to view this content.

[watersev]

another option, run code "test"