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.



Taidot: tietojenkäsittely, Excel, Logistiikka ja rahti

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #13132373

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$300 USD 3 päivässä
(566 arvostelua)

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 Lisää

$250 USD 4 päivässä
(238 arvostelua)
$280 USD 2 päivässä
(253 arvostelua)

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 3 päivässä
(266 arvostelua)

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 Lisää

$270 USD 3 päivässä
(70 arvostelua)

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 Lisää

$250 USD 3 päivässä
(92 arvostelua)
$555 USD 10 päivässä
(7 arvostelua)

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 10 päivässä
(38 arvostelua)

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. Lisää

$300 USD 10 päivässä
(43 arvostelua)

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 10 päivässä
(3 arvostelua)

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 Lisää

$250 USD 2 päivässä
(2 arvostelua)

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 Lisää

$555 USD 10 päivässä
(0 arvostelua)

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 5 päivässä
(0 arvostelua)

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 Lisää

$666 USD 6 päivässä
(0 arvostelua)

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 Lisää

$555 USD 10 päivässä
(0 arvostelua)

A proposal has not yet been provided

$555 USD 10 päivässä
(0 arvostelua)

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 10 päivässä
(0 arvostelua)