Hi
Given the information you have provided you would be better doing this in excel. That way you can have hidden formulae that picks up values as and when a user enters a particular value.
If you can provide a sample of your data and layout I will put together a sample in Excel for you to consider.
Tony