Closed

MS Excel Automation & Macros

This project was awarded to bossumd for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
12
Project Description

SEE ATTACHED FILE.

ALL THE 9 RED FIELDS ON THE "AVERY 5163 SHIP LABEL TEMPLATE" TAB SHOULD BE AUTOMATICALLY PICKED UP FROM "PACKING LIST WITH CARTON INFO" TAB.

PO BOX#: ON"AVERY 5163 SHIP LABEL TEMPLATE" TAB - SHOULD MATCH THE PACKING LIST FOR PRODUCT DESCRIPTION AND BOX NUMBER AND THE NUMBERS MUST RUN SEQUENTIALLY ON EVERY LABEL. SO, ON THE NEXT LABEL IT WILL BE BOX 2 AND SO ON.

FOR THIS EXAMPLE, THE LABEL TEMPLATE TAB SHOULD AUTO GENERATE 20 LABELS BASED ON DATA FROM THE PACKING LIST TAB.

1 SHEET HOLDS 10 LABELS, SO IN THIS EXAMPLE, WE WILL HAVE 2 SHEETS TO PRINT.

LABEL SHEETS CANNOT BE ON SEPARATE TABS, THEY MUST BE CONTINUOUS ON THE SAME SHEET/TAB.

THE FOLLOWING TAB 3 - FINAL OUTPUT SHOWS THE FINAL RESULTS WE ARE LOOKING FOR AFTER AUTOMATION BASED ON THE DETAILS OF THE PACKING LIST.

PREFERENCE WILL BE FOR THE FINAL OUTPUT FOR LABELS TAB BE AUTOMATED AS THE PACKING LIST IS BEING MADE WITHOUT ANY USER INTERVENTION.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online