Streamline Equipment Request Number Spreadsheet

[tivory]

My goal at my current employer is to create a unique spreadsheet that will populate the next available unique number to be created based on the piece of equipment.

• create tabs for INSTRUMENTATION (these will need to be broken down based on flow, level, & pressure), JUNCTION BOX, PUMPS, FIXED EQUIP, ROTATING EQUIP and all other associated equipment.

This will be an evergreen document for administrator (which is myself) only but will allow for correct numbers to be issued to all requestors.

Currently I'm going through about 5 locations to get one unique number based on the request I receive from the requestor. I'd like to use Excel to provide the next available number based on the equipment that's being repaired/purchased. See attached for more details...

Thank you,
Timothy Ivory

[FDibbins]

tivory, Please upload a sample of your workbook, not a picture of your data (pdf is still a picture). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[tivory]

FDibbins, see attached document and I hope this helps you and thank you for your assistance. I'll also keep in mind to only add workbooks and not photos.

Thank you,
T