Finance help ( possible dynamic ranges)

**golfedrocks** · 12-09-2012, 05:10 PM

hello i am currently doing a cash budget spread sheet for my uni work , all of it ive done fine. It has to be done in a way where you have one page for data entry and then the other sheets will alter themselves with no data.

The problem i am stuck with is some of the customers take a few months to pay , so the information goes a few months down the line , which to do it for a set 2 months is easy. But we have to do it in a way that we can alter how many months they take to pay and it will adjust all the information ?

does anyone know how i can get around this problem ?

thanks

**gwsampso** · 12-09-2012, 07:39 PM

it sounds like your problem may require dynamic ranges in your data entry sheet.

But without seeing something im unsure

could you please post an example

**FDibbins** · 12-09-2012, 08:42 PM

golfedrocks, welcome to the forum.

however, please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertese, and will only open those threads. also, searching for "help" will not turn up too many results that will benifit you, sorry

**golfedrocks** · 12-10-2012, 06:17 PM

Im unsure of how to re name my thread ? , as soon as i find out how to i will , thanks for the suggestion

an example would be sales from march: £2000 , april £3000 , may £2500 june £4000 , july £1000. Customers take X amount of months to pay. The (X) needs to be changeable to a number so it will alter the information of which month the figures will be shown. This also has to mix in with with other formulas from the box as the sales is a formula of information already received.

Hope this is a good enough example

**FDibbins** · 12-10-2012, 06:52 PM

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, what your expected outcome is, and how you arrived at that

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**golfedrocks** · 12-10-2012, 06:59 PM

I think this has worked not to sure

on the data entry i have made a box which says months taken to pay , this needs to be a number value which will there for alter the data in the cash budget depending on how long they take to pay ?

i hope this is clear ? any more information please let me know

thanks