Good Morning All,

I am currently in the process of creating a manifest system and am looking for some assistance with coding.

I have two sheets I use (DELIVERY MANIFEST & COLLECTION MANIFEST)

What I would like to happen is, when I input information onto one fo these sheets and click the Macro button to send an email, that selected information gets automatically transferred onto the first blank row on another sheet (TRANSPORT SHEET)

The data I want to transfer is:


Manifest----LIST
J8 A1
F6 B1
G19 C1
J6 D1
H11 E1
C9:19 F1
E9:19 G1
J15 H1


For Column J on the spreadsheet I require the name of whoever input the data ( name of excel user)

If somebody could assist me i'd be greatly appreciated, even if it's just starting me off....


COLLECTION MANIFEST.xlsm
DELIVERY MANIFEST.xlsm
TRANSPORT LIST.xlsm

Many thanks in advance.
Ross