2 x simple Excel Macros

IN PROGRESS
Bids
4
Avg Bid (NZD)
$68
Project Budget (NZD)
$30 - $250

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

Skills required:
Excel
Additional Files: MASTER+STOCKSHEET.xlsm
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 80
in 1 days
$ 75
in 2 days
Hire kkh0806
$ 65
in 2 days
Hire cycada
$ 50
in 2 days