What's New Unreplied Topics Membership About Us Contact Us Privacy Policy
[Ad]
Forums Blogs Store Members Gallery Directory

Sign In Register

Need Help Simple Excel based IT solution for warehouse-receiving

Started by , Nov 11 2015 01:24 AM
Reply to this Topic
3 Replies

I would like to create ingredient based excel sheet and link it with batch code scanner. 

 

I need some help in formatting the excel sheet so when a staff member scan the batch code it will automatically  find it place against the relevant product.

 

for example if we have receive flour than the scanned batch code will automatically display against the relevant flour.

 

Any help would be much appreciated.

 

Kind regards

Humaid Khan

Share this Topic
Topics you might be interested in
Warehouse storage practice for Non-GMO Project Temperature recording document in Excel Anyone have a template for the V6 Risk Based Plan for Tanker Cleaning risk assessment? What would be the best temperature and relative humidity for our rice mill warehouse storage facility? Warehouse Storage Practices
[Ad]
Hi Kumaid,
 
I assume you have a very long list of ingredients in an Excel spreadsheet. This is open on a computer in your warehouse which has a simple barcode scanner attached to it.
To save the receiver some time in locating the row with the ingredient being received, you would like to be able to scan the barcode and be taken straight to that row in the Excel spreadsheet.
 
Correct me if my assumptions are wrong, but this is what I am understanding from your post. 
 
Barcode scanners are typically set to emulate keyboard input. So at the simplest level, you could click CTRL & F  in Excel, scan the barcode and hit enter to be taken to that row.
 
Or, you could have a cell at the top of the screen which is used as the barcode input, and when that is updated a Macro could fire to essentially do the same thing as above.
 
In summary what you may be attempting to achieve is very straight forward.
 
HTH.
 

Hi Phillip

 

Thank for your reply. You have understand my requirements correctly. It appears that I do not need any formatting of the excel sheet.

 

Do I have to put the cursor in the cell in front of the product name or just press CTRL & F any where in excel and press enter and computer will automatically take it to the designated row?

 

can I use cell A1 as a barcode input cell and then when the ware. Put the cursor in A1  then the micro will take it the designated row?

 

My issue is that when some one receive several supplies at the same time. Then warehouse staff does do not have time to run back and forth to shift the cursor from cell to cell to ensure that the barcode belong to the specified product.

 

Regards

Humaid

  1. CTRL & F (anywhere in sheet)
  2. Scan Barcode*
  3. Press Enter Key

This should do it.  :smile:

 

I guess I don't need to tell you that this is a pretty crude solution to incoming goods receiving but if it works for you..!

 

*As mentioned most barcode scanners, particularly the ones that connect straight to computers via USB cables simply emulate keyboard input. If yours does not do that, then it might require a little tweaking but I would be surprised if that was the case.

1 Like2 Thanks
Reply to this Topic

Similar Discussion Topics
Warehouse storage practice for Non-GMO Project Temperature recording document in Excel Anyone have a template for the V6 Risk Based Plan for Tanker Cleaning risk assessment? What would be the best temperature and relative humidity for our rice mill warehouse storage facility? Warehouse Storage Practices HACCP Guidance Plant Based Protein Meat Alternatives. Receiving Returns from Non-federally registered establishment Multicriteria-based ranking for risk management of food-borne parasite External warehouse - questions and concerns Offsite Warehouse - SQF scope
About us

IFSQN is an international networking group for food safety professionals. We connect those interested in food safety to information and to each other. The purpose of the website is to share knowledge, experiences and ideas to make food safer.

All content © Copyright 2021 IFSQN