I have a simple excel workbook consisting of worksheets with each worksheet containing the inventory of one of several warehouse buildings. We are presently doing a simple find to locate the location of inventory items we need to retrieve each day. The same item may be stored in multiple locations and in more than one warehouse. We just look items up one at a time and make a list showing the item number, the various locations(including warehouse, row and shelf and quantity in each location.)(all these fields are already in the sheets)
I want a simple to use interface pop-up or page that allows input of the search term. A box to check that says yes I want to pick this item. Then an automatic search would be made for all locations of this item and list them. Each following search would add to the list until all items needed were found. Then a print request would be presented to print a complete list of all items with their locations. This list would also be available on screen in case we did not want to print list and just carry a laptop to the warehouses to pick and check off the items found.
Also need ability to delete selected items or make corrections to the list f possible.
That is about it
31 pekerja bebas membida secara purata $129 untuk pekerjaan ini
Hello; I read your project and understood exactly what you need...kindly get back to me if you wish to proceed with a top-rated and reliable excel & vba coding expert here...regards,
Why pick me? Outstanding feedback on all projects (without exceptions). Able to turn around with minimum of fuss. Please see private message. Many thanks, Andrew
I've been developing software solutions for over a decade and am more than certain that I can make quick work of this project for you. Please see my private message for more pertinent information. Thank you!
Hello, This sounds like an interesting little project. I would recommend an Excel add-on built with Visual Studio Tools for Office or SpreadSheetGear. They would to do the query and present the results.