Design an Excel spreadsheet

I’m looking for someone to draft a simple to use excel spreadsheet that will include the following;

- Column B – Labelled Generic Code - partial barcode number (partial barcodes are scanned using a USB connected barcode reader out of book for various inventory items)

This partial barcode is then deciphered into Column C;

- Column C – Labelled DESCRIPTION – an item name taken from a list on a separate worksheet page

The following information is then added to the barcode;

- Column A – Labelled IDENTIFIER - sequential numbers from 1 to ?? (next scan of any Generic Code automatically has the next number attributed to it)

- Column D – Labelled TEST DATE - populated with today’s date when the item is scanned

- Column E – Labelled RETEST IN - left for manually entered data and used to populate Column F

- Column F – Labelled RETEST DATE - populated with todays date PLUS (the number of months manually entered in column E (eg, 6, 12, 36 or 60months)

- Column G – Labelled TEST RESULT - left blank for manually entered data that has no influence on other columns

- Column H – ITEM BARCODE - the actual item barcode updated from Column B Generic Code and including Identifier data (from Column A)

- Column I - A###### - left blank for manually entered data that has no influence on other columns but will print out on labels

- Column J - B###### - left blank for manually entered data that has no influence on other columns but will print out on labels


The requirement is to be able to use a barcode scanner to scan a Generic Code (ie. partial barcode) from our inventory book and have the data automatically populate a line on the spreadsheet. Once populated, we need to be able to send the data to a label printer which will pull information from a single line of the spreadsheet and print a label containing information contained in Columns A, C, D, F, G, I & J as well as a barcode generated from data in Column H.

We also need to be able to scan the actual ITEM BARCODE (ie. Column H) and have that scan repopulate the corresponding line on the spreadsheet, updating only Column D to current days date and therefore influencing Column F but not impacting Column A (ie. the IDENTIFIER & therefore the location on the spreadsheet doesn’t change)

Taidot: Excel

Näytä lisää: stylish excel spreadsheets, beautiful excel spreadsheets, excel design tips, how to make an excel spreadsheet look like a word document, excel spreadsheet design best practice, how to make a spreadsheet look presentable, excel sheet design templates, beautiful spreadsheets, column design spreadsheet excel, beam design spreadsheet excel, xls excel spreadsheet bridge design, iphone design developer spreadsheet excel, convert numbers spreadsheet excel, convert numbers spreadsheet excel spreadsheet, convert apple numbers spreadsheet excel

Tietoa työnantajasta:
( 1 arvostelu ) Nth Ryde, Australia

Projektin tunnus: #14823253

Myönnetty käyttäjälle:


Hi, the Excel seems pretty straightforward, it should take 1 or 2 days max; as long as you can iterate quickly and are clear on what you want. Relevant Skills and Experience I am a BCG strategy consultant, I have deve Lisää

$111 AUD 7 päivässä
(0 Arvostelua)

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Lisää

$200 AUD 3 päivässä
(176 arvostelua)

Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis, I'm your ideal candidate. I'm highly experienced in producing mathematical solutions with Excel and I have a stron Lisää

$100 AUD 3 päivässä
(7 arvostelua)

A proposal has not yet been provided

$207 AUD 3 päivässä
(8 arvostelua)
$155 AUD 1 päivässä
(0 arvostelua)

Hello, I graduated from Boston University USA. I have a lot of experience working on excel. I never miss work and always deliver on time. My personal qualities are: - Detail Oriented, as handled many sensiti Lisää

$150 AUD 1 päivässä
(0 arvostelua)