Re: $$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread Vishwanath
Dear Ashishi, Sending the the sample file. thanks in advance for your cooperation. On 8 October 2012 21:55, ashish koul wrote: > can you attach the sample sheet > > > On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath wrote: > >> Dear wabs, >> Thanks for your reply. >> The amount should be allocated eq

Re: $$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread ashish koul
can you attach the sample sheet On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath wrote: > Dear wabs, > Thanks for your reply. > The amount should be allocated equally over the period of time. > For example, for expenditure B, total expenditure of Rs. 1 has been > distributed prorata basis. It wor

Re: $$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread Vishwanath
Dear wabs, Thanks for your reply. The amount should be allocated equally over the period of time. For example, for expenditure B, total expenditure of Rs. 1 has been distributed prorata basis. It works out 3667 for 22 days in April, 5000 for may(full month) and 1333 for for June . The period

$$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread Don Guillett
Always show a before/after and the logic On Thursday, October 4, 2012 1:33:22 AM UTC-5, Vishwanath wrote: > > Need help > > > Dear All, > I need your help in automatic some calculations in spreadsheet. > > I have data in excel as below; > It consists of 2 parts. first part is Expense stateme

$$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread Vabz
Hi Can you explain base for allocation, theer is no standard method that can be assumed on the basisi if data given by you. Rgds//Vabs On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote: > > Need help > > > Dear All, > I need your help in automatic some calculations in s