Hello Dear Try To concatenate using & operator.
If u want to concatenate a1 and b1 then try to use =a1&"/"&b1 Hope It Will Help Happy To Help :) Shyam On Fri, Mar 12, 2010 at 11:21 AM, Abhishek Jain <abhishek....@gmail.com>wrote: > Dear Ayush, > > Thanks. > > I thought of this but in Summary sheet I would have to manually select (or > type) the range of each sheet in Vlookup formula. Also I would have to make > a combined column in each sheet. Like I said there are around 66 sheets and > writing vlookup and make an additional column in each one of them is a bit > much to ask from an user. I am looking for something in which user have to > write a single vlookup (or whatever that works) which looks in all sheets, > matches the name, and returns the value of code no. > > Kind Regards, > > Abhishek > > On Fri, Mar 12, 2010 at 11:11 AM, ayush jain <jainayus...@gmail.com>wrote: > >> Hi Abhishek, >> >> Attached is the solution. Please have a look and let me know if any >> further help is required. >> >> I have made some changes like Header value change, added computed column >> to make this happen. >> >> Best regards, >> Ayush Jain >> >> >> On Fri, Mar 12, 2010 at 10:43 AM, Abhishek Jain >> <abhishek....@gmail.com>wrote: >> >>> >>> >>> ---------- Forwarded message ---------- >>> From: Abhishek Jain <abhishek....@gmail.com> >>> Date: Fri, Mar 12, 2010 at 10:42 AM >>> Subject: Fetching Data from All Sheets to Summary Sheet - Very Urgent >>> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> >>> >>> >>> Dear All, >>> >>> >>> I have a file where I have a Summary Sheet and several (50+) other >>> sheets. On Summary Sheet the Names of Projects are written in Colums and >>> code nos. are written in rows. Same project names are written in other >>> Sheets - Cloumn J. I want excel to look for the matching name in all sheets >>> and then return the value based on code no. >>> >>> Please have a look at the attached sample file. >>> >>> Kindly help. >>> >>> Best regards, >>> >>> >>> Abhishek Jain >>> >>> >> >> >> -- >> Best regards, >> Ayush Jain >> >> > -- > > ---------------------------------------------------------------------------------- > 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 > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- 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
