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

SUBMIT DATE

LAST UPDATED

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