In Progress

2 x simple Excel Macros

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: Excel

See more: new excel, master excel, simple macro, simple excel, simple csv, macro excel, macro + excel, import excel, export from excel, excel master file with macros, Excel Formulas, excel based, create excel worksheet, c# import excel, c import excel, export stock data, create workbook master workbook, excel macro csv, excel required csv, import data macro excel, export button, excel file order form, workbook csv, import excel data form, import data form excel

About the Employer:
( 6 reviews ) Auckland, New Zealand

Project ID: #956356

Awarded to:

agihcam

Please check PMB for more details.

$80 NZD in 1 day
(39 Reviews)
5.2

4 freelancers are bidding on average $68 for this job

binaryromel

Lets start. Please check PM. Thanks.

$75 NZD in 2 days
(34 Reviews)
4.9
cycada

I can do it for you

$50 NZD in 2 days
(0 Reviews)
0.0
kkh0806

Please check inbox!

$65 NZD in 2 days
(0 Reviews)
0.0