Inventory Count Sheet - add Columns

Hi James, yes we are using locations for bin.  I am trying to make this process as easy as possible - Print list by Bins, someone then data enter quantity easily using this sheet and not have to search parts.  I need list to reflect exact order of Location/ Bin Sheet

Hi James, hopefully last question, can I search by bin only when entering on the count sheet.  Control +Shift+F allows search but can only search part number of name

Does anyone have a solution or work around.  We will be using the Count Invetory sheet "Live" for our end of year stocktake  but the items numbers are not listed in BIN order so have to search for items which is quite time consuming as to ensure data accuracy we have to search for the exact Item Number.  Have looked at exporting data but even more time consuming and worried when we import that we will have to check items all items - we have around 5000 or more items.  Basically staff will use a printout stock sheet by BIN order, and manually tick off or adjust then give to admin to enter Live onto MYOB Accountright Count Inventory and I cannot seem to find a way to make this an easy option for our admin to data enter.  I am not even considering data entering onto excel spreadsheet as the Item Numbers when you go into Count Inventory are all over the place, our Item Numbers are all numeric to match up with our supplier Item Numbers so cannot change.  Help would be appreciated.  Thank you