Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using
I need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
[kirjaudu nähdäksesi URL:n] is a new ecommerce website in progress built on Shopify and Oberlo dropship model. Inventory has been added and theme has been personalized to desired look and feel. Instagrama and FaceBook pages have been completed. We need experienced end to end IT partner in performing product title, description and image updates, create facebook
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
We would like someone to create a inventory management database that can be accessed from anywhere. A sample is explained in detail on the following video [kirjaudu nähdäksesi URL:n] We would like the system to be able to add inventory in increments. So if 1 barcode is scanned 3 times, 3 quantity should add. The same goes for minus quantity.
I need a pos software inventory program that is already built only. software must be built already or require minor revisions I would like this software to be developed for Windows using PHP. asp [kirjaudu nähdäksesi URL:n] mvc
I need you to develop a complete POS sales and inventory management software integrateable with barcode , cash drawer etc Main features : User friendly Fast billing Automatically stock balance Sales analyst Instantly view your sales Cash balance with drawer High security Suppliers and customer information Debtors and creditors Multiple users with multiple
I have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
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 an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el
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
...I need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then
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 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.
...ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new sheet. 2. Apply the Excel Forecast Function to the monthly data for each product and output in the following format for the next 12
Necesito un código en VBA que extraiga la data que está en la siguiente web: [kirjaudu nähdäksesi URL:n]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
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 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.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[kirjaudu nähdäksesi URL:n]" erfolgen. In dieser sind bereits Module und Code zur...
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.
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
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
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another sheet within the workbook