I am still trying to learn this and am working on a project and if I could get this into a macro it would save me alot of time.
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
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