Macro for making a separate row for two or more clubbed item

Hi All,

I need to do a vlookup with the order booked report and opportunity created report in CRM.
For this i need to put every order no in different line, i am attaching sheet with a small example. I get some where close to 3k record like this and takes almost 2 days to make the report.

Is any one have any formula whic will do lookup to the two or more order no clubed together or NEED A MACRO WHICH SEPERATE THE ORDER # CLUBBED TOGETHER IN SEPERATE LINE.

Regards
Ashwin

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

Thank you so so so much you have made my life very eazy....thank you...

One more thing some of the opportunities will have "," or "-" so if i replace "/" by them it will work,

Hi

Not sure if that was a question or a statement. If a question, then yes you can change the separator in the SPLIT command with the required character and it will work OK. Alternatively, you can replace the separator in the data to a "/" and the code(s) will not have to be changed.

rylo