Hi,
I need to work out a spreadsheet to list several invoices. The invoices will be split across different business areas but depending on the type of invoice the percentage split will be different. I would like to enter the invoice amount, select the invoice type from a drop down and then have the amounts automatically fill in to each relevant business area. I can do the drop down, and basic calculations but I do not really have any idea how to get the invoice to split correctly.
Thanks for any help!
Bookmarks