Excel: Auto Splitting of Data to 2 Worksheets

Hi, I am creating a workbook for other users to manage money receipting. Problem is receipted data it is processed by two different areas & the data needs to be split & sent respectivly. I am trying to make it simple for the areas receiving the monies as this is not their primary job I am dealing with numerous staff with different skill sets & knowledge. I have tried to attach my workbook & images but I am not having any luck. Basically I want the receivers to complete sheet one only of the Cash Book. I am now trying to work a macro / formula / whatever to auto popuate the further two sheets isolating the Cash/Cheque & EFTPOS payments, which in turn can be just printed & sent off to their respective areas. Can anyone offer assistance or a solution. Much appreciated.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of October 31, 2013.

For more resources for Microsoft Excel