Data to be copied from file Fantastic Furniture Sample Data to Fantastic Furniture Freight Import as follows:
1. Columns A (Client) and B (Site Location) to be filled with “Fantastic Furniture – Home Delivery”
2. Copy Column M (Receipt) to Column C (Order Number) and Column D (Customer No)
3. Column E (Customer Name) to be filled with date + ascending number (e.g. “110221-1”, “110221-2”, “110221-3”)
4. Copy Column F (Address) to Column F (Address), Column G (Suburb) to Column G (Suburb) and Column H (Postcode) to Column H (Postcode)
5. Copy Column O (Phone) to Column I (Phone Number)
6. Copy Column S (Comments) to Column J (Comments)
7. Columns K and L to be left blank
8. Copy Column N (Qty Items) to Column M (Items)
9. Copy Column J (Weight) to Column N (Weight)
10. Copy Column I (CBMPC) to Column O (CBM)
11. Columns P, Q, R and S to be left blank
12. Copy Column A (FF Unique Ref) to Column T (FF Unique Ref)
13. Copy Column K (CBM-Weight) to Column U (CBM-Weight)
14. Copy Column L (AX Delivery Advice) to Column V (AX Delivery Advice)
15. Copy Column T (Has Deliver Store) to Column W (Has Deliver Store)
16. Columns X, Y, Z and AA to be left blank
Although I am relatively new to Freelancer, I have 25 years experience developing Excel, Access and VBA Scripts for a major computer corporation. I have reviewed your project and would like to recommend a solution that could meet your needs. I will provide a quality product at a reasonable price. I will be happy to provide a sample for your review prior to starting the project. Just message me through Freelancer and we will see what we can work out.
Hi. I have rich experience in excel VBA and power query.
I can send you a sample of my work before getting awarded.
Please chat for more detail.
Johnny
Hello,
I've read your proposal and have great interest in working with you, I currently work as a data analyst on the resource planning department using advance excel on a daily basis, I have 3 year experience on this position and will deliver the job in a timely manner