Hi Lads,
I've the work to do an I'm stuck. I've to create myshape box in every cell in column A if cell in column D contain the word "CIF". The macro I have is working fine with Intersect but I need to copy the cells from Sheet2 to Sheet1 and have this box automatically when paste. Any help? File as attached.
Rregards,
Rufles
Bookmarks