We have an Excel Sheet with details of work to be invoiced each month. We have used Pivot Tables and VBA to create the Invoice. Additional VBA is required to do the following. 1. Add the header row of the pivot table to each page of the Invoice. 2. Increment the Invoice Number by 1 each time an invoice is printed. 3. Add the customer’s name &
Dear My name is Sylvain and I would like to create an automation data entry. My expert in VBA left the company 3 weeks ago and I need to move forward on my project. The project is simple and consist in : (From an excel sheet) 1) automate login into website 2) copy and paste data from an excel file into the website 3) copy and paste data
Would like to scrape data from a web page which has iframes and various other embedded/nested tags. The project is required to be run in VBA in excel. It should be able to either "throw keys" or take limited control of the page to loop through a list of values, look these values up and then store the innerText of what is displayed on the page in
...COMPETITORS WEBSITES FOR INVENTORY AND PRICING I work in the wholesale tire business. I am looking for someone who has experience in web scraping, content grabber, and ripping information from websites. I have a list of a few websites that all require logins. I would need you to be able to pull all the information related to inventory, item description
...value to determine our sales price. We sell on multiple channels and our prices often change for promotions and often while negotiating with our customer. I need an online Inventory tracker that calculates pricing and cost based upon a bulk mixed lot purchase and some data we enter. Data will be entered by 2 forms a “Pallet” form where we enter some
5 files need pivot table, pivot chart , chart using VBA code.
...also like a button to export the results to a new empty spreadsheet in excel. With my very limited knowledge I would assume a connection string may be required if done though vba which will be provided if needed. Following pass-through SQL Code select informix.whs_order.whs_order_nbr, informix.whs_order.store_nbr, informix.whs_order.pick_date, informix
Hello, I need a MySQL and PHP script that can do the functions as below: 1. I have tables created in MySQL already and need to use PHP programming to post those products which are on stock or CHECKED directly into Amazon. 2. I need to post in different Amazon accounts like [url removed, login to view], [url removed, login to view], [url removed, login to view] etc. So it must have poss...
The task is to review the fitness club's photography, and then create a comprehensive inventory of the club's equipment and furnishings based on the photos provided. Things that require writing down are mostly sports equipment by a company called Matrix. The exact name of the equipment needs to be recorded. For each item you should find the prices
...this project I need the following elements saved from each product page: Features Specifications Part Numbers Downloads (if available) For this project, you will write a VBA script for Excel that will go through the website and extract this data and create an Excel workbook with the HTML from each tab in a cell along with the item's main part number
We have project for UK residential and commercial properties, where estate agents can use app on their phone or iPad....following is the information. Create a mobile app for iOS and Android which allows users to complete reports on-site without the need for an Internet connection. App must store captured images on phone storage with time-stamp, option to upload should be available, bearing in m...
A software through which I can make invoice and manage inventory
I have an already functioning VBA-code, which hast to be modified to fit an other case. A new variable hast to be added, which also affects already existing variables. The VBA-skills you need do not have to be very advanced, but you need enough experience in programming because understanding the problem is pretty hard. You also would have to work with
Hi I am looking for excel expert who can create advance excel sheet to Manage Raw material inward , raw material issued , WIP , Finished goods , Material consumption against project , moving average of rawmaterial , calculation of Total variable cost project wise.
I am looking for a developer who can efficiently build a robust POS & Inventory solution. More information will be disclosed later. I have extensive knowledge in the field of Food & Beverage. Similar project: Square POS, Revel POS, MarketMan, Simple Order
We are looking for a developer who works with Microsoft Office and perhaps with VBA or some kind of artificial intelligence approach to develop a program or Office application that summarizes tabular data. We will supply the language and the program needs to simply "read" the table and summarize the results of multiple choice questions and of tables
I need to be able to keep track of: -product inventory -item check in (multiple vendors) -item check out (from product inventory --> multiple vendors --> consumers) -daily sales -daily net profit
I need to do inventory check with Excel. I will scan parts with barcoder reader that will give output in [url removed, login to view] (delimited file, see example in uploaded files). About 100 [url removed, login to view] files will be generated ([url removed, login to view], [url removed, login to view] etc) that need to be inserted in inventory.xls. Other explanations in [url remove...
I have a calculation tool at hand whose macro is currently written in OpenOffice Basic. I need this macro rewritten in Excel VBA. The code is approximately 600 lines, but not complicated. If the programmer knows both OpenOffice Basic Syntax and Visual basic, the conversion should not be too time consuming.