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 X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34 ANSWER should be - X6-1 in cell c34 X6-4 in cell c35 X6-5 in cell C36 X6-6 in cell C37 X6-9 in cell C38 X7-23 in cell C39 X7-56 in cell C40 X7-67 in cell C41 X30 in cell C42 eg 2 X6-33,36 in cell C55 Answer should be X6-33 in cell C55 X6-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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
