Vba exel projecttrabajos
I want an Excel VBA macro that recognises the data from "Tabelle1" and inserts it in the table "Mitgliederliste" in the next free row. Macro sequence: 1. open "Tabelle1" 2. read values from the text in "Tabelle1" and save them into the correct variables. For example: Vorname = "Kathrias" Strasse_und_Nr = "Brüderhdfsofweg 9" Variables: Firma, Vorname, Nachname, Strasse_und_Nr, PLZ, Ort, Telefon, Mail, Mitglieder-Art, Bemerkung 3. Search the next free row in the table "Mitgliederliste" 4. save the values of the variables in the table "Mitgliederliste" in the free row.
Project Title: Excel Expert with VBA for Data Visualization We are looking for an Excel expert from India who is proficient in VBA and experienced in data visualization. Specific Excel Tasks: - Data visualization: The main focus of this project is to create visually appealing charts and graphs to present the data in an easily understandable format. Deadline: - The project needs to be completed within 2 hours. Skills and Experience: - Expert proficiency in Excel and VBA is required to efficiently handle the data visualization tasks. - Strong understanding of various charting techniques and visualization best practices. - Excellent attention to detail and ability to work with large datasets. - Previous experience in creating dynamic charts and ...
I am looking for a freelancer who can help me with an MS Excel project that involves cost monitoring for construction projects. I need someone with expertise in creating dynamic tables and statistical analysis function 'FORECAST' and the ability to develop charts and graphs for data visualization. Specific requirements for the project include: - Creating dynamic tables, specifically dynamic number of table COLUMN's based upon project duration - Utilizing statistical analysis functions in Excel, specifically FORECAST, using budget vs actual vs forecast costs - Creating charts and graphs to visually represent data - Implementing simple Excel functions for cost monitoring Ideal skills and experience for the job: - Proficiency in Excel, with a strong und...
I am looking for a skilled professional who can help me with custom Excel Ribbon VBA Python project. The main tasks that need to be accomplished include creating custom functions. I have a specific deadline for this project, and I need it to be completed within a week or 10days. I am in a need of an expert in Excel Ribbon VBA Python Skills and experience required for this job include: - Proficiency in Excel Ribbon VBA Python - Strong understanding of custom functions - Ability to work within tight deadlines If you have the necessary skills and experience, and can complete this project within the specified timeframe, I would love to hear from you.
I am looking for a skilled web developer to convert a VBA Excel application into a WordPress web application. I need all the features from the VBA Excel maintained in the web application, and a tight deadline of within 1 week for completion. I would prefer the web app to be built on WordPress, however other platforms like Shopify or a custom-built from scratch would be considered. The web developer must have an in-depth understanding of both VBA Excel and WordPress, and a proven track record of converting VBA Excel into web applications. If you think you have the necessary experience and trustworthiness for this project, I look forward to hearing from you.
I have a requirement where if any duplicate rows are found i need them to be copied to the target sheet and the values to be added
I'm using to send emails from a microsoft access app. This uses VBA to send via command line. Website was recently moved to WIX and email opperate from gmail workspace, can not get email working. Not sure about how to configure gmail workspace to allow or parameters for I have had it suggested that an application to replace the can be easily created. Looking for someon who can quickly do this for me.
I am looking for an experienced de...reports. Skills and Experience: - Strong proficiency in Excel and VBA programming - Experience in working with numerical and textual data - Knowledge of financial reporting and analysis - Ability to create dynamic and interactive reports - Familiarity with data visualization techniques Key Requirements: - Develop an Excel application that can handle both numerical and textual data inputs - Create formulas and functions to analyze the data and generate financial reports - Ensure the application is user-friendly and easy to navigate - Implement data validation and error handling techniques - Design the application to update and analyze the data on a monthly basis If you have the skills and experience required for this project, please subm...
I'm looking for an experienced, discreet, trustworthy, VBA programmer skilled in data analysis and manipulation to create a complex predictive system in Excel with the potential for advanced machine learning algorithms. I will provide the Excel template as part of this project, so the VBA code (13 small sections thus far) needs to be improved and further integrated into this existing environment. I'm expecting a high-level of sophistication, using the latest technologies and techniques to deliver results to a demanding standard. Therefore, the ideal candidate will be confident in their abilities as a programmer and have a track record of using VBA to create efficient and robust solutions. The ultimate goal of this project is to develop a cred...
Require an expert to create an interactive MS Excel dashboard that visually represents the financial analysis of a copmany, especially the growth ratios, solvency ratios, sales, liquidity ratios, efficiency ratios, profitability ratios, sales growth, revenue etc. And and write a 2500-word report about it, by utilisng the data for a given co...interactive MS Excel dashboard that visually represents the financial analysis of a copmany, especially the growth ratios, solvency ratios, sales, liquidity ratios, efficiency ratios, profitability ratios, sales growth, revenue etc. And and write a 2500-word report about it, by utilisng the data for a given company. The Dashboard will require Pivot tables, data slicers, the relevant custom scripts, VBA/macros. More details to be discussed in th...
...experienced VBA expert to work on linking the tables in our Excel-based financial model to our Word file. We have an extensive Excel model with over 15 Excel sheets, each containing multiple tables and charts. We need a proficient freelancer to develop a VBA code that will seamlessly transfer these data elements into bookmarked locations inside the Word report. The code should intelligently utilize bookmarks within the Word document for precise placement, incorporate robust error handling, and undergo thorough testing to ensure accurate data transfer while preserving formatting. If you are a skilled VBA professional with a proven track record in automating data transfer between Excel and Word, particularly within complex financial models, we invite you to bid o...
I want to create a mobile app that is tailored specifically to my needs. It will have advanced features and functionalities. It must have a database with high-level security measures to ensure the intellectual property of the app is protected as...advanced features and functionalities. It must have a database with high-level security measures to ensure the intellectual property of the app is protected as well as user data and information. The app purpose is business/professional use so it must be reliable and intuitive. I need someone who can interpret Microsoft VBA (Excel) as the prototype is built in VBA. Developer must have extensive demonstrated experience in mobile apps and willing to provide expertise to help make the project successful. Further details will be p...
I am looking for an Excel Macro and VBA automation expert to help me clean, format, and sort moderately complex data in Excel. The specific tasks include cleaning the data, formatting it according to my requirements, and sorting it as needed. Skills and Experience: - Strong proficiency in Excel Macro and VBA automation - Previous experience in cleaning and formatting data in Excel - Familiarity with sorting data in Excel - Ability to handle moderately complex data with several columns and rows Please note that I do not have a specific formatting style or guideline to follow, so the freelancer can decide the formatting based on their expertise. However, I am open to discussing and deciding upon the formatting style together.
I’m looking for an experienced VBA Excel specialist to help with creating macros that will interact with other applications or files. I have a detailed process flow for the macro and need help refining it. The macro should be able to interact with other Excel files and other applications as well. The project will require the individual to have a thorough knowledge of Excel VBA as well as any related applications. The individual must also have a proven track record of developing successful macros in the past. Qualified applicants should be able to explain their experience in detail. If you are an experienced VBA programmer and think you can help me with this task, please reach out.
I am looking for a skilled VBA macro coder who can help me automate tasks according to a detailed specification. The primary function of the macro will be automating tasks, so experience in this area is essential.
Very small project. I am looking for a freelancer who is experienced in Excel VBA and Python to help me interact with BigQuery, Databricks and Snowflake DB. I need guidance on what tasks and queries are possible with these databases. Skills and Experience: - Expert level of familiarity with Python and Excel VBA - Strong knowledge of SQL - Strong knowledge in ML / Predictive Analytics - Experience in creating scripts and macros in Excel VBA and Python to interact with databases - Ability to provide guidance on best practices and efficient methods for data manipulation and analysis
Hi! I'm looking to have a report automated using VBA, based on an existing Excel data. This automation process would generate a report according to my rough idea for its format, so I need a freelancer with experience in VBA automation to help me bring the idea to life. The project involves creating an efficient and automated system for generating reports based on the given Excel data. Any freelancer applying should have knowledge and expertise in VBA and report automation. Thanks for your time!
Por favor, regístrate o inicia sesión para ver los detalles.
Hello! I'm looking for an experienced MS Access VBA Developer to create a new database for a project. I have a rough idea of what I'm looking for, so the developer must be able to bring my vision to life. The timeline for this project is 1-2 weeks, so I'd prefer someone who can work quickly and efficiently. If you have the relevant skill set and experience, please reach out with any questions! Thanks. After complete Project i need design with code. Any Tamil person i need 1st choice Get name with phone number, Finance accounting with interest auto calculation, simple software require easy to use entry screen require.
I need a webpage scraping app - possibly in VBA - to scrape certain parts of webpage's search results. The scraping process delivers 5 results only and should pausable.
I am in n...code is Excel VBA. I would like the code to work on a specific website that I will provide. The type of document/file needed to be downloaded is XBRL. As soon as the project is complete, I will be able to use the code whenever I require it executing the code in Excel VBA. The programmer should have prior experience with developing web scraping code and have a good understanding of web technologies. Attention to detail is a must, as the code must run quickly and accurately in order to be effective. I look forward to hearing from experienced programmers who are comfortable working with Excel VBA and capable of developing a code that meets my requirements. Please contact me with any questions and if selected, I would be grateful for your assistanc...
I need help with an Excel VBA project that involves retrieving Historical data from Interactive Brokers via DDE. I currently have an existing code that needs to be modified, and I need it to be done within a week. The data I need to retrieve is Historical data only. Experience with both Excel VBA and DDE is a must. If you think you can help, please let me know. Thanks! More details summary below. The attached sheet is working and pulls historical OHLC stock trading historical data into Excel via VBA/DDE from Interactive Brokers' TWS desktop trading platform. The excel file is a cut down version of Interactive brokers example DDE excel sheet. The sheet currently uses a manual button click, which cycles through a list of stock codes on the Historical Data ...
I am looking for a freelancer to help me create a reusable and fillable Excel scoring form for the purpose of evaluating employees. The form should incorporate calculations and formulas for accurate scoring. Skills and Experience Required: - Proficiency in Excel and VBA programming - Experience in creating fillable forms and incorporating calculations and formulas - Understanding of data validation and error checking - Ability to suggest user-friendly layout designs The freelancer should be able to work closely with me to understand the specific requirements and provide suggestions for the layout of the scoring form.
I am seeking a professional to develop an advanced Excel sheet with VBA (if needed) for the design of concrete bridges. The sheet should follow any AASHTO standard, as specified by the client. Skills and experience required for this project include: - Structural Engineering (is a must ! ) - Proficiency in Excel VBA - In-depth knowledge of AASHTO standards for concrete bridge design - Experience in creating complex formulas in Excel - Familiarity with the design principles and calculations involved in concrete bridge design The excel sheet should have numerous complex formulas to handle the advanced level of complexity required by the client. The developed sheet should not only accurately perform the necessary calculations but also provide a user-friendly interface. ...
I am looking for a freelancer who can create VBA Macro scripts for automating repetitive tasks in Excel and Outlook. The specific tasks that I want the scripts to perform include filtering and sorting data. I already have the data sets on which the scripts will be tested. I am expecting the freelancer to have intermediate level expertise in VBA Macro. Need to automate repetitive tasks. Skills and experience required for this project: - Proficiency in VBA Macro scripting - Experience in automating repetitive tasks in Excel and Outlook - Knowledge of filtering and sorting data in Excel - Intermediate level expertise in VBA Macro
Por favor, regístrate o inicia sesión para ver los detalles.
We are seeking an experienced VBA Macro expert to correct and update an Excel sheet. In addition, another sheet needs to be created for analyzing stocks using z-score, alpha, and sharpe ratio. The successful candidate will possess the following skills: - Proficiency in VBA macros for Excel - Strong knowledge of Excel formulas and functions - Analytical skills to calculate z-score, alpha, co-integration, co-relation and sharpe ratio - Attention to detail to ensure accurate data analysis
Hey, I have a budget template that I need help with. It has multiple sheets and they're all linked together. So I need an excel VBA expert /data analyst to help me with this one thing and tell me how I can do it. When I add a row in a sheet lets say sheet 1, I want to add a new row to be added in a different sheet with a different formula and multiple other rows with different formulas in another 3rd sheet.
I have a furniture business and I need a kind of simple software to control the dispatch process... All the parts of a project has a bar code on it but during the packaging stage we need to "scan" all of these codes to make sure we are packing all components of the project. A part of that, we also need to convert pieces into volume so this program should do the following tasks: 1 - Import the .xml file with all the parts list and dimensions of each part; 2 - Create a "new project" with the imported data; 3 - During the packing process, the system should read each of the barcodes (BLE reader) of the parts and mark as "packed" to make sure no parts were left behind; 4 - While reading the parts the system will create a volume list, this mean...
Project Title: Amazon Seller Partner REST API integration for Orders and Tracking Description: I am looking for a freelancer who can integrate the Amazon Seller Partner REST API for Orders and Tracking. The project requirements are as follows: Integration with : The integration should be specifically with the marketplace. Specific Functionalities: I require specific functionalities for order management rather than full order management capabilities. Preferred programming language: The project should be implemented using VBA. Ideal Skills and Experience: - Strong experience in integrating with the Amazon Seller Partner REST API - Proficiency in VBA programming language - Familiarity with marketplace and its order management system Note: Previous ex...
I am looking for an experienced VBA coder to help me with validating data in an existing database. I have already created the database, but now need help tweaking it to make sure all the data is correct and accurate. I don't have a specific validation rule in mind, so suggestions would be welcome. The right person should be comfortable working with Access Databases and be able to ensure the data is accurate. Please let me know if you have any questions. Thank you!
As a project owner currently dealing with a data recordings spreadsheet requiring reformatting to generate a Power BI Pareto, I need help from a skilled programmer to write code/VBA to produce the desired outcome. I have selected VBA as my preferred programming language for this project and, as I'm under a certain time constraint, I need it done within a month. I also have both a sample of the existing spreadsheet and the desired final format, so the programmer can get straight away to work on the task. This project is of major importance for me, and I'm looking forward to working with an experienced programmer who will help me get the desired result.
I am looking for a automation expert to automate a specific task for me. Task: - The automation will visit to storefront in Amazon and it will click to a extension. (The extension show products' situation) we have just two filter. The automation will check them and export suitable ones to excel or txt file. Whatever is simple for you. it is not...be complicated but it is not. i can send screenshots. Simply; The task involves checking the storefront and exporting suitable items based on a filter that we will adjust. I can give rest of details if you are available for gig Requirements: - I am open to suggestions and am flexible with the approach to automate this task. - The ideal candidate should have strong knowledge and experience in VBA automation. Timeline: - Deadline ...
I have data…sometimes 100’s, sometimes 1,000’s of “rows” – data is typically from Indeed.com. Of this data, I need help with a solution that allows me to EXTRACT entire ROWS… Then I need to DELETE entire ROWS from remaining records/lines All from the Source Data, and put into another SHEET in the same WORKBOOK. I would need to do 2X…2 steps involved, after I assemble all the data into first SHEET of Excel Workbook File. First, Job Title (extract from large sheet/records, put into new sheet/records) filtered by “title” keywords Second, Employer, filtering “Employer” names – and DELETING their entire ROW/RECORD from the data AGAIN: I will have 100’s or 1,000’s of rows/records of Job Postings/L...
I'm looking for someone to help automate a Microsoft Excel project using either VBA or Python. The complexity of the tasks would be at an intermediate level. Project completion needs to be as soon as possible. I'm open to either programming language so please let me know which you prefer and provide a price quote. Thanks!
I am currently looking for a skilled freelancer to assist me with a project involving Excel automation. The specific tasks include data entry, formula calculations, and report generation. Additionally, the freelancer should be able to audit SMS as per guidelines and identify wrong characters in texts. I am flexible with the timeline but will provide access to existing Excel files so that the freelancer can understand the current process better. Knowledge of VBA code is desired but not necessary. If you are interested in this project, please do not hesitate to reach out. Thank you.
I'm looking for an Excel expert with proficiency in VBA or macro to help me with data analysis and reporting. I already have the data ready and what I need is a report in Excel document format. This project requires skills such as macro and VBA writing, automation of repetitive tasks, data analysis and reporting. The successful contractor should demonstrate the ability to successfully analyze large datasets and provide information/insights into the data. Additionally, they should be able to generate easy-to-read reports that can be shared with stakeholders. The ideal candidate would have extensive experience in data analysis and reporting and have the abilities to solve complex problems. If you are an Excel expert with experience creating macros, automating repeti...
I have an excel workbook on sharepoint that runs a macro that launches a mail merge routine from a Word Template also on sharepoint. There is a macro in Excel that calls a routine in the WOrd document. I have had to change this routine, but have introduced an error that I need help correcting. The problem that I have is that although the Excel macro appears to be running running correctly, when the WOrd macro starts it is using the wrong sheet to merge. I have noticed that when I do a manual mail merge from the Word document there are a large number of tables in the Excel file and the first one on the list is the table that the Word marco seems to be using (Cancelled courses). Program (LaunchCreateGoPack is the macro), Master is the sheet I am invoking the macro from) (CreateGoPack ...
I am looking for a freelancer to automate my costing sheet in Excel. Requirements: - Experience with Excel and knowledge of advanced Excel functions - Ability to automate calculations and data input in the sheet - Familiarity with creating macros and VBA coding in Excel - Understanding of costing and financial calculations - Ability to work with moderate complexity of the current costing sheet - Attention to detail and accuracy in automating the sheet - To lock certain Cell (customizable upon Manager’s approval) Please note that I am not sure at this time if the automated sheet needs to be compatible with any other programs.
I am looking for an experienced Excel macro coder to automate the generation of daily reports from sales data. Tasks to be automated: - Creating reports based on the provided sales data Ideal skills and experience: - Proficient in Excel macros and VBA programming - Strong understanding of data analysis and report generation - Attention to detail to ensure accurate and reliable reports - Ability to work with large datasets and optimize performance - Familiarity with sales data and key metrics in order to present meaningful insights The reports will need to be generated on a daily basis, so the coder should be able to set up a system that automatically retrieves the sales data and generates the reports without manual intervention. If you have the necessary skills and experience,...
I need a VBA macro to extract the data for fields 1, 2 & 3 only on rows marked with "L" (in column P). To populate a sheet with the data (ie. Field1, Field2 & Field3) so that I can print out using standard A4 label sheet as per sample. To use a standard A4 label label sheet 5 across with 13 rows. Thank you
--- **Project Description: Freelance Web Developer with VBA and Chat GPT Integration Expertise** We are seeking a talented and passionate freelance web developer with experience in web development, VBA (Visual Basic for Applications), and integrating Chat GPT API. The project entails the creation of two web-based tools designed for online usage. **Tool 1: Data Extraction and Formatting** We require a tool that can efficiently extract data from Excel spreadsheets and paste it into another spreadsheet, all while adhering to a format specified by the user. The ideal candidate should have expertise in VBA to facilitate this data manipulation seamlessly. **Tool 2: Code Conversion** The second tool we envision is one that simplifies code conversion betwee...
I am looking for a skilled VBA programmer to help me automate some of my Excel tasks. I am using Excel 2010 or later. I would like the programmer to provide me with a final script that will accurately complete my tasks, without the need for me to understand the process. Any experience in VBA scripting related to data manipulation, creating custom functions or automating Excel tasks would be helpful. I am looking to hire someone who is highly skilled in VBA and can provide me with an efficient and reliable script. I need the data to be imported in Excel file from tab of browsed Excel file. The importing needs to be done in required format.
...My name is Raquel Mojica, I am an expert in Power BI (file reconstruction, DAX formula changes, chart modification, KPI's and dashboards development, database restructuring), data validation and analysis, massive data management and Excel Advanced (Pivot, Advanced Formulas, graphics, commands, binaries, Excel macro programming, VBA programming). You can validate my experience in this link: https://www.freelancer.com/u/araquelus I can help you with your Power BI project. Also, I can help you with my business experience creating KPIs that can help you make long-term strategic decisions. I have knowledge and experience in: - Databases with more than 500k rows and more than 100 columns - Run DAX queries and functions in Power BI - User access security and control panel ...
I need to convert an R task to do on VBA
So I would want the code for R with the output. Otherwise I can't proceed. VBA might be sufficient but I want to work with R. I am going to give you a little more information. From the example file sent. I want to match the keywords from with the Keywords in the column 44 Keywords. So for example taking the following example (row 30) [Column 4 Title] A highly selective and sensitive disposable carbon composite PVC-based membrane for determination of lead ion in environmental samples by [Column 2 Author] A.; Mirahmadi Abbaspour, E.; Khalafi-Nejad, A.; Babamohammadi, S We can see in [Column 44 Keywords Copy1] (which is the a copy of the column 29 Keywords this was for my information not yours) the following Key words are listed: *Carbon; Environmental Pollutants/*analysis; *Ion-...
I am looking for a freelancer who can transfer the VBA code and functions from an Excel file to Google Sheets. I would like the code to be transferred with improvements, so any suggestions or modifications to enhance the functionality are welcome. The timeline for this project is normal, with a completion window of 4-7 days. All functions in the code are equally important, so they should be prioritized equally. Ideal Skills and Experience: - Strong proficiency in VBA and Google Sheets - Experience in code migration and transfer - Ability to identify areas of improvement and optimize the code for Google Sheets - Attention to detail to ensure all functions are accurately transferred - Timely delivery within the specified timeline
We have Excel space calculation tool in excel file its build with excel formulas which needs updating new formula to make it this tool work smarter and speedy Also have to create new options in excel using formulas so VBA or other excel experts needs to look into file fix necessary update I will send you excel file which needs update and instruction file for required update I need this work to be finish it today Pls apply if you are expert in excel coding and updating formulas
I am looking for a VBA expert who can help me connect MS Word and Excel and create a user interface for my project. The ideal candidate should have experience in performing data analysis and manipulation using VBA macros. Specific tasks for the VBA macro: - Connect MS Word and Excel seamlessly - Create a user interface with a specific design in mind Level of complexity of the data: - Intermediate data, including tables and charts Skills and experience required: - Proficiency in VBA programming - Strong understanding of MS Word and Excel integration - Experience in creating user interfaces with specific designs - Knowledge of data analysis and manipulation techniques using VBA macros If you have the skills and experience mentioned above, please ...
