Excel 2007 : Need help to write a macro.

[raghuprabhu]

Attached a small spread sheet called doMacro.xlsx

there are 5 worksheets in it. I want to write a macro to change the data in worksheet 1 to look like in worksheet 5. There are 3 columns in each worksheet.

Class is a number
Pnumber is a 7 digit number
Snumber is a alpha numerical string

The following have to be done.

Strip the alphabet from the left of Snumber if there is one
Copy Pnumber to Snumber if it is empty for class 1 or 2 or 3
Add "O" to the left of Snumber if class is 2 or 3
Sort by Class
Change class 1 to A, 2 to R, 3 to N and 4 to C

Thanks in advance.
Cheers
Raghu Prabhu

[jraj1106]

Hi

Pls check the macro:

doMacro.xlsm

Regards...

[raghuprabhu]

SOLVED

Thanks a lot for the effort.