$$Excel-Macros$$ Receivable Aging

2012-01-12 Thread Muhammad Arslan
Dear Experts I have Balances of 5 years and needs to segregate them to there age, More than 5 Years, More than 4Years, More than 3 Years, More than 2 Years, More Than 1 Years, Less than 1 Year. Can You help me out how to distribute them. They should be segregate by LIFO(Last in first out) basis.

Re: $$Excel-Macros$$ Receivable Aging

2012-01-12 Thread PrIyAnKa
Kindly provide inoput and output data format It will be more helpful to solve your quarry On Thu, Jan 12, 2012 at 5:21 PM, Muhammad Arslan arslanacca...@gmail.comwrote: Dear Experts I have Balances of 5 years and needs to segregate them to there age, More than 5 Years, More than 4Years, More

Re: $$Excel-Macros$$ Receivable Aging

2012-01-12 Thread Muhammad Arslan
Ok For your reference see attached file On Thu, Jan 12, 2012 at 4:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Kindly provide inoput and output data format It will be more helpful to solve your quarry On Thu, Jan 12, 2012 at 5:21 PM, Muhammad Arslan arslanacca...@gmail.comwrote: Dear

Re: $$Excel-Macros$$ Receivable Aging

2012-01-12 Thread PrIyAnKa
still not getting what u want in output, Kindly give one example of it in excel On Thu, Jan 12, 2012 at 5:42 PM, Muhammad Arslan arslanacca...@gmail.comwrote: Ok For your reference see attached file On Thu, Jan 12, 2012 at 4:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Kindly provide

Re: $$Excel-Macros$$ Receivable Aging

2012-01-12 Thread Lakshman Prasad
me too From: PrIyAnKa p.dhamsa...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 12 January 2012 5:51 PM Subject: Re: $$Excel-Macros$$ Receivable Aging still not getting what u want in output, Kindly give one example of it in excel On Thu, Jan

Re: $$Excel-Macros$$ Receivable Aging

2012-01-12 Thread Lakshman Prasad
Dear Aralan,   could u put the value which u want like.     From: Muhammad Arslan arslanacca...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 12 January 2012 5:42 PM Subject: Re: $$Excel-Macros$$ Receivable Aging Ok For your reference see attached

Re: $$Excel-Macros$$ Receivable Aging

2012-01-12 Thread Muhammad Arslan
Now i revised workbook, Colum A To Y contains and Cloumn AA To AF contains results which i wants (desired outcome). Results are manually calculated, which i want to be come through formula as number of customer are many, which manually needs a lot of time and work. -- FORUM RULES (986+ members