Using vba to automate excel jobs

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific nee...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent proj...

...for online shops and help businesses optimize and automate their sales and shipping processes. We are looking for an experienced freelancer to develop plugins and interfaces for various e-commerce platforms. Here are the Plattforms we are seraching Freelancers for: Wix Ikas JTL-Shop Magento BigCommerce WooCommerce Gambio PrestaShop OpenCart Analyze and understand the specific requirements and integration possibilities of the listed platforms. Implement secure and efficient interfaces between the plugin and the respective e-commerce platforms. Ensure the plugin's compatibility with the latest versions of the platforms. Perform testing and debugging to ensure smooth functio...

Project Details Docker and K8s * Containerize any Microservices based app (Frontend and Backe...Containerize any Microservices based app (Frontend and Backend and DB) and run it as a nonroot user. * Write Kubernetes artefacts to deploy above container on K8s. * Setup Database in Kubernetes cluster. * Deploy microservice to Kubernetes cluster. * Ensure that applications are able to communicate with each other. * Only Ul should be Publicly accessible and not the backend. CI-CD * Automated Application Deployment via CICD. * Setup Jenkins in the Ec2 instance created via Terraform. * Create CICD pipeline to automate the actions done in Phase 1 with stages like Build and Push, push the images to Dockerhub, Update the Kubernetes Artifacts wit...

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I've told you ever...

I am looking for a freelancer to help me in drawing the developed Artificial Neural Network (ANN) which will predict data related to education. The visual representation of the selected parameters and the predicted data versus the actual data will be shown in the form of spreadsheets. Your role will be to: - Draw the developed ANN for education prediction - Show the selected parameters for the developed ANN - Visualize the predicted data versus the actual data in spreadsheets Ideal skills and experience: - Solid understanding of Artificial Neural Networks (ANN) - Experience in data visualization, particularly using spreadsheets - Familiarity with educational data or at least a background in developing predictive models in a related field - Ability to c...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...professional who can automate various tasks between ClickUp, Zapier, Mailchimp, and Google Sheets. This will include: - Data syncing among all four applications, set to be updated daily. - Automating my email marketing process via Mailchimp. - Automating task management via ClickUp. Specific Tasks: - Automation of task creation in ClickUp. - Automation of sending out emails based on changes in task status. Skills and Experience Required: - Proven experience in working with ClickUp, Zapier, Mailchimp, and Google Sheets - Proficient in automating processes and task management - Strong data management skills - Experience in email marketing automation is an asset This automation project will help streamline my business processes, so efficiency and attenti...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our w...

I am seeking an experienced engineer who can assist me in the design and analysis of a new project. Ideal skills and experience for the job: - Proficiency in AutoCAD for design and analysis - Strong background in engineering, particularly in the area of design and analysis - Excellent problem-solving skills - Ability to work closely with me to understand my vision for the project and bring it to life

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability ...

I'm looking for a talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself....

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs comple...

I'm in need of a skilled Flutter developer who can assist me in creating an app for launching advertising campaigns on Facebook and Instagram. Key Features: - The primary functionality of the app should be allowing users to easily set up and launch advertising campaigns on Facebook and Instagram. - The app needs to be able to automate the process, requiring minimal manual intervention. - In addition to the automated campaign launching, the app should provide insights and analytics on the campaign's performance. Ideal Skills: - Proficiency in Flutter is a must. - Experience with social media advertising, especially on Facebook and Instagram, is highly preferred. - Understanding of automation tools and techniques will be advantageous.

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging spec...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compat...

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further consideration.

I'm looking for a skilled developer to create a robust mobile application that offers real-time translation capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency ...

I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I'm looking for a professional who can help me integrate my FreePBX system with an AI to automate and manage my call center. The ideal candidate should be able to: - Implement AI-driven call routing - Develop an AI voice bot - Configure the AI voice bot to provide information, take orders and schedule appointments Key requirements: - Seamless integration between FreePBX and the AI system - Smooth call handling and routing - Accurate and relevant information delivery by the AI voice bot to the callers - AI system must be able to provide business hours, product descriptions and pricing information to the callers.

...task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills an...

I'm in need of a professional who has extensive experience with SharePoint, Power Apps, Power Automate, and secondary Power BI . I need support for my consultant indian time 8:30 pm to 11:30 pm Monday to Friday. 12$/hourly.. payment every saturday vai peayplea. I already have other indian guys who are working with me since 2019 to present. This support will be on zoom meeting. Which we will provide u and u will connect with my consultant for support.

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I've told you ever...

I'm in need of an experienced data entry spe...need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience,...

...help me design custom SharePoint sites for our clients. The main objective is to create intuitive, engaging and user-friendly sites that cater to our clients' needs and requirements. Key Responsibilities: - Designing custom SharePoint sites based on client requirements - Ensuring the sites created are user-friendly, engaging and responsive - Understanding the clients' needs and translating them into effective SharePoint site designs Ideal skills and experience for the job: - Proficient in SharePoint site design and development - Strong understanding of user experience and user interface design - Ability to translate client requirements into effective site designs - Excellent communication and collaboration skills to work with both the clients and...

I need an expert in Selenium to automate functionality testing of our web application. This project aims to ensure the application functions as expected with regular, automated testing. Key Responsibilities: - Developing automated functions testing for our web application - Ensuring tests are compatible with Google Chrome. Ideal Skills: - Proficient with Selenium - Familiar with functionality testing. - Reliable and consistent test development. Previous experience with Selenium-based functionality testing in Chrome is highly desirable.

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I'm looking for a skilled freelancer who can help me automate personal communication using WhatsApp Cloud API. The main goal of this project is to streamline my personal communication processes and make it more efficient. Key Responsibilities: - Integrating WhatsApp Cloud API: The first phase of this project would involve setting up the WhatsApp Cloud API, including the integration of a websocket webhook for real-time communication. - Developing Automation Scripts: I will need you to create Python scripts that can automate various communication tasks on my behalf. This might involve sending messages, responding to specific triggers, or even managing contacts. Skills and Experience: - Proficiency in Python: You should be an expert in Python ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.

...freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but ...

As a Python Developer, I'm intent on automating specific repetitive tasks related to file management and organization. Key Responsibilities: - Develop scripts in Python to automate repetitive file management tasks. These tasks are slowing down our productivity and we need a solution to streamline them. - Implement an effective, reliable and user-friendly automated system that requires minimal manual intervention. - Ensure the system is highly secure and can handle large volumes of data effectively. The ideal candidate will have: - Proficiency in Python programming language and experience in automation.

Hello, I need complet the Amazon categories catalogue excel in french

We are seeking an experienced developer to create a Telegram bot with natural language processing capabilities that can generate PowerPoint presentation files (.ppt). The bot will guide users through a series of steps to create a fully customized presentation. The ideal candidate should have experience in bot development, PowerPoint automation, and natural language processing. Key Requirements: - The bot should be compatible with both the Telegram mobile app and web version. - It should primarily focus on generating slides based on provided text inputs. Ideal Skills/Experience: - Proficiency in natural language processing - Extensive experience in building Telegram bots - Proven track record in developing AI for image retrieval - Previous work on user interaction ...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically award to bidded products as admin can set

Please Sign Up or Login to see details.

I require an efficient programmer eq...efficient programmer equipped with the crucial skills in Pine Editor coding. The project involves designing a script based on the 'Trading View' platform to automate my stock market trading strategy. The strategy revolves around Multiple EMA (Exponential Moving Average) crossing. For this specific task, a system with three different EMA lines is preferred. Ideal Skills & Experience: - In-depth knowledge of Pine Editor; - Familiarity with Trading View platform; - A fine understanding of EMA and its implementation in trading strategies; - Previous track record demonstrating similar tasks completed. I emphasize clarity and efficiency in the script to enhance my trading decisions. Please, get in touch if you can co...

I am looking for a well-qualified freelancer to help me develop a motivational app using AI. The user interface required for the app will be a mobile application. We will also need an admin panel to manage user subscriptions. Additionally, AI scripts need to be incorporated into the app as well. The purpose of the app is to motivate users and encourage them to reach their goals. The freelancer I choose to work with must possess advanced experience in both mobile application development and AI programming. They should be comfortable working with both UI/UX design and backend development to ensure that the app functions correctly. Project Brief -