I have a WORKSHEET in Excel for my petty cash.  in this sheet are number of columns relating to details of the expense, DATE, inv number, amount etc.  there is also an account allocation CODE column.
I want to be ABLE to copy and PASTE a relevant row from this worksheet to another worksheet in same workbook, of any row that lists the same allocation code.


Example: First worksheet - Petty cash
Date       Inv             Alloc                                       Amount
28 Jul      1234           1   (staff welfare)                    250.00
30 jul         A36           3  (cleaning)                          324.00
30 Jul        xyz            1                                              25.00

2nd Worksheet - 1 - Staff Welfare
28 Jul      1234           1   (staff welfare)                    250.00
30 Jul        xyz            1                                              25.00

3rd Worksheet - 2 - Repairs

4th worksheet - 3 - Cleaning
30 jul         A36           3  (cleaning)                          324.00

Is there a way I can set this up to automatically copy a complete row to the correct worksheet when it detects the allocation code in column C