![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Automatic Location Allocation & Unique Reference Insertion
- or -
Post a project like this3446
£25(approx. $32)
- Posted:
- Proposals: 1
- Remote
- #664486
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Description of excel work: 1 - Based on the information inserted into Column A of the 'Allocations' sheet, insert the next free location for that particular tub size (locations tab contains all locations and a free location is indicated by a '1' in the cell, the size of the location is indicated in the cell next to this as S1, S2, S3 etc)
2 - Once this location has been allocated, insert location into column C of the 'Allocations' sheet.
3 - Now i need a unique reference assigned to each row. This is known as the fast find ref. There is a sheet for this also. We need to copy the 'supplier code' from 'Allocations' and past this into the next available reference number available on the 'Fast Find Ref' sheet. This will be identified as it will be a blank cell in column B
4 - Once the reference has been allocated, it needs to be populated in the relevant cell in the 'allocations' sheet (column D)
I need to be able to add new locations to the 'Locations' spreadsheet should we expand our warehouse. And i also need to be able to add additional tub sizes should we need to get new size tubs for new products. A complete running total of the number of free spaces for each size of tub needs to be kept.
Attached is the spreadsheet i currently use. As you can see its all manual at the moment apart from the totals which is a simple formula.
Tub sizes are S1, S2, S4, S4, S5, S6 for now.
Extra notes:
When the fast find ref is generated next to the product location on the 'locations' sheet, it needs to have a small a followed by a hyphon inserted to prefix the fast find ref. e.g. if it had a ref of 546789, when allocated to a location it needs to go in as 'a-546789'
2 - Once this location has been allocated, insert location into column C of the 'Allocations' sheet.
3 - Now i need a unique reference assigned to each row. This is known as the fast find ref. There is a sheet for this also. We need to copy the 'supplier code' from 'Allocations' and past this into the next available reference number available on the 'Fast Find Ref' sheet. This will be identified as it will be a blank cell in column B
4 - Once the reference has been allocated, it needs to be populated in the relevant cell in the 'allocations' sheet (column D)
I need to be able to add new locations to the 'Locations' spreadsheet should we expand our warehouse. And i also need to be able to add additional tub sizes should we need to get new size tubs for new products. A complete running total of the number of free spaces for each size of tub needs to be kept.
Attached is the spreadsheet i currently use. As you can see its all manual at the moment apart from the totals which is a simple formula.
Tub sizes are S1, S2, S4, S4, S5, S6 for now.
Extra notes:
When the fast find ref is generated next to the product location on the 'locations' sheet, it needs to have a small a followed by a hyphon inserted to prefix the fast find ref. e.g. if it had a ref of 546789, when allocated to a location it needs to go in as 'a-546789'
![Steve J.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/a61795e9de9b8be728845c978a4f6f86_150x150.jpg)
Steve J.
100% (50)Projects Completed
57
Freelancers worked with
47
Projects awarded
84%
Last project
27 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies