Excel WebQuery, Warehouse Pick List Template

Closed

Description

Hi!

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.

Thanks,

Mike

Skills: Data Processing, Excel, Logistics & Shipping

See more: printable price list template for excel, pick list template, excel party list template, excel order packing list template, invoice packing list template excel, excel packing list template, shipping packing list template excel, packing list template excel, price list template excel, quickbooks item list template excel, amibroker dde excel example, template invoice free design excel, insert form elements excel example, working hour roster excel example, css item list template

Project ID: #13132373

19 freelancers are bidding on average $395 for this job

jaylancer43

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)
7.8
$280 USD in 2 days
(250 Reviews)
7.6
P0L

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)
6.4
chriskerpini

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)
6.4
schoudhary1553

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)
6.2
bossumd

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)
5.7
wsh2

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 www.experts-exchange.com and www.vbcity.c More

$444 USD in 10 days
(32 Reviews)
5.8
$555 USD in 10 days
(7 Reviews)
5.2
kolosibalint

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)
5.5
KavTan

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

$500 USD in 10 days
(31 Reviews)
4.5
muradeltaher

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)
2.8
rafeemd

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)
2.2
gjoniboj2005

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0
sikkaankush3

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)
0.0
mike199

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)
0.0
sumon1

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)
0.0
amankumar1865

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)
0.0
angkasawijaya

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)
0.0
CodesignVE

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)
0.0