Vba calculator jobs
...analysis and automation using Excel Visual Basic. The primary objective of this project is to perform in-depth data analysis, create insightful visualizations, and develop automated processes using Excel's powerful features and Visual Basic for Applications (VBA). If you are confident in your data analysis skills and Excel VBA expertise, kindly submit your proposal detailing your approach, relevant experience, and a timeline for completion. Also, include any previous work samples that demonstrate your proficiency in data analysis and Excel VBA automation. I am looking forward to collaborating with a dedicated professional who can add substantial value to this project through insightful data analysis and efficient Excel automation. Should you have any question...
*** $250-$300 AUD for a simple macro development*** I am looking for a freelancer who can program a simple excel macro for my college. The specific task that I need the macro to perform is data entry automation. So basically, I have a working macro for...different institution but I need something similar. I have also uploaded a video about how this sample macro from other institution works so you can have the assistance required. The idea is to include all this information in the offer letter and get it done. The level of complexity needed for the macro is intermediate. Ideal skills and experience for this job include: - Strong knowledge of Excel and VBA programming - Experience in creating macros for data entry automation - Ability to work with existing templates and modify them...
...day. There is a tool named Reverse Square Lookup. When I enter 586 in the program it makes a list of all the 3 digit numbers between 000 and 999, that when added to or subtracted from itself its has 586 in that list. for example, 042 when its square root is added to it repeatedly it equals 586. 060 as well, along with many others. When doing the math it is necessary to utilize an 8 digit calculator. In the program are preprogrammed sets of numbers, one set are 3 digit whole numbers and another set of decimal numbers. The next next step is to search the decimal numbers lists for any list that has 586 in that list. Show the results in list form with the original decimal on top, as well as the whole number list. Not preprogrammed in the program are sets of numbers I wil...
I need to upload a WP template from theme forest and take all the information from my current website and input it I need this to be done/shown on your own server first before having access and adding it to my server. I also need a calculator to be added to a page. Very simple work how much would this cost and how long would it take ?
What do I want to get. When we receive an email in a specific folder of our Outlook, I want a VBA feature to extract the data that I will specify later and insert them in the appropriate fields of an Excel sheet. The functionality must always be active and compile the Excel file with the information automatically extracted upon receipt of each new email without duplicates. The Outlook Folder where the emails in question are archived with a rule is called “Assegnazioni GOL”. The exact location of the Outlook folder is: OutlookPosta in arrivoAssegnazioni GOL For each of the records created in Excel, there must be the possibility, through a button positioned in correspondence with the record, to print a form that contains the fields of the record and other information ...
ACHTUNG: Ich arbeite nur mit Freelancern aus Europa zusammen, vorzugsweise aus Deutschland, Österreich, Schweiz. Es soll ein Makro erstellt werden, welches X Word-Dokumente auf Basis des zur Verfügung gestellten Templates sowie der Excel-Datei erstellt. Hier die grundsätzliche Funktionsweise: -Jede Zeile in der Excel-Tabelle = Datensatz zur Anpassung des Templates -Nach Bearbeitung wird das Template unter dem Dateinamen in Zelle C3 gespeichert, beim folgenden Dokument C4, usw. -Danach wird die Ursprungsversion des Templates erneut geöffnet und der nächste Datensatz abgearbeitet. -Das Makro soll beliebig viele Zeilen in der Excel-Tabelle verarbeiten können, also immer komplett bis zur letzten gefüllten Zeile durchlaufen, auch wenn die Tabelle wächst...
I am looking for a freelancer to develop an Excel capacity/scheduling tool for my projec...someone who is flexible and can work with me to determine a timeline that works for both of us. While I don't have any specific formatting or color coding requirements, I do have a suggestion that I would like the freelancer to consider. I will provide more details on this suggestion during the project kickoff. Ideal skills and experience for this job include: - Advanced proficiency in Excel and VBA programming - Experience developing capacity/scheduling tools or similar projects - Strong problem-solving and analytical skills - Good communication skills to understand and implement my requirements If you're interested in this project, please provide examples of similar work you ha...
I am looking for a VBA expert who can create a code for Excel 2016 or later to detect the language type in a cell and then convert it to English. The ideal candidate should have experience in VBA programming and be familiar with Excel. The code should be able to detect any language type and convert it to English. Accuracy and efficiency are key requirements for this project.
Excel: We need to prepare Gantt chart, further need help with formulas and formatting for performance tracking. Power BI: Create Dashboard and need to link Excel to Power BI, Updating in Excel will populate result in Power BI. Please refer to the attached tracker sheet of excel for your reference.
My project requires an Excel VBA solution to aggregate data in order to generate useful insights and reports. The main purpose of the data aggregation is to analyze trends. I already have existing data that needs to be aggregated, so I am looking for an experienced Excel VBA developer to take care of the task. The preferred output format should be in the form of spreadsheets, meaning that any information collected must be presented in a neat and organized format. The Excel VBA solutions must be designed to be flexible and responsive to changing inputs and criteria. To ensure the accuracy of the results, automated processes need to be developed to ensure data quality. In addition, the Excel VBA must be programmed in a way that allows for easy expansion and future...
I am looking for a skilled developer to add a SIP calculator to my website. The goal of the calculator is to calculate returns on investment. Users will interact with the calculator through a simple form. I have design requirements for the calculator, as it needs to be user-friendly. Ideal skills and experience for this job include: - Proficiency in web development languages (e.g., HTML, CSS, JavaScript) - Experience in developing calculators or similar interactive features - Strong understanding of financial concepts and calculations - Ability to create a visually appealing and user-friendly design
We are looking for an 5+ years of experienced Power Platform Developer with strong technical and communication skills. This position is for remote work from India. You will work along with a...normally be hosted in SQL, SharePoint and other data sources and cloud platforms. Individual should have demonstrable experience with the Power Platform, SharePoint, O365 and Azure. The Power Platform Developer will have good knowledge of the following systems and technologies Power Apps, Power BI, Microsoft Flow, SharePoint, Office 365,SQL,Azure,Azure Dev Ops is desirable, Json and PowerShell, VBA Visual basic for Applications, Qlik knowledge is desirable Good communicator, Ability to translate business requirements into solutions Follow through from inception to delivery and handover to ...
...our online cosmetic shop that is tailored to women and has an interactive shopping cart. We are open to additional features, but we are not sure exactly which ones we need - that will be up to the developer's expertise. The website should have all the standard features of a basic shopping cart, including payment processing systems, customer registration and login, product search, shipping rate calculator, etc. We also expect the website design to be attractive and easy to navigate for customers. It should appeal to the target audience of women and be optimized for mobile devices. Lastly, we need the website to have features that will help us to market our products, such as loyalty programs, coupons, and promotional campaigns. We look forward to working with a Freelancer to...
Hi, I need a personolised cable size calculator for my website, based on the html in the attached file. I want the calculator to look similar, however with changes made so it looks different to the original due to IP issues. It should have the exact same inputs and outputs and look similar with a light blue theme. Please read through the code before offering your services, i do not want external servers, all calculations should happen in the embed htm code from my website, no server. These are other examples, which are also ok
Im going to try to explain I need help generating a formula that will work for data set of 2000 rows and it should be fast. The solution can be VBA or excel formula. First formula is highlighted in column G The formula will need to do the following. I need excel to generate the results taking into consideration the description in column c. The reason why I need the formula to look at the description because the names could be sorted in different order. Currently my formula just reference cells but I want it look up the value based on the description in C (Unplanned Energy+Unplanned X)/(reg-Planned Energy) second formula: Using the values in column G I need the formula SUMIF based on two conditions it will need to sum the previous 18 months including the current and the months...
...Amazon Revenue Calculator in Canadian dollars, please follow these instructions: 1. Open a web browser and navigate to the Amazon website for the Canadian marketplace by visiting "". Make sure to use a Canadian postal code, such as M4N 0A2, to ensure accurate product availability. If you don’t use a Canadian postal code, the product may appear as out-of-stock. 2. Locate and access the Amazon Revenue Calculator. You can usually find it under the "Sell on Amazon" section or by searching for "Amazon Revenue Calculator" in the search bar on the website. You can enter/use it as a guest. You have done it before. 3. Enter the ASINs in the calculator in the desired order. 4. For each ASIN, click on the corresponding product descri...
Develop vba code and power query to scan pdf files in folder, log specific data into excel table and then move each file to a destination folder depending on its content. The pdfs are all structured medical reports containing patient name, id, phone, mrn, hospital etc. Hospital names need to be mapped against a hospital definition table to identify the destination folder (by hospital) for each pdf after processing. Here is use case. 1. User downloads bunch pdfs everyday (or whenever) to folder "feed" (folderdefined in control sheet) 2. Run macro 2.1. Macro reads all files in the feed folder. And process one by one. 2.2. Data scanned from file logged into ledger table with all fileds. 2.2.1. The hospital name is cross-referenced with hospital directory (table) and use...
Project Description: Create a streaming asynchronous custom function in VBA for Excel - I am looking for a skilled developer who can create a custom function in VSTO that can be used in Excel. - The function should be designed to accept multiple inputs. - The desired output of the function should be multiple values. - The custom function needs to be streaming and asynchronous, allowing for real-time updates and calculations. - The developer should have experience in VSTO, Javascript, VBA programming and be familiar with Excel functions and formulas. - Knowledge of streaming and asynchronous programming techniques is required. - Attention to detail and the ability to meet deadlines are important. - Good communication skills and the ability to understand and follow instruction...
This website will manage packages that’s arrive at the US warehouse until it is handed over to the airline for international shipping. Website should include: package tracking shipping rates calculator Customer registration for account Customer invoice creation and payment system customs information, online management of shipments. Examples of popular logistics websites include UPS, FedEx, DHL, and USPS.
Hi, How to determine the cells in a range based upon Font Size and Font Name? For example, CurrentRegion or UsedRange, how what cells have certain Font Size or certain Font applied? For example, you have a contiguous range of cells. 1) How many different font sizes in that range? 2) How many different fonts used in that range? Perhaps, Filters can help? As little looping as possible; preferably none. Solution should be as efficient as possible.
I am in need of urgent assistance with a minor issue in my Excel VBA code. Issue: The code has a logic error that needs to be resolved promptly. Timeline: I need the issue resolved within 24 hours. Ideal Skills and Experience: - Expertise in Excel VBA programming - Proficient in debugging and resolving logic errors - Ability to work under tight timelines and deliver results quickly.
I need a simple macro similar to lookup function that when I press Crtl+W, it takes some numbers from a sheet and updates those numbers in other sheets. I need this project done today as soon as possible. Doesn't take long. When you see the attachment, please send me a message and let me know when you can finish this task. Thank you
...day. There is a tool named Reverse Square Lookup. When I enter 586 in the program it makes a list of all the 3 digit numbers between 000 and 999, that when added to or subtracted from itself its has 586 in that list. for example, 042 when its square root is added to it repeatedly it equals 586. 060 as well, along with many others. When doing the math it is necessary to utilize an 8 digit calculator. In the program are preprogrammed sets of numbers, one set are 3 digit whole numbers and another set of decimal numbers. The next next step is to search the decimal numbers lists for any list that has 586 in that list. Show the results in list form with the original decimal on top, as well as the whole number list. Not preprogrammed in the program are sets of numbers I wil...
Hi, Im looking for vba to help on repetitive task, I got a master file with worksheet (rate), and I want to copy and update other file worksheet (rate), all the excel file is in a same folder. So normally I will open the master file, copy all data from the worksheet (rate), and paste it into other excel file with the same worksheet name, which is rate From master file, copy the whole worksheet in worksheet rate But in other file within same folder, there is existing worksheet rate, I want to update the worksheet
...research, bounce ideas etc. on an as-needed basis. You do not need to be an EXPERT LEVEL in the following areas but you should have enough knowledge and hands-on experiences playing with them: Electronics: Arduino, Raspberry Pi, ESP32, schematic capture, circuit simulation, pcb layout, circuit design, IoT, Home Assistant, 433Mhz RF modules etc. Computer: HTML, CSS, JavaScript, Python, MQTT, C, VBA, Excel, Photoshop, video editing etc. CAD: 3D designs, 3D printing, The rate I am offering is US$10 per hour, billable in 15-minute increments because sometimes I just have few simple questions to ask. Specific projects can be agreed upon separately. Your age does not matter as long as you have dabbled in a lot of electronics, mechanical stuff, computers, web etc. You should ha...
Hi, I need a personolised cable size calculator for my website, based on the html in the attached file. I want the calculator to look similar, however with changes made so it looks different to the original. It should have the exact same inputs and outputs.
Ideal Skills and Experience: - Proficiency in VBA programming and Excel macros. - Experience in working with dates and data manipulation in Excel. - Familiarity with CSV file format and data export. - Attention to detail and ability to accurately count and reformat data.
I am looking for a freelancer who can help me with a VBA project. The main task involves counting instances and reformatting an Excel report. Specifics: - The data that needs to be counted is in the form of dates. - The output report should be in CSV format. - The type of counting required is to count the instances of each date. Ideal Skills and Experience: - Proficiency in VBA programming and Excel macros. - Experience in working with dates and data manipulation in Excel. - Familiarity with CSV file format and data export. - Attention to detail and ability to accurately count and reformat data. If you have the necessary skills and experience, please submit your proposal.
I need at automate a spreadsheet quickly. I need to reformat the attached. The output should read names and number of time stamps. Will need step by step help. Simple project with quick turn around.
I am seeking to create a nutritional macro calculator that will focus on helping me achieve my goal of creating meal plans for my clients in a time efficient manner. I have an existing database on excel that I made by manually transferring data using an app called MyFitnessPal, this app gives a break down of calories, carbs, fats and proteins in each food. My current excel document is quite basic and therefore time consuming to input data as it involves a lot of copying and pasting of data. The ideal excel document would have a sheet of data for each food that i can enter manually from the app, and a further 3 pages one for each meal throughout the day. When I go to enter a food into a new meal I will select a tab and a drop down will appear of all the foods and when i select the f...
Looking for a skilled VBA coder proficient in Excel automation to streamline our data processing and reporting tasks. As a freelancer, you will be responsible for developing efficient VBA macros and scripts to automate repetitive processes, manipulate data, and generate customized reports. The ideal candidate should have a strong understanding of Excel functions, formulas, and VBA programming techniques. If you are a detail-oriented and reliable professional with a proven track record of delivering high-quality VBA solutions, we invite you to join our team and help us optimize our Excel workflows.
Complete the UI design of an excel/VBA, access/SQL pay app. User's download the standalone private app to their desktop. They can enter time and pay details to predict pay to compare with actual. The app handles complex pay structures including differentials. Must show samples of your design work. Must communicate via Zoom. Must have, pay statement, time sheet, payroll, earnings and closely related experience. App must be designed to be easy to use and user friendly. Compensation method and amount to be discussed. This is NOT a hand holding or teaching job. You must have proven top-notch experience. NO AGENTS!!! THIS IS NOT A WEB OR MOBILE APP. Must speak fluent English.
Preconstruction Real Estate Website I am looking for a developer to create a preconstruction real estate website with the following features: - Interactive map of available properties - Property search functionality - Mortgage calculator The main focus of the website will be to list properties for sale. We plan on listing 1-50 properties on the website. Ideal skills and experience for this project include: - Proficiency in web development languages (such as HTML, CSS, and JavaScript) - Experience in creating interactive maps and property search functionality - Knowledge of real estate industry and mortgage calculations Please provide examples of previous similar projects when submitting a proposal.
Seeking developer to improve the crypto trading calculator by implementing exponential/algorithmic model for optimal subsequent trades. Excel/Python skills required. we need to develop a new exponential/algorithmic model for placing subsequent trades in an optimal way, implement it in a spreadsheet or code, and add backtesting capabilities. I would be happy to collaborate on designing and implementing the new model based on these requirements. will send the details in messages, only experienced developer should apply
1: to automate to send a report with excel file information 2: send report based on excel file: customer back order ; expected quantities to be received in stock on the month 3: crear a dashboard
I have a spreadsheet written in Excel which is complete, does not use VBA, and has been working successfully for many years. It does however use a complex hidden formula for calculating the current liability taking into account all annual payments arriving over the next 12 months. For example, an estimated £1200 on Christmas expenditure would contribute £100 per month, would calculate a liability of £600 after May's contribution, repeated over all expenditure items. All monthly income and expenditure items are included, as are ad-hoc items of income and sundry. Salary amounts or income streams are included. The key metric produced is the overall profit or loss for the month taking into account all liabilities and income.
I am looking for a freelancer who can help me convert an existing VBA excel sheet to a Google Sheets document. The VBA Excel sheet includes macros and I need all of these functionalities included in the Google Sheets. In addition, I have specific requirements and restrictions regarding the design of the new Google Sheet that the freelancer must abide by. This project requires someone experienced with both Microsoft Excel and Google Sheets to ensure accuracy and precision. I am confident the right freelancer can complete this project within my desired timeframe.
I am looking for a VBA expert who can amend my existing VBA code for Excel. I have the source code and I need someone to modify it to avoid "error 424" and get results. Skills and Experience: - Proficiency in VBA programming for Excel - Strong understanding of Excel macros and automation - Experience in modifying existing VBA code - Attention to detail and ability to understand client requirements
As an experienced professional, I'm looking to hire the best talent for a loading plan that involves loose pipes stacked in 40ft sea container. This plan is expected to take 6 days to complete. Moreover, I'm not sure if I need help with logistics or not, so I'm looking for som...involves loose pipes stacked in 40ft sea container. This plan is expected to take 6 days to complete. Moreover, I'm not sure if I need help with logistics or not, so I'm looking for someone who can offer their expertise and insights on the matter. i will provide all inputs, I have our current way of calculations in MX Excel. Now we need to automate so that any user can use this loading plan calculator. With the right person, I'm confident that I can get the best results, and I&...
Hello i have two online shops (both shopify) and i have a few issues with them. They both sell the same products, one of them have all the metafields with values on it, the other don't. I have matrixify app but i need help importing the metafilelds and creating filters with them. Also, i want to add an "add to cart" overlay button in collections page. I need some options also removed fro...shops (both shopify) and i have a few issues with them. They both sell the same products, one of them have all the metafields with values on it, the other don't. I have matrixify app but i need help importing the metafilelds and creating filters with them. Also, i want to add an "add to cart" overlay button in collections page. I need some options also removed from the car...
I am looking for a VBA expert who can amend my existing VBA code for Excel. I have the source code and I need someone to modify it to avoid "error 424" and get results. Skills and Experience: - Proficiency in VBA programming for Excel - Strong understanding of Excel macros and automation - Experience in modifying existing VBA code - Attention to detail and ability to understand client requirements
Have an ACCDB file that works great, but couple of forms do not open, need a VBA developer to review, fix it on a remote computer (due to data privacy we cant share the ACCDB file). If you cannot work remotely on a computer, sorry we cant work together!
My website is old and has not been supported for some years. I need someone to backup website and update the plugins on my WordPress website. I want to avoid pages not working after backup (e.g. ; In fact the calculator needs to be repaired since most rollover/mouseover on headers no longer active. I am unsure what WP version my website is currently on, but I will provide this information once I have selected a freelancer. I do not have a backup of my website before updating the plugins, so please ensure to create one before starting the project. There are more than 10 plugins that need to be updated. Ideal Skills and Experience: - Experience with WordPress website backups and updates - Knowledge of plugin updates and compatibility
Hy sir I read discription of your work post And im able to do this work fastly and efficiently I like to talk to you further I look forward to hearing from you Raj dudharejiya
Hi Freelancer, I need a jquery developer who can replicate our three finance calculator javascripts allowing us to self-host these scripts and customise how they are displayed. These scripts are all slightly different in the way they calculate and display the repayment amounts and will need to be self-contained (a script for each). A full spec of the work required will be provided to the chosen developer(s) with the possibility of additional work to custom the final product to our liking. You can see the scripts in action on under "Train now, Pay Later". Preference will be given to developers with Shopify experience who have built similar jquery calculators previously. If you
