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