Hi All,
Good Evening.
I require your help for creating Macro.
Below is the base file and the highlighted row 1 are the headers.
I want to prepare a another file based on the base file if data is available under headers S A/C, A A/C, G A/C and W A/C.
<TBODY>
</TBODY>
Output File
In Output file the headers will be fixed... we need to populate the data from Base file under the correct heading if data is available in defined columns of Base file (mentioned above)
<TBODY>
</TBODY>
Hope I am able to explain you the required.
Please feel free to ask me if you need any clarification....
Regards
Shan
Good Evening.
I require your help for creating Macro.
Below is the base file and the highlighted row 1 are the headers.
I want to prepare a another file based on the base file if data is available under headers S A/C, A A/C, G A/C and W A/C.
CODE1 | PRO 1 | CODE Details | Completed Date | SSD | SED | TSD | TED | FB | Row No | S A/C | A A/C | G A/C | W A/C |
KW1 | KWI1 | ABCD | 6-Aug-14 | 6-Aug-14 | 10-Aug-14 | 7-Aug-14 | 30-Sep-14 | M1 | KRPW | - | - | - | - |
KW1 | KWI1 | ABCD | 6-Aug-14 | 6-Aug-14 | 10-Aug-14 | 7-Aug-14 | 30-Sep-14 | E1 | KRPW | - | - | - | - |
HD1 | HDS11 | Tejas Corp | 24-Aug-14 | 25-Aug-14 | 30-Jun-14 | 25-Aug-14 | 30-Jun-14 | FBR3 | GMJP | GMJ01 | 34661 | CHA | - |
HD1 | HDS11 | Tejas Corp | 24-Aug-14 | 25-Aug-14 | 30-Jun-14 | 25-Aug-14 | 30-Jun-14 | FBR4 | GMJP | GMJ01 | 34661 | CHA | - |
HD1 | HDS11 | Tejas Corp | 24-Aug-14 | 25-Aug-14 | 30-Jun-14 | 25-Aug-14 | 30-Jun-14 | FBR5 | GMJP | GMJ01 | 34661 | CHA | - |
HD1 | HDS11 | Tejas Corp | 24-Aug-14 | 25-Aug-14 | 30-Jun-14 | 25-Aug-14 | 30-Jun-14 | FBR6 | GMJP | GMJ01 | 34661 | CHA | - |
HD1 | HDS11 | Tejas Corp | 24-Aug-14 | 25-Aug-14 | 30-Jun-14 | 25-Aug-14 | 30-Jun-14 | FBR7 | GMJP | GMJ01 | 34661 | CHA | - |
<TBODY>
</TBODY>
Output File
In Output file the headers will be fixed... we need to populate the data from Base file under the correct heading if data is available in defined columns of Base file (mentioned above)
Sr no | Code Details | code 1 | G A/C | A A/C | W A/C | S A/C | FBR1 | FBR2 | FBR3 | FBR4 | FBR5 | FBR6 | FBR7 | M1 | E1 | SSD | SED | TSD | TED | PRO1 | Completed date |
1 | Tejas Corp | KW1 | CHA | 34661 | - | GMJ01 | - | - | GMJP1 | GMJP2 | GMJP3 | GMJP4 | GMJP5 | - | - | 25-Aug-14 | 30-Jun-14 | 25-Aug-14 | 30-Jun-14 | HDS11 | 24-Aug-14 |
<TBODY>
</TBODY>
Hope I am able to explain you the required.
Please feel free to ask me if you need any clarification....
Regards
Shan