Hey Manish, Hope this might help you....
Cheers, Manoj Kumar On Mon, Jan 17, 2011 at 10:43 AM, Manish <pansari.man...@gmail.com> wrote: > is it possible or not??? :( > any help pls..... > > > - > Manish Pansari > > On Jan 14, 11:21�am, Manish <pansari.man...@gmail.com> wrote: > > Dear Group Friends, > > > > I have two work sheet. Sheet1 contain bill number in column B, and > > sheet2 contain bill number and PRA No in column A and column B. > > > > My problem is, I want to concatenate the PRA No. with "," for every > > unique bill Number. > > > > e.g. Sheet1 date are as Under: > > > > Bill No. > > FDN/01 > > FDN/02 > > FDN/03 > > FDN/04 > > > > Sheet2 data: > > > > Bill No. � � � �PRA No. > > FDN/01 �M-01 > > FDN/03 �M-02 > > FDN/02 �M-03 > > FDN/04 �M-04 > > FDN/01 �M-05 > > FDN/02 �M-06 > > FDN/01 �M-07 > > FDN/04 �M-08 > > FDN/02 �M-09 > > FDN/03 �M-10 > > > > Result required in Sheet1 > > > > Bill No. � � � �PRA Nos. > > FDN/01 �M-01, M-05, M-07 > > FDN/02 �M-03, M-06, M-09 > > FDN/03 �M-02, M-10 > > FDN/04 �M-04, M-08 > > > > I know the concatenate formula. but for that i have to apply it > > manually. > > > > Please assist me, how can i make it automatic. When I entered new PRA > > No. in sheet2, Sheet1 PRA Nos. get automatically update. > > > > Thanks for your regular help and suggestion. > > > > Regds,ManishPansari > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
GG - Concatenate All Values_Manoj.xlsm
Description: Binary data
