Visual Basic for Apps Jobs

( I posted this project few weeks back. a free lancer almost completed the first task 80% but then they disappeared and cannot get a response from them despite repeated reminders) , you will start from where they stopped and the last update they provided. ------------- original project details below--------------------- Note some part of first task are already completed - Read below sending your ...

Project description will give you in message. Kindly apply.

I need a VBA Code which separates the contents of a cell based on certain markers. Text is Present in Sheet 1 in column 5. There can be around 200 rows. From columns 5 cells text has to be picked up one by one and separated into different rows. After all rows have been populated then again changes have to be made based on 2nd category of markers.

Write VBA code to summarize the table on the coversheet tab in a table below and only show the handle models that have a net requirement < 0. This table should be dynamic and refresh when the entire sheet is refreshed.

I have code on the Excel workbook. I don't know why its not running. Its the code tied to the button on the home page "Upload CMOP" (I will only pay $30 US) I need this to work

Build macros and logic in excel as per business requirements

i need to create a tool to track these information from the request of outlook

We need an Excel Macro which will update inventory by - 1. Vlookup SKU under 3 columns. 2. All Duplicate UPCS will add up. 3. Return Quantity Value.

We need an Excel Macro which will update inventory by - 1. Vlookup SKU under 3 columns. 2. All Duplicate UPCS will add up. 3. Return Quantity Value.

I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.

I have a 1-page Visio template with a limited number of text boxes used to print labels for products. I needed a script or methodology that I could use in order to fill all necessary information on a TXT or CSV file, so that the Visio file text fields populate automatically with it to avoiding human data insertion errors. NOTE 1: The proposed solution should be compatible with Microsoft Visio ...

I have a 1-page Visio template with a limited number of text boxes used to print labels for products. I needed a script or methodology that I could use in order to fill all necessary information on a TXT or CSV file, so that the Visio file text fields populate automatically with it to avoiding human data insertion errors. NOTE 1: The proposed solution should be compatible with Microsoft Visio ...

Brief: A script that runs when an email is sent from a Project Mailbox which populates a sequential number in the Subject line (replacing ### symbols) by checking the Sent Items to find the next number to use. Subject line example format: *RFI-### Enter description here Detail: I will create an outlook template, such as an RFI or Notice to Engineer or whatever it may be. Example attached. I...

We are looking for someone widely available to screen share and solve formulas on the spot and automate excel work with vba macros or formulas. Must be experienced with Excel.

I am Siddharth Dahat. I am working for an Organization and have a requirement to convert one excel data base into a Simple macro enabled excel file. I am expecting this file to be made in such a way that there is a User Interface and couple of drop down boxes to select the the criteria. Upon giving all criteria, I am expecting program to automatically filter out the data from Database and provide...

My company does its invoicing and order tracking through a fairly elaborate spreadsheet in Apple Numbers that we need to convert into Excel. At the moment its fairly easy to break so we need to lock in some formulas so its easy to maneuver. We also plan to use a web-based system in the future and need something to integrate into that when the time comes. We'd like to chat and see if you ca...

I have to track when an aircraft takes off, reaches it's highest point, and lands, which is considered one cycle. Then the same cycle has to be measured therefore, one flight could have 30 cycles. Altitude (ALT) information is found in column "I." You will see a plane takeoff at 6535 then land at the same altitude. I would like this to be done in VBA to help automate this proce...

app developers - small project - minimum price

I need someone familiar with VBA to work on the data manipulation on the MS Word file. The contain of the MS Word file are a sets of Multiple Choices Questions 1. The question body can be text or text + image 2. The answer Choices can be text or text + image The VBA should able the separate each of the questions and choices per question with some attributes linked per question (question type et...

hello, we are a company and have so far merged reports in Excel and Word itself. Now we would like to have automated this .. That means you would have to create Excel Macros or input fields Example: If I enter a value xxx, the solution or a value must automatically appear in another field. Its a bit complicated to explain, but if you have questions, do not hesitate Enclosed is already a part...

Make the necessary assumptions to complete your VBA model in a clear and easy to follow structure. When documenting your model, assume you are an investment analyst, portfolio manager, bank fund manager,... where you are introducing a new approach to analysing your client's reports by using VBA [login to view URL] want to persuade them to appreciate the advantages of VBA modelling and switch ...

Hi I am looking for a solution that takes an excel and populates Outlook calendar The solution must be automatic - i.e. as the excel is changed, the calendar automatically updates without any need to import/export the excel. Thanks

I need simple tool that will distribute 100+ Pdfs with unique name (Name and Surname) to specific folders which contain the same (name and surname). Additional functions to notify which non existing folders has been created, notify which pdfs has not been copied. Simple solution preferably in VBA.

I want to create an excel model such that costing files will be extracted per month in an actuals column and all budgeted costs for each cost center will be linked in the budgeted column - whose budgets will come in from the local excel file itself.

I’m looking to do a excel program that I can use on a iPhone. This program needs to have a clean modern look and the ability to generate course certificates from a word template that I already have. I would need the following features. Enter names, Enter dates, Trainer name with a drop-down menu, Enter phone numbers, Attending student signature electronically, I will give you more i...

I need someone to complete a project started by a different freelancer which is to create a VBA code that will filter, sort and apply formulas to csvs that contain data about poker hands. Please see the current draft of the evaluator as well as my notes about what needs to be done to complete the job.

Dear Experts, I have a requirement for the simple Excel VBA based time registering systemfor the activities at the workplace. Employee need to come and scan his ID barcode and scan the activity barcode and activity time needs to start. When he comes back scan his ID barcode, system should show where he is working. Then whenever he scans other activity, the system should automatically stop prev...

Eu preciso de um modelo 3D de algo.

Yeni bir parakende mağaza açılışında giderleri tahmin etme ve kar zarar analizi yaparak mağaza açılıma uygundur veya değildir tarzında bir rapor sunacak excel istiyorum.