I gang

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

Færdigheder: Excel

Se mere: new excel, master excel, simple macro, simple excel, simple csv, macro excel, excel master file macros, excel formulas, excel based, create excel worksheet, export stock data, excel macro csv, excel required csv, import data macro excel, excel file order form, workbook csv, import excel data form, import data form excel, stock spreadsheet excel, stock excel, macro import csv, create workbook, layout worksheet, excel import export, export excel form

Om arbejdsgiveren:
( 6 bedømmelser ) Auckland, New Zealand

Projekt-ID: #956356

Tildelt til:

agihcam

Please check PMB for more details.

$80 NZD på 1 dag
(39 bedømmelser)
5.2

4 freelancere byder i gennemsnit $68 for dette job

binaryromel

Lets start. Please check PM. Thanks.

$75 NZD in 2 dage
(34 bedømmelser)
4.9
cycada

I can do it for you

$50 NZD in 2 dage
(0 bedømmelser)
0.0
kkh0806

Please check inbox!

$65 NZD in 2 dage
(0 bedømmelser)
0.0