Lisp vba aanroepen jobs
Hi I have two excel files in my sharepoint i need to match the data from another excel sheet in Sharepoint which has pivot table . so i need to match 17 worksheets from that excel data .I want some to fix by using formulas/VBA. Budget 600 INR
I have an Inventory and Sales tracking worksheet and I'd like a User Form created for it. I have created the Frames, I need you to write the code that makes it all work.
I have an existing excel file that was developed to download data from different websites and carry out company valuations. Due to changes in these websites, the existing VBA code does not work, and needs to be updated.
I have a small self written VBA code driven project that sits in an Excel AddIn and adds a custom menu to Excel on Windows, the menus has a few submenus and some basic macros ran. I need a version of the file that works with Mac Excel and don't have the time to make the amends myself
I’m looking for a freelancer to help me create a Visual Basic for Applications (VBA) code for a game of poker that can recognize flushes and all. My goal is to have an output that would code the playing results, which would include a final table for the winner and a summary report of the game. To do this, I would like the freelancer to use a data structure of linked lists and stacks, and I would like the results to be able to be saved after the game. I’m looking for someone who is experienced in coding and with VBA coding in particular and who can produce a code that will meet my needs and requirements.
Simple language training app. I have built the tool in Excel VBA and I would like to make it available as an app. If you are interested, I will provide more information.
I want a database built to house all my property listing data for the backend of an app I am building. Previously I was using excel and VBA functions to manage all data, but our datasets are getting too large and too many updates, so now we are switching to PostgreSQL and pgAdmin. I am new to all of it and don't have the time to build and learn all of it. I would like to continue to be able to use pgAdmin as my gui since I have learned a little about it already. I attached a link to a chart below that has the basic functions and rules of what I need to happen. If you have questions please let me know. I need this done
I have an existing Access app which pulls in data from very large CSV files so that I can use the Access file to pull data into Excel. I have a new format for the CSV files with the columns rearranged from the initial iteration. I need the Access app updated so that it places the new CSV data in the correct columns in the Access table. Since I have the existing Access app, whic...from very large CSV files so that I can use the Access file to pull data into Excel. I have a new format for the CSV files with the columns rearranged from the initial iteration. I need the Access app updated so that it places the new CSV data in the correct columns in the Access table. Since I have the existing Access app, which works really well, it should be easy for someone proficient in VBA a...
i have XLSX(data) + XML(image links) used as template /source of data and i have XLAM with macros ....as a result im getting XML file with all data from XLSX and XML converted to XML in certain way. what need to be done : remove XML (image links) as source and all data take only from XLSX file where added image columns with links. formatting of result XML file must remain.
Build me a simple shop with Excel VBA HTML and Java. I need specialist for the coding combination, I need very simple and clear code and simple and clear function. Pls give me your quote. Non-disclosure Agreement Agreement and Intellectual Property (IP) Agreement obligatory. BR
I am looking for an experienced VBA Excel programmer to help me with a project that requires data entry automation. The project is of an intermediate complexity, but I need the programmer to incorporate user interaction and feedback into the task. The project must be completed in a quality and efficient manner. Depending on the programmer's skillset and abilities, additional tasks may be added to the project. If you are interested in tackling this project, please contact me for more details. Thanks for your time!
We have developed a series of VBA routines that convert data in excel to a PowerPoint presentation. However, the VBA code needs to be "industrialised" and made cross-platform to be used on mac or windows. The initial work is urgent, but there will likely be follow-on work as we refine or add requirements.
We are looking for an experienced Excel VBA developper to create a Cutting stock optimisation Macro in excel. The goal of the project is to develop an efficient algorithm that sorts and maximizes the uses of our stock based on parts required. The objective is to take in data on Line 10. Sort the parts in order to maximize the bars (220) Output data on line 17 to 47. There are special parts that need to be marked as special after the output. The algorithm should handle up to 30 full bars or up to 150 parts. I want the code to run on one click of a button. The idea is similar to this: Thank you
I'm looking for someone to code a project in Visual Basic for Applications (VBA) that will open URLs using Excel, and save the PDFs that come from the URLs to a certain location. The project needs to be fully automated, and open one URL at a time. I need to have the file in a way so that I can edit any of the parameters myself without needing any additional coding. The project also needs to be able to save the PDFs that come from the URLs for later viewing. This is an important project to me, and I'm looking for someone with the right skills and experience to complete it. Project needs to be completed within the next 4th of April 2023.
I am in need of a VBA developer with webscraping skills to create a VBA macro for a project. The VBA developer should have intermediate level expertise and be proficient in MS Excel VBA. The project involves building an automated VBA macro that can scrape data from the web, extract it and store it in a suitable format. The macro should be able to pull data from multiple webpages and process them efficiently. Additionally, the macro should also be able to parse HTML documents, identify useful data and process them accordingly. The desired outcome is a program that can be used to robustly scrape data from the web in an automated way, and store it in the desired format. The project requires the developer to apply their skills to create a customised produ...
...candidate will have sound knowledge of Excel features, VBA, and will be a problem solver in the IT environment. Responsibilities: • Develop a code to identify the computer where the Excel tool will be used and obtain the PC's serial number with the computer owner's agreement. • Create a VBA code that prevent tabs to be viewed without activation key. • Create or source a key creation tool to unlock the Excel document once pc’s serial number matches that obtained in step 1. • Write a macro or VBA into the Excel document that will validate the serial number on the computer trying to open the document and enable it to open, use and operate the Excel document. If that fails document will not open and cannot be viewed. • Develop a ...
I have details and files.i need excel VBA is simple make within vba code. deadline Tomorrow max budget 10-30
I am looking for a VBA developer to help me create poker hands for my project. It will be modeled after the game Texas Hold'em and will require the development of a suit class to help display the hand strength. On top of that, manual review will be used to analyze the hands, without relying on probability-based analysis or optimal strategy determination for this project. This project is time-sensitive, so the ideal candidate should have some experience with poker programming. I'm looking forward to working with you!
Looking for some to create a Macro that reads an order form and creates a csv file to be used for import that contains a column of product numbers and units ordered. The macro needs to have an execute "button." Upon execution the macro reads Column G and Column N in the attached order form, looking for any product that has a quantity >0 ordered and adds that product number and number of units ordered to the new CSV file.
I'm looking for an experienced freelancer to help with an Excel VBA project. The project involves working with existing data, which I can provide. The desired output of this project is a macro enabled report. I'm looking for someone who is an expert in VBA programming and Excel, who is able to take the existing data and use it to create a macro enabled report that meets my specific needs and requirements. I require a professional, who has a good understanding of the VBA programming language and Microsoft Excel, and is able to complete tasks quickly and accurately. Experience with creating charts, tables and other visuals will be beneficial. I'm hoping to find a freelancer who has the right skills and experience to complete the project within the agree...
...advanced models and know how to make excel formulas efficient. Efficient knowledge examples - I will never use vLookups because it's not efficient and will wreck models, there's better formulas. - It's better to incorporate boolean logic to say 1=yes, not have a million =if(test,'true','false') formulas. Financial Concepts - IRR, xIRR, NPVs, xNPVS, joint-venture waterfalls, etc. I have not used VBA in models yet, but may in the future. The projects are ongoing and about 5-10 hours/week. I have a lot of examples we can reverse engineer portions Attached is an example of the quality of modeling and formulas in excel and complexity I need help creating. We will collaborate with voice and screenshare a bit to communicate in real time, so p...
Hello! I am looking for someone to help me with an existing VBA script for Excel and Outlook. Specifically, I need help completing an automated script for both programs. I currently have a partially completed script, so the work isn't from the ground up and much of the foundation is already in place. I'm looking for the right freelancer to take on this task and help me complete the script, ensuring that it works as intended. If this sound like the project you're interested in, please reach out - I'm excited to hear from you! If you can communicate in Chinese, it will be an added bonus. Thanks!
Need a simple Access UI to connect to the back end sql server databases using 1) ADO Connection 2) Ability to Save the connections in the Local Database 3) Data Select and DML operations 4) Pass Through Queries Execution
I need vba expert who will design my excl font page as my sample with data scraping from yahoo
Hi, need some help to do arrange some data in certain format where there is some vlookup and filtering. This has to be done in VBA code in Excel.
...is not the same, it needs to be changed to red. (see my picture) Example - 2. Mark "B8" has a diameter of 25 but "PAP" has a size of 25 x 25 x 32 (WRONG TYPING ) When I type incorrectly in the pap area, "BULL TEE" should appear in red.. (like this “ 25 x 25 x 32 “) Pipe DIA and Bull Tee's Last Letter must be equal; if not, it must be red. (see my picture Can you do all rows in excel vba ...
I am looking for a VBA Expert who can help me with a project that requires coding macros. I have a specific goal in mind that needs to be achieved and I would need the expert to work on it for 1-3 days. The right candidate should be good at Excel and have experience with dashboard generation. The below is the sample project requirement. You will be interviewed based on your performance to provide resolution to below illustration. Whomsoever- want to apply create the macro in attached file ''compare data" two data and bring difference in other tab. It should be professional and can use dashboard or chart..
I am looking for an expert in VBA coding and Excel that can help me automate a project. In particular, I am looking for someone to help me code a project that has an intermediate level of complexity. I do have a rough idea of what I would like to achieve but I am open to suggestions to make the project as efficient and effective as possible. Prior experience with Macros, Custom Formulas, and VBA automation is required. Please complete the attached sample project for further interviewing process. To compare two data in which - The SSID is unique in both table and you need to generate difference of result in separate tab. You can create dashboard also of it to make more interactive.
I need a roster which automatically populates excel according to multiple employment conditions and operation requirements. I have already written the excel formulas. I need somebody to convert the formulas to VBA.
Have a code that throws an error message while its doing a while do loop. Just need a VBA code expert to resolve this. After that, there will be other subsequent work related to VBA coding.
I am looking for a freelancer to create a VBA code to create charts and do complex math calculations. This project is for personal use, and I require an advanced level of complexity for the code. The project must be done in VBA and no other programming language. If you think you are the right person for this job, I'd love for you to apply.
first page complete with the ability to add stocks. I provide the template. You have one sheet stock symbol graph. I asked for a separate tab or many tabs. When you add a stock new tab of monthly, yearly 1,5,10 years of data. Look at my example file attached.
I need to develop a plugin (tool) in Revit to help architects check their design to see if it is in accordance with a specific building code including colours, materials, shapes, family etc. Also, develop some specific family for doors, windows, screens for the facade etc. The candidate programmer needs to be familiar with Autodesk Revit and its Autodesk SDK, VBA, .NET, C#
Skills Required: - VBA - SQL - Any automation skills preferred! (python, google apps scripts) Deliverables: - develop an excel reporting solution that connects to our data warehouse and updates a set of charts and tables that we will work together to design. - we need to be able to automatically generate copies of this report for delivery to multiple clients, where the only difference is the data table connection (within the same database). Scope: - initially, we will develop 1-2 reports for a trial period. following that period we have up to ~30 excel templates that will need development, and may have additional opportunities for adjacent automation development work. When applying: If possible, please include an example excel report that you have developed in VBA that wou...
i need multi system on excel VBA code adjust
I'm looking for a software solution for my project. The scope of the project is small, so I'm looking for something relatively easy to implement. I'm not sure if it should have customization options or not, but it should be able to handle the task. The project is to create a multi-system and the result should be a coloring of the cells and line alignment that looks different. I'm looki...multi-system and the result should be a coloring of the cells and line alignment that looks different. I'm looking for a software solution that is either cloud-based, on-premise or a hybrid. It needs to have reliable features and should be easy to use. The pricing should be within my budget as well. I look forward to working with you to create the perfect solution for my needs. Mus...
Note: Due to security concerns,...Performance") located in "C:UsersjwthuOneDrivePPT FilesFY 2023" Each file contains about 7 defined Custon Slide Shows (29 total among the 4 files) The intent of the coding is to print each slideshow as a separate PDF The code shall empty the target folder ("C:UsersjwthuOneDriveGroup Presentation Emailings"), print the PDFs, then close the ppt files The code will be run from a local VBA PPT Module Print specification: 1. Print to folder "C:UsersjwthuOneDriveGroup Presentation Emailings" 2. Title of slideshow to be printed in title (header) of every page 3. Title of slideshow to be title/name of PDF file 4. Print Settings: "4 Slides, Horizontal, Handout, (4 slide...
Same as title. More details as discussed on chat. Expect quality work.
I need to send 250 meetings invites to different external users with different attachments . Need vba script so as to automatically send invites via excel from outlook .
I have Greyhound Racing data for many tracks in separate sheets per year, these being 2018 all the way through to 2023. I need this separated into individual sheets per track for UK, Australian and New Zealand venues. I attach an example for UK venue Crayford, a list of the tracks/abbreviat...separate sheets per year, these being 2018 all the way through to 2023. I need this separated into individual sheets per track for UK, Australian and New Zealand venues. I attach an example for UK venue Crayford, a list of the tracks/abbreviation and also a sample of the 2023 data, the other years files are over 25MB so cannot attach. This is a simple copy and paste exercise mainly but someone with VBA skills may be able to automate it quickly. There will be possible 70 sheets required a...
I am looking for someone to help me get my Excel document in order. The content of the document is complete, however the format is all over the place. No VBA Script please. The document has around 19 pages + 1 Index Page. I must be able to create new pages from the existing pages and yet retain the functionalities as described The Index page is fine except for trying to fit in the company logo onto it. Note: <<MyCompanyName>>, <<ProjectName>>, <<Job Number>>, <<Client>> are used in other pages. Key objective of the formatting on all pages except Index Page are as follows: 1. Have a Standard Header 2. Width to fit on single A4 sheet. You are welcome to propose either portrait/landscape orientation, however this must be consistent th...
I am looking for an experienced freelancer to build an Google Sheet based on Excel and macro. Script must save the google sheet with a new name and export a .csv file. File attach is excel Experience with Excel, macros, and Google Sheets will be essential for this project. The successful freelancer should have skills in Excel, VBA Macros, and working with Google Sheets. They should have experience converting data from an Excel format to a Google Sheets format, and be able to provide a demonstrated history of successful conversion projects.
I am looking for help with correcting an Excel VBA macro that I have already created. Specifically, I need help with the output. I am also looking for assistance in debugging the code. If you have any experience with Excel VBA macros, please feel free to respond to this project.
I need a Vba code for cylinder heating. I am looking for an experienced programmer with expertise in Visual Basic for Applications (VBA) to create a system for cylinder heating. Thanks I NEED IT URGENTLY CAN YOU DO IT PLEASE LET ME KNOW.
I am looking for an experienced and knowledgeable freelancer to create a macro using VBA language, which will be used in Word. The macro should be able to make all bolded text into the table of contents. The macro must be highly efficient and work reliably; I am looking for someone who has a proven track record with these types of projects and can get it done quickly. If you think you have the skills and experience necessary to complete this project, please get in touch. I look forward to receiving your proposals! I'm only will to pay $40 so if that is not in your budget, please don't apply.
need vba code for a project requiring several maneuvers
I am looking for an experienced programmer with expertise in Visual Basic for Applications (VBA) to create a system for cylinder heating. This code must be able to receive and process user input, as well as present data visually. The deliverable must showcase your proficiency with VBA and should be of the highest quality. If you feel that you are up to the task and possess the necessary qualifications, I welcome you to submit a bid.
I am looking for an experienced Excel professional to help with data entry, data validation, VBA & macro development. The data entry will be a mixed format, requiring manual and automated input. The data will also need to be validated according to an established date range. Additionally, I would need assistance in designing macros to help automate job tasks. If you have experience in these areas and are interested in this project, please don’t hesitate to reach out!
I am looking to hire a freelancer to help me with a VBA Project. The main purpose of this project is automation, so I will be providing the parameters. Specifically, the data to be automated will be coded data. I am looking for an experienced professional with a solid background in VBA programming. It is important to me that the data is accurately and efficiently automated in accordance with my specifications. The freelancer should also possess excellent problem-solving and communication skills. I expect to provide detailed feedback when necessary during the course of the project. I look forward to working with an expert VBA programmer who can help me achieve my goals. If you have the necessary skills and experience, please get in touch with me.
need a expert who will yahoo data Quite to excel vba