Hi, I have a workbook for various users with very limited excel skills. The workbook records incoming payments received by that area (Cash Book Tab) & depending as to whether they are a cash/chq transaction or an eftpos transaction I need them to automatically split into two different sheets so that they can be sent off to two different areas to be processed. I am currently working in Excel 2007. Can anybody offer assistance with this with a formula / macro / etc. If so it would be very much appreciated. I have attached the workbook so that you can see what I am trying to do.