Macro for the adding new row with the data

[ashwin_bist]

Hi All,

Every weekend i need to send forcasting reporting to the higher management.
Exported data will have 2 or 3 order number in 1 opportunity, but for the report i need all the order number in different row.
I need a macro or something which can help me doing this faster.

I am attaching the example sheet, raw data containes the export that i will get from CRm and "Required Formate" contains the formate that i need after i run the marco.

Regards
Ashwin

[Shijesh Kumar]

Here is the macros to achieve the same.

Note...
1. Find and replace ", " ( comma and space in Order# with "/").
2. if sheet3 is not there then insert sheet3.

let me know if the code is working or not

Please Login or Register  to view this content.