blackie42
10-05-2007, 01:56 AM
My task:
Create a user form with some text boxes (customer, account, date) which is used to populate a number of sheets (col1,2, & 3)depending on the following.
Another text box with money amount which automatically calulates the percentage to be applied to a particular sheet. Percentage split will be the same however much the money is thats entered
e.g.
?7000 split 40% sheet 1 (4th col) -> ?2800
20% sheet 2 ( ") -> ?1400
10% sheet 3 (") -> ?700
15% sheet 4 (") -> ?1050
15% sheet 5 (") -> ?1050
I want to set command button to update sheets at next available row (on each sheet) with correct percentages.
Any help appreciated
thanks
Jon
Create a user form with some text boxes (customer, account, date) which is used to populate a number of sheets (col1,2, & 3)depending on the following.
Another text box with money amount which automatically calulates the percentage to be applied to a particular sheet. Percentage split will be the same however much the money is thats entered
e.g.
?7000 split 40% sheet 1 (4th col) -> ?2800
20% sheet 2 ( ") -> ?1400
10% sheet 3 (") -> ?700
15% sheet 4 (") -> ?1050
15% sheet 5 (") -> ?1050
I want to set command button to update sheets at next available row (on each sheet) with correct percentages.
Any help appreciated
thanks
Jon