Excel macro vba coding jobs

I'm looking for someone to organize a set of text data into categories in an Excel spreadsheet. Key Responsibilities: - Inputting text data into an Excel sheet under the appropriate categories - Utilizing conditional formatting to enhance the visual representation of the data Ideal Skills: - Proficient in data entry and Excel operations - Experience with categorizing data in Excel - Familiarity with conditional formatting in Excel

I'm in need of some assistance to develop a .NET8.0 program with expert level C# coding ability for an assisgnment. The main functionalities of the project include: * Command-based user interface Critical aspects of the project include: * User Interface: The program will run on a command line interface. It is essential you have experience in this rather than GUI/Web-based interface design. * File handling: For effective data management, we require user interface functionality. Experience in properly implementing this within a .NET application is crucial. Bringing these aspects together to create a seamless program is the ultimate goal of this project. The right candidate will have extensive experience in C# programming, specifically with .NET8.0, and a good understa...

I'm immersed in creating a Desktop Application on Visual Studio, utilizing C# as the fundamental programming language. I'm currently in need of: - Coding assistance. This task would involve closely working with my existing line of code, offering necessary improvements and additions to elevate the functioning of my desktop application. If you're highly proficient in C#, and hands-on experience in handling Desktop Applications within Visual Studio, you'd be an ideal match for this project. Moreover, excellent problem-solving abilities would be a significant advantageous point for a fruitful collaboration. Hence looking forward to working with an individual having robust expertise in C# and desktop application development.

As a client, I'm...I'm looking for an experienced PHP developer who's well-versed in CodeIgniter, Laravel, and Flutter. The primary tasks revolve around custom PHP coding, primarily in the form of integrating APIs and creating or modifying modules. Key Responsibilities: - Custom PHP coding tasks, including integrating APIs - Creating or modifying modules Preferred Skills: - Proficient in CodeIgniter, Laravel, and Flutter - Experience in building web applications - Strong background in database management - Knowledge of modern software architecture and API design Your role will be crucial in the success of this project. Your expertise and dedication to quality coding will help us achieve our objectives. Please, only apply if you have the necessary skil...

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Su...

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

Please Sign Up or Login to see details.

Different Website & App Projects Bid ONLY if you have Experience with Coding! ==> Begin your Bid with "OK" Bid for your price in hour!

I'm in need of a professional designer to create a sophisticated and elegant newsletter using MailChimp. The primary focus of the content will be company updates. I'm seeking someone who has: - Proficiency in MailChimp usage - Experience with corporate branding and messaging - An ability to create designs that are both sophisticated and engaging The ...someone who has: - Proficiency in MailChimp usage - Experience with corporate branding and messaging - An ability to create designs that are both sophisticated and engaging The ideal candidate must have a portfolio of similar works. The goal is to ensure that the aesthetic is elegant and reflects the professionalism of our brand. Candidates who understand minimalist yet sophisticated email design coding will be given pri...

I'm seeking a skilled Arduino developer for a basic level robotics project. The primary tasks for this role will include coding and troubleshooting hardware. Key requirements: - Skilled in writing Arduino code - Able to troubleshoot hardware issues - Experience in basic robotics projects The purpose of the project is to create a basic level robotics system using Arduino, which involves simple movements and operations. The ideal candidate will have a good understanding of robotics, and experience in designing circuits would be an advantage.

...requirements and preferred skills: Key Features: - The tool needs to feature automatic coding, primarily in Python. Primary Functionality: - The tool should be poised to serve all website types - be it e-commerce platforms, blog-based sites, or informational websites. Skills and Experience: - Proven experience in AI implementation - Expertise in Python and understanding of coding automation - Extensive background in web development, across various platforms In essence, my vision is to make web development optimized and streamlined by AI. A tool that not only generates code automatically but can also adapt to any website type. The right freelancer for this job would be one who knows the ins and outs of website coding, has a firm grasp of AI integration, and ca...

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

I'm in need of assistance with custom coding for my Houzez theme website. The objective is to create a dedicated page that performs the following tasks: • Displays data related to property sales, specifically showing the selling price in conjunction with key property details. The data to be displayed should include not only the sold price, but also the property's size, location, and type. • Effectively retrieves information from my preset dataset and correlates it with specific properties based on the property's address. This project is well-suited to a freelancer with extensive experience in web development, specifically with experience working on custom coding within the Houzez theme and dealing with real estate-related datasets. Knowledge in P...

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...

I am looking for an experienced business plan writer to construct a compelling business plan aimed at attracting investors for my Revenue Cycle Management (RCM) start-up. Specifically, the RCM services expected to be integrated into the plan are: - Billing and Coding - Claims Processing - Revenue Cycle Analysis - Training - Potential Revenue Sharing Opportunities with the Owner These services are to be provided to all types of hospitals and healthcare providers irrespective of their size. The writer should have a strong understanding of the healthcare industry and RCM services. Experience in creating business plans for start-ups and a track record in generating investor interest is considered a major asset. Your input will be crucial in outlining my business strategies succinctl...

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.

...confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific rea...

Hello, i am looking for a long term cooperation with a shopify expert that is able to do code and design changements. I need a professional shopify expert with experience in coding. PHP, HTML, CSS and Javascript coding neccessary! All together there are 6-7 changements that need to be done asap (1-2 days). Price and experience are important!

...agency specializing in creating cutting-edge digital solutions for businesses. Aspects to Reflect in the Logo: Website design and development Digital solutions Cutting-edge technology Creativity and innovation Design Approach: The logo aims for a sleek and modern look, reflecting the agency's commitment to delivering innovative web solutions. It incorporates elements reminiscent of coding languages and digital interfaces to symbolize the agency's expertise in web development. The color scheme is bold yet professional, projecting confidence and reliability. Ideally the main logo should look good and be legible both big and as a small icon. (As large as 1200 x 1200 pixels, and as small as 35x35 Pixels.) For this reason it should not contain a lot of te...

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

...acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end result would result in a u...

I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experience with similar tasks and ca...

...on my project. Here's a glimpse of what I have in mind: Primary Responsibilities: - Appropriate implementation of chosen Flask framework. - Contributing with innovative ideas to enhance the project's effectiveness. Necessary Skill Set: - Strong command over Python programming language with expertise in Flask. - Experience in developing & managing complex Python applications. - Advanced Python coding skills are needed, as experience matters most in this kind of project. Although I haven't decided on specific tasks or functionalities yet, your advice and suggestions would be highly appreciated. There could be future opportunities for web scraping, data analysis, and automation ahead. Interested parties, kindly share your portfolios of relevant exposures in P...

I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.

I'm looking for a skilled professional who can assist me in entering text data into our project reports. Ideal Skills and Experience: - Experience working with project reports - Proficient in digital data entry - Attention to detail The reports will be provided in digital format, such as Excel or Word. The main task will be to ensure all text data is accurately entered. Additionally, the ideal candidate should be able to ensure the report maintains a professional and consistent format throughout. You may be asked to apply company branding or use specific fonts and sizes. The ability to work with minimal supervision and meet deadlines is a plus.

I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.

I have a PDF document that is a mix of scanned and text-based content that I need converted into an editable Word or Excel format. I need this completed as soon as possible. The output needs to be fully editable, meaning that the text should be recognized and convertible to a format where I can change, add or remove text as needed. This means the scanned parts should be OCR-ed accurately.

...with memory in our payment gateway form I already have a list of the problematic links to share. The developer we require for this job should have: - Proficiency in PHP and WordPress custom coding - Extensive experience in troubleshooting and fixing broken links - Mastery in handling issues related to code memory - Capability to manage issues with payment gateway forms - Familiarity with PHP frameworks, ideally Laravel, Symfony, or CodeIgniter would be beneficial - Great communication skills to ensure smooth project progress If you're a developer who can quickly understand our simple custom coding and resolve these issues, this might be the right job for you. copy and follow each link to the end to see the errors 1) 2) follow this link

I'm seeking an experienced freelancer for a data entry project. The task involves converting PDF files containing mixed data, both textual and numerical, into Excel. Ideal Expertise: - Proven experience in data entry - Proficiency in Excel and PDF conversion - Accuracy and attention to detail Please ensure all data in the PDF files is correctly transferred to the specified Excel format. I'm looking to post this project up to 100 Rupees. If you have the skills and can handle this type of work, I encourage you to bid.

I have a small set of textual data that needs to be typed into an Excel sheet. The purpose of this project is to prepare the data for analysis. Key responsibilities: - Type less than 100 rows of textual data into an Excel sheet. - Ensure data accuracy and consistency. Ideal skills for this project include: - Experience with data entry. - Proficiency in Excel. - Attention to detail to avoid errors. The successful freelancer will need to deliver the Excel sheet with the data accurately typed within the given timeframe.

I'm looki...handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational skills and attention to detail. A sound understanding of database principles and Excel function...

The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.

I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new d...Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince in Data warehouse like Data profiling, Data Validation, Data Quality etc.. This project is a great opportunity for a SQL developer looking to showcase their skills in building and o...

I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats needed. TY

...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...

...you're passionate about clean coding, adhering to best practices, and creating seamless user experiences, we want to hear from you! Project Overview: - Design Ready: Figma designs are prepared and ready for implementation. - Backend APIs Ready: Our backend infrastructure is set up and waiting for the frontend to complement it. - Frontend Development: Your main task will be to develop the frontend part of our online marketplace using Angular. - Responsiveness: The website must be responsive, utilizing Material UI for a consistent and amazing user experience across all devices. - Mobile Optimization: Mobile optimization is a priority to ensure smooth functionality and accessibility on various devices. - Coding Standards: Adherence to SOLID principles and best coding...

I have a baseline construction schedule built already; it has around 1000 activities, the schedule is cost & resource loaded. I will provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very important y...

I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.

LOOK AT THE FIL...arguing that information and understanding can be a powerful tool against discrimination. Your proposal will demonstrate: - Deep understanding of the problem: the struggles parolees face when trying to secure housing - Clear plan of action: how community awareness programs can alleviate this issue - Benefits: how reducing discrimination could lead to a more inclusive and supportive society To excel in this project, you should have: - Exceptional skills in persuasive writing - Knowledge of recent legislature related to housing and parolees - An understanding of discrimination in housing applications - Experience in generating community-based solutions or policies Let's build a case to uplift this marginalized group, charting a path to fair and inclusive hou...

I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar projects you've worked on in the past...

I'm in need of a skilled web developer to help me with the following tasks: - HTML coding - Implementing AJAX - Developing JavaScript elements The project involves creating a website that caters to the general public. The key functionalities I'm looking for are: - Data submission and processing - Real-time updates - Dynamic content generation Ideal candidates for this project will have - Proficiency in HTML, AJAX and JavaScript - Previous experience in developing websites aimed at general public - Ability to deliver on data processing, real-time updates, and dynamic content generation. Hello to you freelancers, I programmed an availability check on one page. If a user enters a street, zip code or city into the text field on the page, they will receive the respective r...

I'm in need of a Java developer to create a standalone application for a small school. The application will be used to manage student records, various school resources, and facilitate communication with parents. Key Features: - Student Records: The application should be able to manage and track student progress through interactive line charts. - School Resources: The app should also help ...development, previous experience in creating similar applications, and are confident in managing school resources and building a parent communication portal, feel free to bid on this project. I would need a preliminary discussion to assess the possible architecture/technologies. The initial bid if for the first module (main page, students list, DB, add/edit/delete students, load student data fr...

I need an intricate Excel model to calculate a cumulative threshold commission scheme, tailored to three varying levels of seniority: Junior, Mid-level, and Senior. The model needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cash retained...

I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsheets, particularly in...

...developer with expertise in using Python for backend development, JavaScript and HTML for frontend. Key Components: - Backend programming using Python - Frontend programming implemented with JavaScript and HTML Key Functionalities: - Database Integration: The software developer should be able to create a seamless link to an existing database and enable secure data exchanges. there is already excel .xlsx file in the folder - API Integration: The project includes integration of specific APIs to provide essential functionality for the Web Application. Purpose of the Project: - The main goal for this project is to develop a functional web application and host it either on a server or GitHub. The application isn’t static and employs IT-technical features. Ideal candidates ...

I have the attached images , I need it to be in excel form.