i need someone to create vba function for excel.i usually copy the data from Gmail paste it into excel and manually adjust the data.i want a automation. i attached the excel.
Write the data capture screens for a customer data table that I have. The table is an .accdb table and preferably i would like the code to be written in MS access vba
As a 3D Animator, you will be responsible for creating aesthetically pleasing and believable animations that utilize the latest techni...that utilize the latest techniques while adhering to the highest standards. You will also be expected to show a thorough understanding of the principles of cinematic storytelling, composition, body mechanics, and acting. Responsibilities: Work closely with art directors and concept artists to develop designs and animation stories. Model, texture, and animate 3D assets efficiently. Utilize Autodesk MotionBuilder or equivalent software for 3D animation purposes. Set up cameras, provides proper lighting on scenes and adjust overall look of the animation scenes. Create realistic facial expressions through proper lip syncing and dialogue capture ...
Have to automate some process in excel. The task is related to VBA. Please bid only if you are an experienced worker.
Need assistance in optimizing code in VBA for automated email through outlook
An addin / VBA programming for PowerPoint in the current version Microsoft Office Professional Plus 2019 is required. complete details attached. As inspiration, you can look at the add-in Efficient Elements for Presentations, where a similar agenda function (without header in the comment section) exists: The following functions should be possible: Header in the comments section In the header of the comment area of each slide, a one-line table should be displayed, in which a title, two free fields and the display duration of the slide can be entered manually. The display duration is the same as the program-internal "after time" of the respective slide – to be seen and edited in the slide sorting. The wanted add-in automatically calculates
We have VBA code which automatically sends email based on variance in pump parameters. Need programmer who can make changes in existing code to make it compatible with another pump system. existing code will be provided to analyze the sequence & working of existing excel sheet. Programmer needs to understand the system and need to make changes so that it can implemented for sheet with different nature. Programmer can write code according to him but it should produce desired result.
A ladder code on tia portal siemens with hmi,scada and selection for plc,input and outputs for 2 very simple machines designed on inventor
I want to be able to highlight Sent emails in Outlook that have not been replied to at least once. Is there a script for this?
VBA programmer requires to update my current financial templates. Only highly experienced freelancers. Write VBA at the starting of your proposal.
Ho necessità di un calcolo dimensionale ed un progetto Inventor che rispecchi una situazione reale: un semplice azionamento tramite un singolo attuatore idraulico a doppio effetto (di cui fornirò le caratteristiche) che faccia effettuare una rotazione tra 0 gradi e 90 gradi (dalla posizione minima orizzontale alla posizione massima verticale) ad un’asta incernierata ad un’estremità. Le regole da rispettare durante la progettazione sono le seguenti: 1. l’asta deve essere incernierata oltre che all’estremità, anche nella metà della sua lunghezza; 2. quando l’asta è in posizione orizzontale, tutto il sistema di bracci ed attuatore deve raccogliersi in un volume massimo di 30cm di altezza, 200cm di lunghezza ed 80cm...
Hi, I have coded the script but it's failing with with Run time error : 429 with Active X component can't create object. The script is intended to create a new TAB by closing all the existing opened tabs. Kindly help.
Hi, Help me to use PHP / PYTHON / EXCEL VBA / JAVA/ Online 3-rd party website/products to publish 50000 whatsapp messages daily for next 15 days. **Urgent Requirement
Hi, I am in need of an Excel VBA developer to create a file that has two sheets, 'Positions' and 'OptionsChains' that pulls data from the IBKR API. The 1st sheet, Positions should contain a table that shows all open positions from IBKR for a given account, including: - the date that each trade was opened (IMPORTANT) - Symbol, Last Trade Date, Strike, P/C, Avg Cost, Market Value The 2nd sheet should retrieve all Options chain data for a given ticker including: - Able to specify ticker - All available expiration dates for given ticker - Calls/Puts, Bid, Ask, Last, Delta, Position, Open Interest, Strike I should be able to click a single button in excel to refresh the data. The data must be retrieved using the IBKR API. The VBA code must be unlocked
create the setting for prefix and path for the "save to import" button in the 2nd file like the "sheet2" in the 1st file
I need a VBA expert for a project. Details will be shared. This is an easy task so I need it quick. If this project goes well then will rehire for more work. Please bid low.
I want to create an Excel VBA code for web scraping. Here is a VBA code that I used before but it doesn't work anymore. I need fix this error. The hotel names, addresses, and dates will change, so the macro must be able to run off the data in the given cells. Ideally, the macro will use a free API from a trusted source (Google, Expedia, , etc.) However, I realize these API's may not be available. As such, data scraping from one of these websites is acceptable. As long as its written in the VBA window in Excel I need to run it directly from excel Also, if this will be quicker and is do-able, Google Hotels shows the hotel prices per night for several months at a time - would it be possible to grab two months of data in one scrape?
Hello Artist, Our company need an interior designer who knows all the softwares required for designing its ...interior designer who knows all the softwares required for designing its a daily work job so you will get big project every month. Artist should know everything from extracting builds from a plan to texture and render it in photorealistic realistic quality. Artist should also have creative mindset of designing from its own and knows walkthrough animation. Software Required : • Autodesk Max. • Autodesk CAD. • Autodesk Maya. • Lumion. • Blender. • Unreal Engine. • V-Ray. • Arnold. Down below are contact details and reference is attached about what quaity we need from artist. Send your interior designing Portfolio along w...
I am designing a product that I need to bring into 3d animation for a prototype demonstration. The product is a telescoping hand held sti...light mounted on the end that can be controlled from the handle. The 3d model needs to be animated such that when a button on the handle is pressed, the telescoping portion will extend and when another button is pressed, it will retract. Some additional buttons will illuminate the light, change light color, and cause light to blink or strobe. I have a very basic 3d design that was created on "Autodesk Tinkercad". A picture of the design is attached and I can send a link if requested. If you have an hourly rate, I am just looking for an approximation of how much time will be required to do this. If yu prefer to give a hard bid, I am o...
Need to create smart PDF's for upload into construction software
Requirements: We are looking for an expert in VBA and day-to-day responsibilities include creating VBA and macro solutions in Excel. We need someone who can support us for a longer period. The candidate will also be responsible for the below-mentioned points: 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate should have knowledge of Excel 4. Candidate should have good analytical skills and should be able to work on data management tools 5. Candidate should have problem-solving and leadership skills
We have an Excel file with vba and we need a change to multiply a valute with exchange rate
We require an excel vba template that allows us to copy html web data, paste it into excel, rearrange the data correctly, delete data we don't need and apply required data into a table along with incorporating additional columns with formulas. Scope requirements are provided in the attached spreadsheet. We require this done very quickly.
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, UMAIR
*Well knowledge about Autodesk Autocadd. *Good previous experience in drafting the project *I have handle and done lakhs for sqft project in the real time work experience. *Anybody wants to do this autocadd drawing , plan, elevation please let me know.
Hi Mamuka B., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I have created a VBA Macro in MS Outlook which, using a UserForm, gives users a choice of which folder in windows explorer they want to file emails and attachments down into. I now want to distribute this Macro as a COM add-in. I have tried creating this in VS Studio but, due to time constraints, I need someone to sort this sooner. I can provide the VBA code and User Form. I just need the functionality duplicated.
Please do not apply for this position if you are in full-time employment and you freelance in the evenings. This position requires your time during the working day can you should be a full-time Freelancer full Freedom over your time. I am looking for a project manager to help me with a variety of projects which use Technologies such as Excel VBA, asp.net, PHP etc. Most projects are managed in Trello and carried out by freelancers in freelancer.com or upwork. However you will not be communicating with developers via Freelancer you will be communicating with developers via Trello cards and or email. We also have clients engaged in some Trello cards. Typically this role will be 1 or 2 hours a day about hopefully growing more and more work through you to the develope...
Hey Folks, This is excel report which extract data from 5 different sheets and map using Vlookup.
Need to take rows in Excel and insert into 2 Mysql tables. User has already logged into an Access front end that is open and linked to the same MYSQL tables. If possible, would rather not have to do another login - or store the id/password in EXCEL vba to be able to link/authenticate to MYSQL. More details are attached.
Find Freelance Jobs 3D Modeler Jobs 3D Modeling and Rendering New Fixed-price ‐ Posted 16 minutes ago $25 Fixed Price Intermediate Experience Level I have elevations of a house designed in AutoCAD. I need the 3D model and 3D rendering of the house. I will provide the AutoCAD file i… 3D Modeling 3D Modeling 3D Rendering Exterior Rendering Autodesk AutoCAD
Create a Macro which does the following - Note excel FILE A and excel FILE B will be open at all times. When I click on “AUTORUN” in FILE B (tab BOT) then: Step 1: Copy incremental data till last sr no. (using unique Sr no.) from File A (Tab Type 1, Type2, Type 3, Type4, ) to File B (Sheet 1) e.g. Copy Sr. no. 11729 to 11737.. from File A to File B (Pls note although serial nos. end at 11737, the formulas continue in additional rows in File A) Step 2: Click on Run Whatsapp Bot in File B (tab BOT) Step 3: Copy data marked as “Error” in File B (Tab Error) Step 4: Autosave the FILE B and then Autorun Step 1 (after a defined specified period e.g 1 hour) – give me the option to change the autorun time gap - During Step 1 – only copy incremental data from th...
Create a Macro which does the following - Note excel FILE A and excel FILE B will be open at all times. When I click on “AUTORUN” in FILE B (tab BOT) then: Step 1: Copy incremental data till last sr no. (using unique Sr no.) from File A (Tab Type 1, Type2, Type 3, Type4, ) to File B (Sheet 1) e.g. Copy Sr. no. 11729 to 11737.. from File A to File B (Pls note although serial nos. end at 11737, the formulas continue in additional rows in File A) Step 2: Click on Run Whatsapp Bot in File B (tab BOT) Step 3: Copy data marked as “Error” in File B (Tab Error) Step 4: Autosave the FILE B and then Autorun Step 1 (after a defined specified period e.g 1 hour) – give me the option to change the autorun time gap - During Step 1 – only copy incremental data from ...
Before extracting the rows with empty cell in column L or N, I want to move all the cell with number in column L to the top and sort by ingredient #, and allow user to confirm that 's what they want to send to picker before they actually want to send to the picker.
I have a spreadsheet. A previous freelancer built in a date picker, which I have applied to a number of columns throughout the ‘Unassigned’ worksheet from row 3 downwards. Take columns AD, AF and AH for example. The problem I have is the date picker seems to incorrectly apply a date format of mm/dd/yyyy with a right alignment from 1st of a month – 12th of a month. It then correctly applies a format of dd/mm/yyyy with a left alignment from 13th of a month to the end of that month. I would like this to be fixed so that every date the date picker outputs is dd/mm/yyyy and right aligned and able to be counted with formulas such as sumifs and countifs. I don’t see this as a cell formatting issue because the pick changes behavior beyond day 12 of a month. The date p...
I need a VBA script pulling data from a website and putting specific data into a spreadsheet. The data is date specific so it will need to be ran monthly or quarterly depending on how often the website is updated.
I have a xlsm file which has multiple spreadsheets. I need a macro to protect all the cells that has formulas in it so that users do not edit the formula and lock all the spreadsheets.
I will Automate your two files with VBA Automation as done in previous project. By creating four buttons and five macros for each file
Copy some data from sheet 1 and paste it to second sheet but on every 3 minute and this all macros start on morning 9.15 and end on 3.30
Our project is focused on using virtual reality technology to improve the efficiency and safety of industrial automation processes. We are creating a virtual environment that simulates a real-world industrial automation system, allowing workers to interact with the system in a way that feels natural and intuitive. For example, workers can use virtual reality ...reality to simulate different scenarios and test different automation configurations, which can help to optimize the system and reduce downtime. We want to realize a VR experience with Unity and we are looking for expertises in this context in order to realize a virtual industrial context with our machineries with movements and actions in a Unity library. I attach an image of our work realized with Autodesk VRED as example of...
VBA code is required to Read TaskData tab's Table "ShapeData" and Update shape's location based on start/finish dates on the Poap Poap will contain 2 types of Shapes Milestones-shapename starting with "Milestone_" Tasks-shapename starting with "Task_" Method e.g. Loop through all the shapes(Milestone/Task type shapes only) in the Poap If Shape found, go to TaskData tab "Shapedata" table and check if the ShapeID is Found If Found , capture the start and finish date and update the Shape location based on the Poap timeline Note: Poap header month cell size could be reduced or expanded by the user, and the size need to calculated through code to figure out the shape location Please refer attached sample file
I need an excel vba script that will do the following: hide rows 8:11 if the value of cell d8 (formula) = 0. hide rows 12:15 if the value of cell d12 (formula) = 0. continue through row 735. Script must run automatically when value in d8, d12, d16, etc. changes. Should automatically hide each set of 4 rows when value is 0, and reveal those rows when value is >0. I am using Excel 365.
Hi I am freelancer with paid account but not yet got any project I am advanced excel Expert, Cleaning of excel files VBA, Vlookup PDF editing with good typing speed . How to get projects please guide me.
Currently we have a excel document that is used to produce a list of items required, based on the sqm of a house. These are items are all assigned a value and therefore a value for the complete quotation. we want this readily available for homeowners and plumbers to use and generate quotes themselves. ideally this would also fill a basket on the website of goods that customers can then amend or adjust.
Experience: Min. 10 Years Location: Washington DC, USA Note: Looking for a US H1 Visa holder/Green Card holder. Project Tenure: 1 Year (Contractual) Job Description ...and knowledge of financial data preferably capital markets Experience in Summit Application. Experience developing test cases, functional specification documentations and business requirement documents. Desired Skills/Abilities (not required but a plus): Knowledge of Summit system or any trade system Experience in Swift, Quantum and SAP. Experience in Oracle sql, pl/sql scripting Experience in VBA, C# and c++ skills or any GUI development skills Experience in Linux or Unix scripting skills bash, csh, Ksh etc Experience in Summit API or similar financial application experience is nice to have. Experience in Python ...
...qualificato per unirsi al nostro team in qualità di programmatore su piattaforma Ms Access. Requisiti: Esperienza comprovata nella gestione di progetti MS Access complessi con database MS SQL Conoscenza approfondita di SQL, VBA e dei principali strumenti di sviluppo Access Eccellente capacità di risoluzione dei problemi e di analisi Abilità di lavorare in modo autonomo e di rispettare le scadenze Ottima comunicazione e capacità di lavoro in team Responsabilità: Sviluppo, manutenzione e ottimizzazione di database Access basati su MS SQL Scrittura di query avanzate e di script VBA per l'automazione di processi complessi Collaborazione con altri membri del team per la progettazione e la realizzazione di nuove funzionalità e sol...
Hi, I have a spreadsheet that I need to create 3 to 5 macro buttons, to create a new worksheet, that involve coyping fields, extracting rows that has empty fields on a specified column, save as xlsm and csv format, & etc...
Break large MS word report into smaller reports using VBA, Python, PHP Etc. Contact me if you have solution for this.
Need Support for Data Analyst role with SQL, Alteryx, Tableau, Data Management, VBA, Snow flake
