Need Excel VBA (Macro(s)) for building an Excel database in an existing spreadsheet, and backfilling data changes/updates made in one worksheet of that workbook read to that database back into separate database. The macro(s) will allow users to change or update data inputted in one worksheet, and have it copied and pasted (values) to another, then another
...communicate with a REST-API. I want everything in real-time. Different menu options: [kirjaudu nähdäksesi URL:n]: possibility to configure the app with the URL of the rest api. 2. Start inventory. This starts a screen with a label where the productnumber or EAN code can be entered. Once entered there has to be send a request to the rest-api: [kirjaudu nähdäksesi URL:...
I want VBA code in excelsheet, its look like an invoice sheet i want a save button with this form one I click that it will save the invoice same of the id + open new invoice with the following number directly.
Looking for someone to create a CRM/Inventory Dashboard for our website. Needs to have phone, email, text integration for the CRM. Along with real-time notifications and mobile friendly backend. More options to come. For the Inventory Management, we will need 3rd party sites feeds integrated into the inventory section. We are a classic car dealer so
Hello, I found a little company. All the entries my expense and revenu are organized in a excel spreasheet. I have my budget for each location. I'd need help to how my entries in my ledger can be linked to my budget so everytime I put a need entry with a refresh it can updated in the budget in column called actuals.
Hi, I have a field 'Field' in attached excel and I want a VBA code that will loop through the column values in Field and create a new field 'Field2' which will flag 1 when loop hits the last value in the Set of same values. Finally, the macro should delete the original Field, retain Field2
To design and build an app to manage deliveries and inventory system for admin and staffs. Full details will be given, please pm. Strictly SGD $200 project only.
Looking for a tool/application that will scan in and out keys that are taken from my office. Each key set will need to have a unique code, as well a detail of what keys were on the ring. Vendors need to sign off when they take a key. Daily a report, which keys were not given back. Tool needs to be expenable for different offices, for 1 company. As well sellable, to other companies.
I need an Android app. I would like it designed and built.
Need a web-databased Industry management software with multiple options queries and report finding. Files will be given to you soon. Need a personal with effective communication skills. Have good experience in web-based software.
Hello, I would like to develop a mobile app for looking up and updating stock in our warehouse. The app would use the following API to search and update the stock level. [kirjaudu nähdäksesi URL:n] The app must have the following fields 1 - SKU 2 - Title 3 - Barcode 4 - Stock Level 5 - BinNumber 6 - Image We should be able to filter the results by 1) Stock Location 2) If the It...
I'm looking for a database that will capture telecom /isp circuit id's, carrier information (contact), customer information....Geographical Location information for the associated circuits is required as well. Essentially I need a place to have all of this information entered and sortable . I am thinking Excel or Access would be good enough for this
... Cells(8, 24).Value = "" Else Cells(8, 24).Value = Format(Now, "HH:mm:ss") End If End If End If i found this code on internet, but it does not work on excel table.. i want to update timestamp on a particular cell (cell A) based on changes that happens on (Cell B) which is based on formula which is on (Cell C) i want to link entire
Working with Outlook 2010 - Inbox and any sub folders. Have set up various Categories, which are assigned to an email via Quick Steps. When s...assigned to an email via Quick Steps. When sorting by Categories I want the 'Done' Category to Collapse, so that no Category 'Done" is visible. I assume that it will require VBA, but open to other options.
We are looking for Freelancers that can help us in building a solution where we can upload products from an MS Access database to WooCommerce using their API. [kirjaudu nähdäksesi URL:n] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would also include images for these ...
I have multiple mdb files that need to be combined into one and filtered out. I need a access vba to combine all files together and select records every 10 records from the combined one.
This is a field research project. We are looking to understand what the current market provides as housing options for students...project. We are looking to understand what the current market provides as housing options for students and young professionals in the Greek side of Nicosia. I have prepared an excel sheet to fill out - please find attached.
Looking for an excel sheet or simple program that would assist in drop shipping. Current files are delivered by suppliers as excel document, then uploaded using excel document. Would need to be able to adjust categories and adjust prices to all products based on msrp, minimum advertising price, and markup.
Hi, I run a warehouse. In order to manage our inventory dispatches to our customers, need to build Excel tool (using VBA and macro) for inventory management. Need someone who is very good with VBA and excel macros. Thanks
I need a salary tracker, that will determine my gross and net pay also will counts days worked. I need this to also once it get to 170 days worked, on the 171 day plus wi...hours, it will calculate a set day rate . I'm including this sheet as a guide, but I'll be looking for something new from you, not the same one. You will need to be able to do VBA
I run a online artwork business, i have a bundle of print artwork to ...store, about 700 items, need someone to create names for them and maintain the names in a excel list. No special skill required, need someone who uses English as first language, knows basic of excel sheet. Plus there might be some more website and inventory maintenance later.
Looking for freelancer who is well versed with Excel VBA to be used on simple finance question. Looking for someone who can help code out NPV and IRR values for the scenarios, create a graph visualizing the NPVs. Drop me a message if you are into this
An easy-to-use computer program / system that reflects the sales, profit, and inventory of stocks for my hardware store in a day-to-day basis. It is preferably in an MS Excel format.
...in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes....
its a small project for that i volunteer for
This request is for a MacBook! I have a folder with several su...folder with several sub folders, and sub folders within those folders. In these folders I have several excel files. The excel files all have the same format. I need to compile certain cells from each file into a table. I don't know how to write the VBA code and need help. Thank you
I have this worksheet with dates in column B, and name in row 1 and sub headings in row 2. I have set up this userform, so the user can select a name, choose a tra...have also defined the name row as name in the worksheet. And here is the code I have developed so far, could someone please kindly give me some advice as I am very new to this VBA coding?
I need certain quite simple VBA macros written, which mainly do copy/pasting from excel file to another excel file, number searching, etc, quite simple operations. I will be available online as you work, so you'll receive all guidance real time. Project starts asap.
Will discuss over chat i have lot of work to discuss
Inventory management on a mobile platform (ANDROID & IOS). -User restrictions -cloud based -csv import & export -weight tallying
I want a desktop window app for accounting & inventory management. All data should store in local sql DB. App should be Similar to [kirjaudu nähdäksesi URL:n], with same feature, Excluding GST feature, all should be same.
Construction business and we use Excel to create estimates. When creating estimate for complex projects we often create multiple tabs on same worksheet (create copy of original) to mock up different options for customer. Would like to use VBA to create a 'Comparison' tab which shows the highlighted cells (yellow) for each of the tabs on file. I have
In my company, we use a macro PPT and EXcel to help us copy/paste elements ; we’re experiencing bugs and need the support of an expert in Microsoft VBA programing to refactor in full the current macro. Need a native French speaker to run the project.
I am on Microsoft Visio 2010. I need a module written to sort all of the sheets in my workbook alphabetically. There are over 300 sheets. The data is sensiti...for someone in the know, I found a guide online but couldn't get it working. [kirjaudu nähdäksesi URL:n] Thank you