Excel WebQuery, Warehouse Pick List Template

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

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

Data Processing Excel Logistics

Project ID: #13132373

About the project

17 proposals Remote project Active 7 years ago

17 freelancers are bidding on average $401 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
(566 Reviews)
8.2
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
(238 Reviews)
7.5
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
(266 Reviews)
7.1
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
(70 Reviews)
6.7
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
(92 Reviews)
6.4
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
(38 Reviews)
5.4
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
(43 Reviews)
4.6
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
(3 Reviews)
2.5
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
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
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
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