Need Very Very Urgent Help for Macro

[Executive Vishal]

Hi,

i read your site,

can u pls tell me the solution of this issue.

example is given below:-

Coloum A B C

1 (RAW) 01.04.08 PE, LO, RS FOLLOW UP

2 (RAW) 02.04.08 HR, LR, MEET HIM

3 (RAW) 03.04.08 PE, JH, HR NEXT DAY VIST

4 (RAW) 08.08.08 PH, MN, KL MEET HIM

5 (RAW) 05.08.08 PE, LO, RS NEXT DAY

I NEED CHANGE THIS SHEET IN TO THIS

Coloum A

1 (RAW) 01.04.08, S.: PE, LO, RS, FAP.: FOLLOW UP

2 (RAW) 02.04.08, S.: HR, LR, FAP.: MEET HIM

3 (RAW) 03.04.08, S.: PE, JH, HR, FAP.: NEXT DAY VIST

4 (RAW) 08.08.08, S.: PH, MN, KL, FAP.: MEET HIM

5 (RAW) 05.08.08, S.: PE, LO, RS, FAP.: NEXT DAY

I NEED A MACRO FOR THIS WORK

CAN U PLS TELL ME HOW CAN I DO this

THANKS/REGARDS,


Vishal

 

[Stormseed]

ExecutiveVishal, did you check if that code runs on your computer and does that resolve the problem you were experiencing ?

 

[Executive Vishal]

i m using this formula bro. which u give me,

<table class="MsoTableGrid" style="border: medium none ; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A4&" "&D4&", "&E4&", S.: "&F4&", Order.: "&G4&", FAP.: "&H4<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A5&" "&D5&", "&E5&", S.: "&F5&", Order.: "&G5&", FAP.: "&H5<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A6&" "&D6&", "&E6&", S.: "&F6&", Order.: "&G6&", FAP.: "&H6
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A7&" "&D7&", "&E7&", S.: "&F7&", Order.: "&G7&", FAP.: "&H7<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A8&" "&D8&", "&E8&", S.: "&F8&", Order.: "&G8&", FAP.: "&H8<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A9&" "&D9&", "&E9&", S.: "&F9&", Order.: "&G9&", FAP.: "&H9<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A10&" "&D10&", "&E10&", S.: "&F10&", Order.: "&G10&", FAP.: "&H10<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A11&" "&D11&", "&E11&", S.: "&F11&", Order.: "&G11&", FAP.: "&H11<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A12&" "&D12&", "&E12&", S.: "&F12&", Order.: "&G12&", FAP.: "&H12<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 6.15in;" valign="top" width="590"> =A13&" "&D13&", "&E13&", S.: "&F13&", Order.: "&G13&", FAP.: "&H13<o></o>
</td> </tr> </tbody></table>
its very very very good for me

thanks again bhai

i cant explain, how much i m happy

 

[Stormseed]

its very very very good for me thanks again bhai i cant explain, how much i m happy

ok I do understand your *brotherly* (bhai) feelings.

You did not tell us if the code executed properly on your Excel file and did it help you to resolve the issue that you were experiencing ? Did you run the code which Mike posted above, on your Excel worksheet ?

 

[Executive Vishal]

ok I do understand your *brotherly* (bhai) feelings.

You did not tell us if the code executed properly on your Excel file and did it help you to resolve the issue that you were experiencing ? Did you run the code which Mike posted above, on your Excel worksheet ?

yes, i posted it on excel worksheet like this:-

raw 4 =A4&" "&D4&", "&E4&", S.: "&F4&", Order.: "&G4&", FAP.: "&H4
raw 5 =A5&" "&D5&", "&E5&", S.: "&F5&", Order.: "&G5&", FAP.: "&H5
raw 6 =A6&" "&D6&", "&E6&", S.: "&F6&", Order.: "&G6&", FAP.: "&H6
raw 7 =A7&" "&D7&", "&E7&", S.: "&F7&", Order.: "&G7&", FAP.: "&H7

i m posting this code (formula) on last coloums (where my matter finish, which matter that i need to compose)

after doing this, i will get, which i need