I am trying to write a macro that will select rows from "sheet 1" and
depending on the value in column "BU" copy the row to sheets 2, 3 or 4
given the following condition.

If the cell in column BU = 1 then copy to sheet 2; I
f the cell in column BU = 2 then copy to sheet 3;
If the cell in column BU = 3 then copy to sheet 4

The copied rows need to be inserted in sheets 2,3 & 4 from row 13 down
to account for the header.

The detrmining number in BU is set using and IF statement in excel, I
assume this shouldn't have any impact on the macro code required?

I have tried a number of differnt approaches but no joy as yet which
is no doubt not helped by my lack of experience with VB.

Any help would be gratefully appreciated as would any comments on the
code suggested to help understand the procedures.

Many Thanks

Jamie