Auto Arrange cell values to a specific range with VBA

B

bootdat

New Member
Joined
Nov 22, 2018
Messages
44
This mission pretty seems impossible for me but I'd just wanna ask anyways if there might be some sorta solution.

I'm to copy and paste cell values into another sheet or another workbook sheet. but the manual process seems very time consuming
So was wondering if there could be an easy way out with a macro

so this is the problem

CSP TRAIN EXCEL EXTRACT (1).xls
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
4Flight No./Date: DL 0156 27-Feb-2021Arr. Date:27-Feb-2021Point of Loading:JFK
5NATURE
6AIR WAYBILLPIECESWEIGHTOF GOODSORG-DSTUSE BY OWNER/OPERATOR
7006-36987204160.0CONSOLIDATIONJFK-ACC
8PMC93468DL160.0
9Shipper:OMA LOGISTICS ROOM212 SWISSPORT KIA ACCRA ACCRA GHANA Consignee:OMA LOGISTICS ROOM212 SWISSPORT KIA ACCRA ACCRA GHANA
10
11006-401555704/9646.5#CONSOLIDATIONJFK-ACC
12PMC93468DL4646.5
13Shipper:DHL PMB KIA ACCRA GHANA Consignee:DHL PMB KIA ACCRA GHANA
14
15006-402470569147.0CATERING MATERIALJFK-ACC
16PMC93468DL9147.0
17Shipper:DELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
18
19006-40248563234.0CATERING MATERIALJFK-ACC
20PMC93468DL234.0
21Shipper:DELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
22
23006-4024858548.0CATERING MATERIALJFK-ACC
24PMC93468DL48.0
25Shipper:DELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
26
27006-40248596#180.0CATERING MATERIALJFK-ACC
28PMC93468DL#180.0
29Shipper:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
30
31006-40248611#30.0CATERING MATERIALSJFK-ACC
32PMC93468DL#30.0
33Shipper:DELTA SHIPPING COMPANY LTD. PMB KIA ACCRA GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
34
35006-6938338115.0CONSOLIDATIONJFK-ACC
36PMC93468DL15.0
37Shipper:Tartines and chocolate Jam street 1 London T456FG UNITED KINGDOM Consignee:DELTA SHIPPING COMPANY LTD. PMB KIA ACCRA GHANA
38
39006-697673908197.0CLOTHING,HOUSEHOLD IJFK-ACC
40DQL15964DL8197.0
41Shipper:SHIPPER DUBAI ROAD 3 DUBAI UNITED ARAB EMIRATES Consignee:Cereal investments company Ghana Ld Sanyo rd 1000 Tema GHANA
42
Sheet1



I'm to copy the details in the cells above and make it as the range below

EXCEL EXTRACT FROM GALAXY (1).xls
ABCDEFGHIJKLMNOPQ
1Company CodeFlight DateFlight NoAircraft RegFirst OriginPrefixMasterHouseNature of GoodsGoods DescConsigneeShipperPkt DeptDept wgtPkt ArrivPkt WgtRemarks
2DL27/02/2021DL156N832MHJFK00636987204WZ714458TOOLS AND PARTSSANDVIK MINING AND CONSTRUCTION GHANA LTD160160
3DL27/02/2021DL156N832MHJFK006401555705MOU813DRILLING MACHINE EQUNEWMONT GOLDEN RIDGE LTD91457.44646.5
4DL27/02/2021DL156N832MHJFK00640247056CATERING MATERIALSERVAIR GHANA COMPANY LTD91479147
5DL27/02/2021DL156N832MHJFK00640248563CATERING MATERIALSERVAIR GHANA COMPANY LTD234234
6DL27/02/2021DL156N832MHJFK00640248585CATERING MATERIALSERVAIR GHANA COMPANY LTD4848
7DL27/02/2021DL156N832MHJFK00640248596CATERING MATERIALSERVAIR GHANA COMPANY LTD1018010180
8DL27/02/2021DL156N832MHJFK00640248611CATERING MATERIALDELTA AIRLINE10301030
9DL27/02/2021DL156N832MHJFK00669383381CONSOLIDATIONARAMEX COMPANY1515
10DL27/02/2021DL156N832MHJFK00669767390CLOTHINGHAMIS MOHAMED ABDALLAH81978197
GC NET MANIFEST


i'd like to know if there is any way out to do this with a macro.
Thank you
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
It looks like the second bit that you posted is not the desired result, but an example from other data.
If you could post the desired result from the example data that you gave, that would help us figure how to help with this.
 
Upvote 0
mikerickson said:
It looks like the second bit that you posted is not the desired result, but an example from other data.
If you could post the desired result from the example data that you gave, that would help us figure how to help with this.
Click to expand...
I think this data below will do


CSP TRAIN EXCEL EXTRACT (1).xls
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
4Flight No./Date: DL 0156 27-Feb-2021Arr. Date:27-Feb-2021Point of Loading:JFK
5NATURE
6AIR WAYBILLColumn1Column2PIECESColumn3Column4WEIGHTColumn5Column6Column7OF GOODSColumn8Column9Column10Column11ORG-DSTColumn12Column13Column14USE BY OWNER/OPERATORColumn15Column16Column17Column18Column19Column20Column21Column22Column23Column24Column25Column26
7006-36987204160.0CONSOLIDATIONJFK-ACC
8160.0
9Shipper:OMA LOGISTICS ROOM212 SWISSPORT KIA ACCRA ACCRA GHANA Consignee:OMA LOGISTICS ROOM212 SWISSPORT KIA ACCRA ACCRA GHANA
10
11006-401555704/9646.51454.7CONSOLIDATIONJFK-ACC
124646.5
13Shipper:DHL PMB KIA ACCRA GHANA Consignee:DHL PMB KIA ACCRA GHANA
14
15006-402470569147.0CATERING MATERIALJFK-ACC
169147.0
17Shipper:DELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
18
19006-40248563234.0CATERING MATERIALJFK-ACC
20234.0
21Shipper:DELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
22
23006-4024858548.0CATERING MATERIALJFK-ACC
2448.0
25Shipper:DELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
26
27006-4024859610180.0CATERING MATERIALJFK-ACC
2810180.0
29Shipper:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
30
31006-402486111030.0CATERING MATERIALSJFK-ACC
321030.0
33Shipper:DELTA SHIPPING COMPANY LTD. PMB KIA ACCRA GHANA Consignee:SERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA
34
35006-6938338115.0CONSOLIDATIONJFK-ACC
3615.0
37Shipper:Tartines and chocolate Jam street 1 London T456FG UNITED KINGDOM Consignee:DELTA SHIPPING COMPANY LTD. PMB KIA ACCRA GHANA
38
39006-697673908197.0CLOTHING,HOUSEHOLD IJFK-ACC
408197.0
41Shipper:SHIPPER DUBAI ROAD 3 DUBAI UNITED ARAB EMIRATES Consignee:Cereal investments company Ghana Ld Sanyo rd 1000 Tema GHANA
42
Sheet1



AND


EXCEL EXTRACT FROM GALAXY (1).xls
CDEFGHIJKLMNOPQ
1Flight NoAircraft RegFirst OriginPrefixMasterHouseNature of GoodsGoods DescConsigneeShipperPkt DeptDept wgtPkt ArrivPkt WgtRemarks
2DL156N832MHJFK00636987204CONSOLIDATIONSANDVIK MINING AND CONSTRUCTION GHANA LTDOMA LOGISTICS ROOM212 SWISSPORT KIA ACCRA ACCRA GHANA 160160
3DL156N832MHJFK00640155570CONSOLIDATIONNEWMONT GOLDEN RIDGE LTDDHL PMB KIA ACCRA GHANA 91457.44646.5
4DL156N832MHJFK00640247056CATERING MATERIALSERVAIR GHANA COMPANY LTDDELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA 91479147
5DL156N832MHJFK00640248563CATERING MATERIALSERVAIR GHANA COMPANY LTDDELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA 234234
6DL156N832MHJFK00640248585CATERING MATERIALSERVAIR GHANA COMPANY LTDDELTA AIR LINES SERVAIR GHANA LTD ACCRA ACC GHANA 4848
7DL156N832MHJFK00640248596CATERING MATERIALSERVAIR GHANA COMPANY LTDSERVAIR GHANA COMPANY LTD KOTOKA INTERNATIONAL AIRLINES ACC GHANA 1018010180
8DL156N832MHJFK00640248611CATERING MATERIALDELTA AIRLINEDELTA SHIPPING COMPANY LTD. PMB KIA ACCRA GHANA 10301030
9DL156N832MHJFK00669383381CONSOLIDATIONARAMEX COMPANYTartines and chocolate Jam street 1 London T456FG UNITED KINGDOM 1515
10DL156N832MHJFK00669767390CLOTHINGHAMIS MOHAMED ABDALLAHSHIPPER DUBAI ROAD 3 DUBAI UNITED ARAB EMIRATES 81978197
GC NET MANIFEST
 
Last edited:
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,215,130
Messages
6,123,220
Members
449,091
Latest member
jeremy_bp001

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top