Ok another one to keep you guys occupied lol. Im tryin g to select mulitple cells on the one sheet and transfer them to another, this code is a basic code just to show you what cell numbers i am trying to copy.
Sheets("Entry Data").Range("B12, L12, B16, B19, L19, B23, L23, B27").Copy Sheets("All Tray Data").Range("A2:A9")
Sheets("Entry Data").Range("B12, L12, B16, B19, L19, B23, L23, B27").Copy Sheets("All Tray Data").Range("A2:A9")