Auto Splitting of Data to 2 Worksheets

[Bellablu]

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.

 

[bschwartz]

My pleasure. Glad it's working for you.

 

[Hercules1946]

Hello
Heres my solution which Ive had on the back burner waiting to hear from you at the cross-post:

Automatic copying of data from one sheet to two sheets

Its probably too late for you now, but seeing that Ive completed it, I thought I would post it anyway and it may help someone else.

If your interested there are some screen shots and code here:

http://www.mrexcel.com/forum/excel-questions/739885-problem-array-formula-user-defined-function.html


regards

Hercules