I gang

Excel Macros Project (Part 2) - Specifically for - agihcam

This is part two of the original project for agihcam

Amendments to current Worksheet

• Remove Tickboxes and tickbox column

• Remove Unselect All

• On “Create Order” take all lines of stock from mastersheet

• On “Order” Sheet add column at the end called Allocation check which is d-(i+j+k+l)

• On Order sheet make sure calculations work for Column F, Column H, C$ and C5 (these were part of previous job)

• Add a button – “Import current Inventory” - this updates the inventory fields from an export csv file as per attached

The other main bit is to add and "Add Current Order to Inventory" to get the order Allocation for the 4 stores added back into to the Master Spreadsheet File - will need to browse for the current "Order File"

e.g. Master stock list shows for a line of stock

inventory_Browns Bay inventory_Orewa inventory_Pakuranga Inventory_Devonport

5 6 2 4

On the order sheet we are ordering a total of 16 cases - 4 each for each store

Need to make the figures on the import sheet total the current stock plus the ordered stock so on the import sheet it shows

inventory_Browns Bay inventory_Orewa inventory_Pakuranga Inventory_Devonport

9 10 6 8

So Process from Start to finish is

1. Create Order (all lines) – quantity and store alloc get filled in manually

2. Import Current Inventory – Updates 4 x inventory fields on Master from CSV

3. Add Order to inventory – Updates 4 x inventory fields on Master from order sheet

4. Import – stays as currently is

Færdigheder: Excel

Se mere: excel project part, we excel, finish master, excel macros project, master excel, part, master work, line sheet, excel inventory, create part, create excel worksheet, sheet excel job, export import project, inventory allocation excel, add macros, excel add csv import, create csv file inventory, spreadsheet project, stock spreadsheet excel, 2011 excel add, work excel job, project export excel, excel line work, stock excel, excel import export

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

Projekt-ID: #965279

Tildelt til:

agihcam

Please check PMB for more details.

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