Re: $$Excel-Macros$$ query for a solution
Hi Thamu, I don't know what is the need for the comparison of 2003 & 2007 excel column versions since the query is not very much related to the 2003 column issue. I agree that the column will be the issue in Excel 2003 when the repetition of UNIQUE IDNO goes beyond 127 times then we could not able to get the data of Bill No & Amount in the continues columns because of the insufficient column space in Excel 2003, DescriptionRequired Columns Repetition Total Column UNIQUE IDNO -1 Column (Column A) 11 Bill No & Amount -2 Columns127 (127 x 2 = 254) 254 -- Total 255 -- I hope the above data has given you the clear picture and have a look in the solution provided to the OP for the query. I request all of you don't take my SUGGESTIONS as CRITICISM I would like to add some more points to your post and make your knowledge get enriched. At the same time anyone find any error or anything better than my solution and I request you to keep me informed, so that I can also get learned from you. Thanks! --- Ms.Exl.Learner --- On Thu, Jan 27, 2011 at 4:59 PM, TG T wrote: > Dear Ankur Pandey > > You cannot able to keep it in a single row If you have large amount of > data. Because Excel 2003 has only 256 columns and excel 2007 has only 16384 > columns. > > > Thanks & Regards > Thamu > > > > > On Thu, Jan 27, 2011 at 2:55 PM, ankur wrote: > >> hi excel experts >> i need one help >> i need data in format like this >> unique id all bill no. coloumn wise all their >> respective amount >> >> all bill no. and their respective amount shoul come in single row. >> >> the data is attached with this mail..sheet 2 has format needed also >> urgent need >> -- >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> -- >> >> -- >> 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 > -- --- Ms.Exl.Learner --- -- -- 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
Re: $$Excel-Macros$$ query for a solution
hi tamu thnks for quick reply i need only bill no. and amount in single row. for every unique id new row is needed. max 50 bill no. are their in respect to a single unique id. i hope now i m clear . On Thu, Jan 27, 2011 at 4:59 PM, TG T wrote: > Dear Ankur Pandey > > You cannot able to keep it in a single row If you have large amount of data. > Because Excel 2003 has only 256 columns and excel 2007 has only 16384 > columns. > > > Thanks & Regards > Thamu > > > > On Thu, Jan 27, 2011 at 2:55 PM, ankur wrote: >> >> hi excel experts >> i need one help >> i need data in format like this >> unique id all bill no. coloumn wise all their >> respective amount >> >> all bill no. and their respective amount shoul come in single row. >> >> the data is attached with this mail..sheet 2 has format needed also >> urgent need >> -- >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> -- >> >> -- >> 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 > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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
Re: $$Excel-Macros$$ query for a solution
Dear Ankur Pandey You cannot able to keep it in a single row If you have large amount of data. Because Excel 2003 has only 256 columns and excel 2007 has only 16384 columns. Thanks & Regards Thamu On Thu, Jan 27, 2011 at 2:55 PM, ankur wrote: > hi excel experts > i need one help > i need data in format like this > unique id all bill no. coloumn wise all their > respective amount > > all bill no. and their respective amount shoul come in single row. > > the data is attached with this mail..sheet 2 has format needed also > urgent need > -- > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > -- > > -- > 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