Hi,
I'm creating a register for transport costs, and need an add info macro.
In this excel sheet i have a input area with the following details:
Date (cellname: s_date)
Sender (cellname: s_sender)
Recipient (cellname: s_recipient)
Type of goods (cellname: s_type_of_goods)
Type of transport (cellname: s_type_of_transport)
Ref (cellname: s_ref)
Opr (cellname: s_opr)
Forwarder (cellname: s_forwarder)
Tendered (cellname: s_tendered)
DG (cellname: s_dg)
dims and weight are found in cell:
parcel_1_length // parcel_2_length // parcel_3_length // parcel_4_length // parcel_5_length // parcel_6_length
parcel_1_width // parcel_2_width // parcel_3_width // parcel_4_width // parcel_5_width // parcel_6_width
parcel_1_height // parcel_2_height // parcel_3_height // parcel_4_height // parcel_5_height // parcel_6_height
parcel_1_weight // parcel_2_weight // parcel_3_weight // parcel_4_weight // parcel_5_weight // parcel_6_weight
I need to create a macro which takes these details, and places them on the first available row from row 11 or below.
following information belongs to following collum in the register:
a:Uniqe ID (format needed is 1/17-1 (month/year-number)
b:date
c:sender
d:recipient
e:type of goods
f:total_fcw (freight chargeable weight)
g:weight
h:forwarder
i:tendered (Y/N)
j:type of transport
k:dg (Y/N)
l:ref
m:opr
Bookmarks