...performs various calculations. Once all required values are entered the user then can push the specifically calculated values back into the Spire database via SPOKE’s current VBA code. (Spire is a full Business Accounting Application – [login to view URL] for details.) THE PROJECT This is a unique opportunity for the right person or team. Build a completely
This is for a small project to write some Excel VBA macros to copy and highlight some data from a few columns to other sheets/worksheets. Please sign the NDA, read the requirements in the word and txt documents and feel free to ask any questions you may have. Bids over the maximum project amount will be ignored. P.S. Please note that some columns
when opening workbook will probably get a debug error this workbook collects data and on collection when running it makes selection as in the races sheet. I no longer want to collect data from certain sources so needs all the links removing so as not to get debug error and remaining data collected will give me the figures I need without errors the data changes daily Please look at races sheet D...
...sheet with examples of what I am hoping to collect. The data can be found by opening the website, selecting a category (ex, "Capital Markets"), then a Sub-Industry 2 (ex. "Reconciliation Systems"), Selecting "Show Results & Filters" at the bottom of the screen, and then clicking into each company's profile to gather further information as outlined i...
I am the Data Admin for my company. I am currently interested in building a form for the comp...am currently interested in building a form for the company. I specifically want to use excel, but I also want a nice, friendly and intuitive interface. I have experience with VBA macro's. The form must be able to have as many "if" "then" options as I want.
...who can help me with the Excel tools I’m trying so desperately to create. I am looking for an Excel guru that has excellent capabilities in creating charts, formulas, macros (VBA) and who can help me with a large project cash flow workbook that I have created. Some years ago when I was working at another company, I actually created a functioning version
Epic As a project manager I wish to have a macro enabled RACI chart where I can document the tasks, roles, and responsibilities on a “RACI” worksheet. On a “Role” worksheet, a list of names, roles, email addresses along with other personnel information is entered. On an “Email” worksheet, the results of the macro would be displayed in four (4) categories; &ldquo...
Hi Milan S., I have another Excel VBA project for you, if you're interested. There is an Excel worksheet that resides on a server at work. It is shared by many people, we only want one person at a time to be in it, and some people stay logged into it for hours even if they aren't at their desk. That keeps the rest of us from being able to do our work
Python script required to OCR and Extract details from Bank Forms. OCR done through tesseract library does not read the characters / words from bank forms which has boxes to fill characters (sample forms attached). For OCR, tesseract is still to be used but algorithm is required to meanigfully extract information like Name, Date of Birth, Address, other
I would like to have someone who is proficient in excel and VBA to build a simple calendar scheduler and student enrollment forecast in my excel with the data set i have. On top of that, i need someone who is good with formulas such as index-match to assist as well.
Standalone VBA macro that will compare any two csv files based on a key column (in this case 3rd one) and create a new csv with differences (could be changes to existing rows or new rows). Needs ability to define the delimited (comma or semi-column) and ability to convert date fields into numbers
Hello, I've spent many years working in the Banking M&A Integration world and have never found an intuiti...years working in the Banking M&A Integration world and have never found an intuitive and easy way to capture, track and report on bank synergies. This contest is for the best tool that can accomplish that process for a bank specific merger.
Does anyone know how to write a small VBA code to automate a process of pulling data from a website into a spreadsheet please .. Has to be through VBA so if you don't know how to write a VBA doe please don't apply for the job ..
I have an excel vba solution that produces a text file from a spreadsheet. This text file is currently imported into MYOB AccountRight Time Sheet module and the Payroll is then prepared in AccountRight. I need a VBA programmer that will take the text file and send it into MYOB AccountRight In The cloud. So no need to do the importing. please see http://developer
I want accountant to maintain my bookkeeping and prepare the balance sheet and income statement General bookkeeping to include bank reconciliation. Preparation of accounts up year and. Must be competent in using Xero and Quickbook
Hi Milan S. You did a few projects for me a while back and they were great. I have another, if you're interested. Here's the project description: I need an Excel VBA macro that, when a button called "Midnights" (placed on a sheet called " Operator Sheet") is pressed: * It deletes the contents of cells B3 through BT on a sheet called "Shift Lead Sheet&qu...
Build a grid with 6 power plants on 5 transmission networks of the power plants output to two other transmission networks than the 5 networks. Further details will be sent via chat
Hi there, I'm currently working on a VBA code which aims at extracting the data of a particular searched address(like area, zestimate, rental zestimate, tax & year of tax). I'd like you to develop code within the next 10-12 hours. The code if accepted may lead to various other project proposals by the client. Only serious bidders required
...changes in repayment option. • Auto-Stock deduction. • Automatic Invoice and Receipt Generation. • Automatic Report Generation. • The General Cash Book / Register • Bank Reconciliation/Confirmation/Charges/Tranfers. • Personal Ledger and Passbooks for individual member. • Journal Entries. • Individual journal Adjustment. • Disposal of S...
Hi, I am using an excel documents that has a few input sheet and based on various formulas, several output files are generated. These output sheets has a few chart...files are generated. These output sheets has a few charts. The initial coding is done, however I need someone to finish it. Should be a 15-30 min job if you are efficient in vba coding.
We need a VBA developer that can interface the Excel engine with our Access database so we can run reports for our clients. We would most likely need only a few hours of work every month. Someone with applied mathematical skills and knowledge of Bloomberg would be a plus.
I have three "Saved Imports" I want VBA Code to upload each of them. When they are uploaded, I want to add the Date the information was uploaded added to the second to last column and to add the UserID to the last column (in each of the three tables). The code shouldn't run all three uploads - I want code for each. I am assuming you don't need the
Write Probabilities Questions for our Society of Actuaries Question Bank (exam P). Here is the topic: Topic: Multivariate Random Variables (40-47%) Learning Objectives The Candidate will understand key concepts concerning multivariate random variables (including the bivariate normal) and their applications. Learning Outcomes The Candidate will be able
Need new getaway payment to my shop website becouse I use PayPal, payoneer and others to receive payment but have to many problems and searching new way to make payment to my customers.
Hello, I have a lot of email addresses in excel. I need an excel VBA to send emails with a pdf attachment automatically. The text of every email is a template, but the VBA must chose the salutation correctly. Thanks for your help.
I need to attach images from a folder from my PC (I want it to be prompted while running the macro regarding which folder to select) basis multiple Option Numbers (please refer file). The macro should look for images from the folder and insert it on the left side of the column (Specified for image) and the rows should auto adjust basis image height and width.
...You do not need my Google-form. Create your own with a text-field for the e-mail and a button and make sure the script sends that e-mail to a fixed e-mail-address. 2. Excel-VBA: Again - I only want the code - I will install it and tweak it myself. The program should fetch the Google Forms data and put it in Excel. The data to be fetched is filtered
Dear Freelancers, We are looking to hire a freelancer for our stealth project for the development of a GST reconciliation tool. The brief of the project is as under: • The basic concept is to have the reconciliation between Airline Invoice and Travel Agent Invoice. The key steps that the system will do is as under: • The tool needs to have the capability
I need a VBA script written that can insert row data into MS Word and MS Powerpoint and then add an entry into MS Access. The script should prompt the user for the row's primary key (number) and then retrieve that data from the table and insert it into the word or powerpoint document at a specified bookmark location. Simultaneously, a new entry in another
to create a utility using vba, functionality of the tool - open and parse a source file (PO file, attached), PO syntax can be found from [login to view URL] - for each message to be translated, ie. the message after "msgid "/"msgid_plural", call a function convert(msg) -> just return msg in this function
Hi, Im a student looking into simple VBA Excel project. Need help on generating Sudoku 16 by 16 grid. Requirements:- - random puzzle generator with 4 levels of difficulty - comes with a solver/solution - hints or guide to solve puzzle in Bright Colours and Bold Numbers - start and stop timer - VBA Excel format - fastest timer ranking (optional) Additional
Please refer to the spreadsheet: I need to look at status, if the status is "Executed" then ignore and go to the next row. It then needs to find the latest date entered for that row, in row 2 this would be 16/11/17, it needs to then put into an array the contract number "2", then comments "Finalising contract" then the date 16/11/17 followed by the latest date header...