This project has the aim to create a macro or similar code to produce a manifest for drivers in an excel spreadsheet format that can be shared or downloaded. I am open to suggestions, if this process can be done in any other way, but a macro of sort seems the quickest and most cost effective. Here are some of the steps we need to complete:
1. Down load the manifest.
2. Manipulate the columns in the spreadsheet, about 3 steps here.
3. Export the date to [url removed, login to view] to do some optimization , 3 steps here.
4. Import data back into a spreadsheet and share so that it can be printed at other locations.
5. This is what csv file will look like.
TW1 2PF D Standard Parcel j Jones Flat 4 1 Cambridge Park 0208 555 555 LIND 86-006-78-59241717-1
TW1 2QB D Standard Parcel j Jones 11 Old House Gardens Park Road 209 555 555 LIND 86-006-78-59241727-0
TW1 4HX D Standard Parcel j Jones 15 GROVE AVENUE 210 555 555 TRU2 POD 86-006-78-40526988-1
TW10 7AA D Standard Parcel j Jones Petersham Farm Stables 211 555 555 LAKE 86-006-78-79366207-3
6. This is what the final excel spreadsheet looks like (see uploaded file)
Total collections: TICK=CUSTOMER SIGNED,P=PORCH, M=MISSING, C/F=CARRY FORWARD,
Total deliveries: ENTER HOUSE NUMBER IF DELIVERING TO NEIGHBOUR.
Total for the day: ALWAYS RECORD BARCODE FOR UNMANIFESTED PARCELS AND COLLECTIONS.
Order In kt130uz Delivered Collected Code Print Sign
1 TW12 2HW 15 PERCY ROAD MRS j Jones 077763660459 RED 86-006-78-15235923-1 Standard Parcel D/S
2 TW12 2QA 4 Priory Close John slater 0791 478586 KIDC POD 86-006-78-37755838-9 Standard Parcel D
10 freelancers are bidding on average $150 for this job
Hey there. I have experience in creating macros for the office suite and I have also experience manipulating csv files and creating custom sheets in excel, mostly for statistics.
I have excellent skills in web development, PHP and sql etc. I have done project Data base engineering and have score of 3.6 CGPA out 4. I do my work with full dedication and also in given time. Thank you