Hi all,
I have been using Excel for a few years now, but I have only really scratched its surface.
I have been using Excel to great effect to hold all my stock records, item part number, prices, manufacturer, description and so on. I recently been trying to add stock location data, this has worked well but for one problem, I am approaching a stock count and have tried to sort the data by bin location. I was expecting the data to be arranged in an order of location but Excel is jumbling the locations up which make a stock count difficult.
My location data is AlphaNumeric but this could be changed for a better string of data if neccesary, but it needs to give clear location data, which is logical to stores staff.
The locations I have set up consists of a Letter of Rack, Letter of shelf on the rack, and number of location on the shelf. This would result in a location of say, AA1, which would be rack A, shelf A, and location 1. This works fine until AA10 is reached, it puts location 10 in the wrong postion on the spread sheet. I have tried breaking the string up with dots and slashes. I have tried formatting the cells to text, numbers and others.
Please help my stock check is looming, and with over 4000 parts to check with some 500 located parts this will be a long job.
I hope I have described my situation so it can be understood, hopefully an Excel guru out there may have an answer I am sure there is an easy way around this problem.
Thanks in advance for any help.
Regards
Mark
Bookmarks