Excel WebQuery, Warehouse Pick List Template


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.



Skills: Data Processing, Excel, Logistics & Shipping

See more: pick list template, excel party list template, excel packing list template, packing list template excel, price list template excel, amibroker dde excel example, css item list template

About the Employer:
( 0 reviews ) United States

Project ID: #13132373

19 freelancers are bidding on average $395 for this job


Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Automated Web Scrapping using Excel Macros an More

$300 USD in 3 days
(402 Reviews)
$280 USD in 2 days
(250 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$300 USD in 3 days
(128 Reviews)

Hello, Thank you for your invitation! My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent More

$270 USD in 3 days
(57 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$250 USD in 4 days
(113 Reviews)

Greetings from the U S A.. {smile} Highly experienced (25+ years) MsEXCEL Business System, Programming, and Database expert with Guru / Mentor level technical credentials at and www.vbcity.c More

$444 USD in 10 days
(32 Reviews)

Hello! Thanks for inviting me to your project. I learned your file and I can complete your project in three days.

$250 USD in 3 days
(106 Reviews)
$555 USD in 10 days
(7 Reviews)

Hi, Thanks for inviting me for your project. I have 4 years experience in Excel VBA programming including automated data scraping using Internet controls. Can you please tell me more details? Based on the nam More

$250 USD in 3 days
(61 Reviews)

I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio:

$500 USD in 10 days
(31 Reviews)

I'm a Mechanical Engineer familiar with Microsoft Word, Microsoft Excel Google docs Spreadsheet, Wordpress, Magneto I Provide certain services : 1. Data Entry 2. Web Research 3. Social Media Marketing 4. More

$300 USD in 10 days
(11 Reviews)

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.

$277 USD in 10 days
(2 Reviews)

WARNING: Our bid is based on the average prices. Contact us to negotiate the price you want! We are a company from Caracas-Venezuela specialized in different areas. Our team is made by designers, developers, animat More

$555 USD in 10 days
(0 Reviews)

I used to work with excel formula for calculating the salaries of employees as well as calculating the income tax. and I am sure I am fit your needs

$555 USD in 5 days
(0 Reviews)

Moreover, I have good communication skills in English and Spanish, an advanced knowledge of browsing, web surfing, MS Excel and Word. The enclosed resume contains more details about my qualifications and data-entry ski More

$666 USD in 6 days
(0 Reviews)

Hello, I have review your job posting.I have excellent skills and over 5 years of experience working with all - Copy Typing, Data Entry, Excel, Internet Research, LinkedIn (Manual Research & LinkedIn scrapping), Insta More

$250 USD in 2 days
(1 Review)

My name is Mike, I’m from UK. I work with individual clients and agencies who have design, development and SEO needs. Your project description sounds interesting to me and I do have skills & experience that are require More

$555 USD in 10 days
(0 Reviews)

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)

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.

$400 USD in 10 days
(0 Reviews)