Excel macro and Word mail merge to generate item specific order packing labels.
- or -
Post a project like this2252
$$$
- Posted:
- Proposals: 12
- Remote
- #1884078
- Awarded
Husband & Wife Team - Software Engineer, Public Relations Guru & Graphics Designer
Ypsilanti
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
3549514063936167548649512852701365006140641617882901866551194579119636792026418
Description
Experience Level: Expert
General information for the business: We sell plants online.
Description of excel work: We need an Excel macro and Word mail merge code to generate 14 per sheet (A4) labels where each label represents a separate order item with a new sheet generated at each change in order number.
We export customer order data from our eccomerce platform into an Excel spreadsheet. Most of the fields we require on the label are in separate columns except one which can be extracted via text to columns. The macro would need to generate a new row and copy where the quantity of items is greater than 1.
I have attached a mock-up of how we would like the labels to look.
The first label on the sheet would need to show the customer delivery instructions with subsequent labels showing the order item data. Some order can contain more than 14 items so would need to run onto another sheet.
Extra notes:
Description of excel work: We need an Excel macro and Word mail merge code to generate 14 per sheet (A4) labels where each label represents a separate order item with a new sheet generated at each change in order number.
We export customer order data from our eccomerce platform into an Excel spreadsheet. Most of the fields we require on the label are in separate columns except one which can be extracted via text to columns. The macro would need to generate a new row and copy where the quantity of items is greater than 1.
I have attached a mock-up of how we would like the labels to look.
The first label on the sheet would need to show the customer delivery instructions with subsequent labels showing the order item data. Some order can contain more than 14 items so would need to run onto another sheet.
Extra notes:
James T.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
50%
Last project
22 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies