Worksheet I need cells copied from is called County and data starts on row 3 and in column D there will be either a 1,2,3 or 4. If the row has a 1 I need to copy the corresponding cell data in a:c and insert in worksheet scale row 45, if 2 copy/insert in row 27, if 3 copy/insert in row 20 and if 4 copy/insert in row 6.

Any help would be greatly appreciated