I have a excel file used for stock inventory used thrice in a day which my operators put in. there are four different departments and thus each department is separate from each other. my supervisors are not literate in computer or studies they don't know to read and write but know numbers and item names as they deal in it everyday. 1}they have to first
I have a set of Excel spreadsheets that builds out graphs on stock market data, but a while back, Yahoo Finance cut off it's free download API and I am not able to get the stock market data. I just need someone to program the macro to: 1. Download the data for the symbol that I put in up to the maximum years back per the data vendor 2. Put the weekly
We have a battery inventory excel file from where we would need to create another excel file to get the list in a different format ( 4 column ). In our main file, the model are split by coma... Categories, Brand, Model, URL Link We do not want that you do this task manually. This may be very fast if you use a script or excel macro.
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
...two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned
i have an excel out put from an app which i want to paste it into excel on one sheet and then have another sheet on the master file which pulls key data from the pasted file and then i want to click on a macro button to copy the new manipulated sheet and create a new sheet without the manipulator in it. i also want the new excel file to retain its
Optimize and maintain custom barcode scanning system for shipping. We hired an electronics firm to setup a barcode scanning system. It works but sometimes loses data. The original company no longer has a programmer. The scanner system uses handheld wireless portable barcode scanners with a custom program. The program asks the user for a sales order number which is then input manually. Then the pr...
we prefer Something Ready in Cheap Price , please Don't Contact If you Bidd is Above My Budget I need webbased inventory & billing software 1 – product / service inventory 2 – statement of account print 3 - invoicing & printing with vat 4 – voucher printing 5 – daily sales report 6 - multiple style of invoicing 7...
I need help with economics. Three projects to be finished in a timely manner. Masters in economics is preferred.
We have a financial modelling calculator that is having issues when transferring data in from an external source (CSV file). The original programmer is no longer available to trouble shoot. We are in need of a programmer going forward so there may be more work to follow if this task is completed to our satisfaction. ASAP Update: AUS/NZ preferred
I would like to automate a report based on a series of questions my empoyees fill out out. I need a way to auto generate a sample phrase into a word document based on a yes no question. So the employee checks of yes or no on a form. If it is no then then word will generate a response. If the employee checks yes they will have the options to check a/b for an answer and that will generate an answe...
I need you to develop some software for me. I would like this software to be developed for Windows.
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
i would like to integrate a inventory control system inside my woocommerce . where it will be possible for me to add my product through my woocommerce backend and control my stock inside it. maybe you will have a plugin and customize it for my needs.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I am building a WPF database application. It’s a basic inventory application. It’s using a telerik Gridview. I need help with some aspects like databinding an image to my database table where I need a byte to image converter. I’d like you to complete this step. Then I’ll take it back. I am likely to run into other aspects I can’t complete so there will
Windows based only. Front end...dot net, back end....SQL.
Use an API (REST web service using GET method) to automatically retrieve data into an existing Excel sheet. More specifically, I need pricing data (from the API) to be matched to my existing inventory data. It is a one-off job to write the code/macro
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
Hi, What I need is probably really simple but I can’t figure it out. I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually. Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named
We are looking for somebody to come up with a database schema for a small packaging company. The company does not purchase materials other than consumables such as pallets etc, but is free issued all its materials. Materials come in the form of mill/master reels of flexible packaging materials which are slit/cut down to food packaging dimensions. Normally a full mill/ master reel is used on one j...
Hi, I am in the first steps development a downloadable excel calculator. The interface and calculations are confirmed and tested. To improve the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials
We grow plants in an indoor farm. There are several rows of plants in different rooms. Each row is on a different harvest schedule. Certain tasks must be completed prior, during, and after growing periods for each row of plants. The timing of these tasks depends on the particular plant being grown in that row. Often tasks from one row will overlap with another. The problem is that we need a w...
I have an inventory management software.I need a person who has knowledge of how an inventory management software works. Need to add some new modules and to repair the previous one with changes in front end
Our business is a corporate catering organisation for off shore and onshore catering, housekeeping and laundry, on site catering for factories and for corporate canteens