Closed

2 x simple Excel Macros

This project was awarded to agihcam for $80 NZD.

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

2 Simple Excel Macros

Must be designed for Excel 2007

See attached file and below

Macro 1 – Create Order Workbook from Master Worksheet
Step 1 – for any rows that are selected in column A create a new workbook “Order” as per the layout in worksheet “Order” when the “Create order Button” is hit.
Basically the Master Sheet is all Stock items – the selected ones will form the order that needs to be formatted as the Order Worksheet but as a separate doc.
Orange Columns are from Master Spreadsheet
Green Cells are formulas based on the data in the sheet
Step 2 – A Button to unselect all ticked boxes

Macro 2 – Create Import CSV File
Step 1 – When “Create Import” is hit export all rows to a new csv file called import with columns formatted as per the Import Worksheet.
Columns required are B through to AG of the master spreadsheet

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