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