Hi Team I need help either in excel formula or macro for the product code need to splits in different sheets.
1. Data Sheet contains All product codes 2. Goods No.1 & 2 contain selected goods code item. 3. Other Goods sheet blank I need what ever the product available in Data Sheet it should highlight as "YES" in Goods No. 1 and 2 Sheets. Goods No. 1 & 2 Sheet "NA" product don't want to change YES becaseu they are no more available. It should retain as NA only Remaining all other goods should which are not listed in Goods No.1 & 2 Sheet should go to Other Goods Tab sheet with Goods Code. It would be great help if any help out on this. Thanks Puttu -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
