Re: $$Excel-Macros$$ query for a solution

2011-01-29 Thread Ms-Exl-Learner .
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 abl

Re: $$Excel-Macros$$ query for a solution

2011-01-27 Thread ankur
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

Re: $$Excel-Macros$$ query for a solution

2011-01-27 Thread TG T
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 da