FORMAT SHEET - COPY ,DELETE FROM ONE SHEET TO ANOTHER SHEET

[call2shree]

Hi Experts

Need your help on attached sample sheet.

1. In RAW sheet data based on col a 12121 & 12122 copy .
In RAW sheet Col A contains 12121 need to copy and move to 12121 and same way to 12122
2. After copy 12121,col D & E concatenate in col. F
3.In sheet 12121 col I and J date format should be dd/mm/yy
4.In sheet 12121 col k contains "error" need to delete.
5. compare (vlookup) with sheet 12121 col F withsample sheet2col G paste in 12121 col g

If you provide the vba code ..its a great help...
any clarification please reply

Thanks in Advance
srinath

 

[Thangavel]

Hi Experts

Need your help on attached sample sheet.

1. In RAW sheet data based on col a 12121 & 12122 copy .
In RAW sheet Col A contains 12121 need to copy and move to 12121 and same way to 12122
2. After copy 12121,col D & E concatenate in col. F
3.In sheet 12121 col I and J date format should be dd/mm/yy
4.In sheet 12121 col k contains "error" need to delete.
5. compare (vlookup) with sheet 12121 col F withsample sheet2col G paste in 12121 col g

If you provide the vba code ..its a great help...
any clarification please reply

Thanks in Advance
srinath

The step 2 should perform in sheet "RAW" or in "12121"?

 

[call2shree]

It should be in RAW sheet