Agihcamemplois
Investigating This project is for hiring a full time or commission based position (e.g. Sales) . No other fees are charged to employers or workers, including project comissions. You will save a lot if they have ongoing work.
The object of this is to create some price labels in a word document from data in an excel sheet See attached Price label template – there needs to be 40 of these per page 10 rows of 4 They need to take the following 1) Description from Order Sheet (column B) - max 3 rows on price label with each row no more than 14 characters with each row centred. If description is longer than 42 characters trim at that. 2) Price – Retail price needs to be added in to the “Order Sheet” from the Master Spreadsheet Column M, as a new column in between column C/D 3) SKU – taken from column A of Order Sheet Font styles and sizes need to be as per the template This needs to be reusable e.g. we will have a new order sheet and need to generate new price labels each mon...
see attached
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 nee...
Full details of the work are given in: This project is only for agihcam OM
