edd1.0
Member
Registered: 17th Sep 08
Location: kettering
User status: Offline
|
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
|
Gaz
Member
Registered: 24th Aug 03
Location: Widnes, Cheshire
User status: Offline
|
could you create a column to have a 0 or 1 value to show if they have paid and calculate this into your second spreadsheet?
|
edd1.0
Member
Registered: 17th Sep 08
Location: kettering
User status: Offline
|
I dont think so ? , someone i spoke to said it may be to do with ifferior equations ? , im trying to research them now but its confusing :/ ,
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
You'd normally only use IFERROR if you have the potential for something like a divide by zero when you want to show a nice message and not the error.
Not really clear on the problem currently to see what else you might need to do.
If you need to work out whether they've paid all that it outstanding, a simple SUM() on the end of a row would do that.
|
edd1.0
Member
Registered: 17th Sep 08
Location: kettering
User status: Offline
|
we have to design a cash budget and profit and loss for a company to use , but it has to be idiot proof so all the information which isn't on the data entry sheet cant be adjusted by the user. There is customers who pay in both cash and credit ( cash paid instantly the credit can take up to X amounts of months to pay.) , an option needs to be put in the data entry for how long it will take X customer to their credit. Its all set up so the percentages of cash and credit can be changed and everything will change accordingly. But it somehow needs to be set up so the time it takes to pay can be included on the data entry as the other sheets have to be locked. ( cash budget and profit and loss) . We havn't been taught anything like this in class and won't fail the assignment if we can't do it but for the sake of a few hours research it will be worth it to get the extra marks.
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
Are you using a VBA form for the data entry?
|
edd1.0
Member
Registered: 17th Sep 08
Location: kettering
User status: Offline
|
Without sounding stupid I dont know what a vba form is? Its just a standard excel spreadsheet atm
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
It's hard to offer a solution without seeing the workbook, take any sensitive data out, stick it in Dropbox and post the link...
|
Gaz
Member
Registered: 24th Aug 03
Location: Widnes, Cheshire
User status: Offline
|
quote:
Originally posted by A2H GO
It's hard to offer a solution without seeing the workbook, take any sensitive data out, stick it in Dropbox and post the link...
This.
|
