Dear friends in my excel document have two sheets..it's sheet1 & sheet2..my requirement is...
01.new column need to inset first sheet on column "P".
02.first sheet column "B" data need to match with second sheet column "D"..if any data is matched ,then that second sheet matched row column "F" value need to copy to first sheet match row column "P" & that row should highlight in yellow.
03.today date need to add to "P7" cell...
pls make macro this.it's a big help for me.thanks in advance......
01.new column need to inset first sheet on column "P".
02.first sheet column "B" data need to match with second sheet column "D"..if any data is matched ,then that second sheet matched row column "F" value need to copy to first sheet match row column "P" & that row should highlight in yellow.
03.today date need to add to "P7" cell...
pls make macro this.it's a big help for me.thanks in advance......
