I have a sheet in which i have to note what is the person has to pay daily. But if some day his cash flow becomes negative then he has to pay a fine in decending order on the previous days also. kindly guide how to write the vba.
I have a sheet in which i have to note what is the person has to pay daily. But if some day his cash flow becomes negative then he has to pay a fine in decending order on the previous days also. kindly guide how to write the vba.
There doesn't appear to be any rhyme or reason for the application of a "fine" in your data. You will need to explain in greater detail what amount is applied and when it is to be applied?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Dear, the file is resubmited. There is a range with 'cashflows' the moment cash flows get negative, asset allocation has to be tapered down prior to the cell in cash flow become negative in column adjecent to cash flows. Now the problem is if the cash flow is negative in the second row it clears the headings also. kindly suggest.
Add a line of code to rewrite the header.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'