data seperated by hypen - and comma , to be written in rows existing below eg 5X6-1,4,

[vijayvijay]

Dear members,

Please help me solve the above problem using "macro" or "array formulae".

Problem - data seperated by hypen - and comma , to be written in
rows existing below (should not insert rows but place data in already
existing rows )


eg 1

5X6-1,4,5,6,9,X7-23,56,67,6X30 in cell C34

ANSWER should be -

5X6-1 in cell c34
5X6-4 in cell c35
5X6-5 in cell C36
5X6-6 in cell C37
5X6-9 in cell C38
5X7-23 in cell C39
5X7-56 in cell C40
5X7-67 in cell C41
6X30 in cell C42

eg 2

7X6-33,36 in cell C55

Answer should be
7X6-33 in cell C55
7X6-36 in cell C56


A) similar data is saved in the rows one below other seperated by suitable rows
The macro should consider 3000 rows containg any data seperated by - and ,

B) data in the cell may contain 1 to 3 hypen and at most 15 commas

C) letter 'X' will be always present in data