Hi
i'm completely new to VBA programming and i've been trying to find a
solution to my problem in historical posts but have come unstuck. The
problem is this.

I have a workbook containing 4 sheets. column "A" on sheet 2 feeds
information into column "K" on sheet 1
I need a macro that moves all the rows from sheet 1 when the entry in
column "K" is equal to "Despatched" to the next available row in sheet
3. (leaving no empty rows in the spreadsheet).
Then all rows of data in sheet 2 that contain "despatched" in column
"A" need moving to sheet 4 to the next available row (again leaving no
empty rows in the spreadsheet).

I know this requires using worksheet change event, and i've tried using
autofilter/cut/paste/delete macros but my VBA isn't good enough.

i hope someone can help

thankyou