Good day to everyone!
I believe, there are smart and kind people out there who share their expertise in excel programming or the likes. I have a very manual "litic" job everyday that eats my big time at work. Pls help me hasten and improve my work and performance.
I find it hard to compare Sheet 2 against Sheet 3, in such a way that what ever input i have in Sheet 3 (only 1 column) will result to being HIGHLIGHTED ( in any color) in Sheet2. But provided that only 8 characters be pasted in Sheet 3.I mean,No matter how long is the partnumber or partname i copied from other workbook or worksheet, if i paste it in Sheet 3 (on the 1 column) "only the first 8 character must be displayed" And this 8 characters that were in Sheet3, if it can be found in Sheet2 from any cell, the cell would be highlighted.
Then, it would be nice if i have button in Sheet1 to click like named as "compare", in such a way that when i click the "compare"button, the comparison will took place.
I am so sorry with my English. I try my hardest to make you understand. Hope you could help me solve my problem.
thank you so much. Have a nice day!
Mariposa
btw, i attach sample file. Pls. see.
Bookmarks