2 x simple Excel Macros
- Status Closed
- Budget $30 - $250 NZD
- Total Bids 4
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 spreadsheetGet free quotes for a project like this
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online