Dear Excel VBA Experts
I need some help to code Msgbox pop for following in my excel.
i have 3 columns, in first there is name of product, in second its sales target achievement for month and in third trgt achievement for quarter,
there are 150 product list, now i want a msg to pop up when sales trgt 1, trgt 2, trgt 3 is achieved for individual product once figures are entered in other sheet and formula calculates whether target is achieved or not in second column of current sheet for the month and similarly in 3rd column for quarterly sales.
Column 1 Column 2 Column 3
Product A TG1
Product B TG3
Product C TG2 TG1
my message should also tell the name of the product i.e product A monthly target 1 met.or product A quarterly target met.
Thanks in Advance.
Bookmarks