Dear friend in my document first 2 rows has document header.my requirements is...
01.if column "E" any values is there then same row column "H" value should delete.if column "E" empty then column "H" value no need to delete.
02.column "C" cell value "AMBATTUR B" then same row column "D" first 3 characters need to remove..
ex- column "D" value "AS-45896" to "45898"
03.column "E & H" all empty cells need to fill with "OK"
04.if column "M" cell characters more than 6 then last extra characters need to remove.
ex - column "M" value "456897A-B" to "456897"
if any body cam make macro for this.it's very big help for me.thanks.....
Bookmarks