Hi, I had a look at the file, i think there is some descrepancy between what data we have on sheet "Goods No1" and "Data Sheet", and similar is the case with Goods No.2 sheet and data sheet.
The codes that you want to check in Data Sheet are mostly 6 digits while codes in Goodsno1 sheet and Goodsno2 sheet are 4 digit. Or is there some similarity between the two???? Harpreet Gujral On Feb 26, 2:39 pm, Puttaswamy <puttu...@gmail.com> wrote: > Attached is the file, > > > > > > On Fri, Feb 26, 2010 at 2:59 PM, ankur <ankurpande...@gmail.com> wrote: > > hi puttu > > i think vlookup function will solve this....... > > u can attach file , it will be easy to provide you complete solution > > Have A Nice Time & Enjoy Life > > > Regards: > > CMA Ankur Pandey > > (Someone Different) > > > I'm not the best but i'm not like the rest~~ > > > On Fri, Feb 26, 2010 at 12:40 PM, Puttu <puttu...@gmail.com> wrote: > > > 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 athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://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 > > > -- > > > ---------------------------------------------------------------------------------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > Putta > > Test Sheet.xls > 2122KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
