We currently use an Excel WebQuery file which lists our business's physical inventory on a line item basis. We need to be able to create (and download) daily warehouse pick lists from a custom template on a separate tab, which pulls in data from the WebQuery file.
Attached is a quick mock up I put together as an example. There may be a few additional fields we need to add to the Pick List template based on our needs.
Typically, we'll have 10-20 pick lists per day, with an average of 18 items per pick list.
18 freelancers are bidding on average $403 for this job
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
I have more than three years of professional experience in doing Excel and data entry. I also have a good knowledge and practice of using formulas and functions of excel.