How to automate excel reports using vba jobs

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards inclu...

...Ideal Skills: - SEO Optimization: You must be able to identify areas for improvements and implement optimization strategies to drive better performance. - Keyword Research: I have some specific keywords in mind but I am also open for additional suggestions that you may offer. It's important that you understand my industry (Craniosacral Therapy - a complimentary therapy) and know what keywords to target. - Analytics & Reporting: Your analytical skills will be essential in tracking progress, analyzing trends and providing reports. This is not just about getting more traffic to the site, it's about attracting the right kind of traffic that will convert. Your experience in boosting conversion rates should come in handy. Your job will be ...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I need an adept freelancer who is skilled at using to help me set up automatic transfer of data from our Airtable booking system to Sage Business Cloud to automate invoicing. The data in question includes booking details and invoicing line items. Most of the system is up and running but we are currently stuck sending the invoices line items correctly. A deep understanding of both Airtable and Sage Business Cloud will be highly beneficial for this project. Applicants with experience in similar projects have an added advantage. Efficiency, accuracy, and attention to detail are vital for this task.

...seasoned writer to assist me with a dual project: a business report and a series of blog posts. Responsibilities: - The business report should be well-researched, focusing on key areas such as marketing strategies, financial analysis, and industry trends. - The blog posts should be engaging and informative, tailored for a specific target audience which may include business professionals, entrepreneurs, and the general public. Ideal Skills and Experience: - Proven experience in business writing, with an emphasis on reports and blog posts. - Ability to conduct thorough market research and competitor analysis. - Strong understanding of sales forecasting and how to present this data in a clear and impactful way. This project is an excellent opportun...

I'm in need of someone with excellent typing skills to format my business reports. This project is about making my reports look sharp and professional in Microsoft Word (.docx) format. Key requirements: - Excellent typing skills are key, as the reports will need to be retyped into the desired format. - Experience with business documents is a must. Formatting needs to be polished and consistent. - Proficiency in Microsoft Word (.docx) is essential, as this will be the final format of the reports. This is a straightforward job for someone with the right skills, and I'm looking to complete it in a very timely manner.

...analytics reports in Sisense Dashboards with Blox coding. Your primary focus will be on creating a variety of customer reports, based on invoice data and analysis reports. Key Responsibilities: - Creating advanced, highly-customized customer reports using Sisense Dashboards - Leveraging Blox coding to enhance the reports with advanced analytics - Ensuring the integration of invoice data and analysis reports into the reports - Implementing appropriate visualizations and data representations for optimal understanding - Ensuring the reports are user-friendly and easily navigable. The ideal candidate should have: - Proficiency in Sisense Dashboard designing, with a strong command over Blox coding. - Prior experience in...

I'm on a tight deadline to develop a new application using Laravel. There are some minor bugs that need to be resolved before we can move forward. Ideal Skills & Experience: - Expertise in Laravel and PHP - Proficient in resolving minor bugs - Able to work efficiently under a tight deadline - Strong communication skills, as we'll need to discuss bug resolution progress and application development milestones regularly

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

...with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be required to manage key client accounts, upload new content on Amazon listings, work with design, sales and other Lezzat team members to...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to...

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I'm in need of a skilled freelancer who can perform daily scraping of job titles from Indeed. Ideal Skills and Experience: - Proficient in web scraping, particularly from Indeed - Able to automate the scraping process on a daily basis - Competent in delivering data in CSV format Data Update Frequency: - It's essential that the scraping is carried out daily Delivery Format: - The scraped data should be provided in a CSV file Looking forward to your proposals.

I'm in need of a skilled marketing manager to oversee my upcoming tabletop game's promotional campaign, targeted specifically at children. This game is scheduled to be launched within the next year, yet I'm eager to kick off the marketing efforts at the earliest. - Target Demographic: The primary audience for this game is board game enthusiasts, family tabletop gamers and children. The chosen candidate should have a deep understanding of how to effectively market products to these demographics. The following are the key responsibilities and requirements for the job: - Marketing Channels: The ideal candidate should be proficient in utilizing a mix of marketing channels. These would include: - Social Media: Ability to creat...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

I need a skilled report writer with experience in writing within IEEE standards. The report is on a technology topic and needs to be of a specific length. The report is on a technology topic and should be written in the IEEE format. I'm looking for a writer who can deliver a well-researched, engaging, and professionally written content. Key requirements: - Experienced in writing reports in IEEE format - Proficiency in the given technology subject - Ability to deliver within deadlines

I'm in need of a digital marketing expert who can set up and manage a Facebook Ads campaign focused on generating leads for my business. Key Requirements: - Proficiency in managing Facebook Ads, particularly in ge...strategies - A track record of delivering quantifiable results in terms of lead generation Your responsibilities will include: - Setting up and structuring the campaign - Carrying out continuous monitoring, analysis, and optimization - Providing regular reports on campaign performance and lead generation metrics - Proactively suggesting new strategies to enhance lead generation efficiency The ideal candidate should have a strong understanding of the digital marketing landscape, particularly in the realm of Facebook advertising, and a proven ability to...

I'm in need of a skilled developer to create a score card module using MAUI. This module should allow for the following: - **Score Entry**: Users should be able to input scores into the system. - **Calculation of Scores**: The module should be able to process the inputs and calculate the final scores. - **Display of Scores**: The final scores should be presented in form of summary reports. This module is designed for administrators, so it should only be accessible by those with administrator privileges. Ideal candidates for this project should be proficient with MAUI and have experience with creating data-driven modules. You should be able to integrate various data input methods, develop calculations and create concise, visually appealin...

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

...website. The main goal is to improve the website ranking. This task is quite urgent and needs to be completed within a day. This is a 1 hour job! Full video here explaining the job This job will also lead to other jobs, such as ranking our website, high DR backlinks, blogging, creating pages to rank for easy keywords, running keyword reports, etc. I will only respond to offers that have confirmed they have watched the video. I will not answer bot responses. Key responsibilities include: - Utilizing SemRush to identify toxic backlinks - Compiling the list of toxic backlinks in a notepad for Google Disavow backlinks tool - Ensuring that the backlinks are safely removed from our website The ideal candidate should have: - Prior experien...

...expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's crucial that the template looks pro...

I'm looking for a skilled HTML/CSS designer to produce a visually appealing report. It should include an executive summary. Key Requirements: - Design a report, not just a website - Primary focus is the Executive Summary - Use HTML/CSS to create a visually appealing, easy-to-read document. Ideal Skills: - Strong command in HTML/CSS - Ability to create clean, modern designs - Experience in designing reports is a plus

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I'm looking for a skilled developer to add a small module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential....

...skilled Senior Python Developer to assist with a project that involves a blend of web scraping and data analysis, with a focus on the following tasks: - Extracting data from multiple websites - Automating data extraction and parsing - Analyzing and visualizing scraped data The ideal candidate should have: - Proficiency in Python, with a strong understanding of AI and Machine Learning - Hands-on experience with web scraping, particularly working with diverse data sources - Ability to automate data extraction and processing efficiently - Adept at data analysis, with the ability to visualize and interpret data Although I haven't specified any particular tools or libraries, your familiarity with tools like BeautifulSoup, Scrapy and Selenium would be a bonu...

I'm looking for a cross-platform mobile app developer to create an app focused on daily reporting. Below are some key details to be aware of: - The app needs to be cross-platform, compatible with both iOS and Android devices. - The primary goal of the app will be daily reporting. This means users will be able to easily submit reports on a daily basis. - The app should be intuitive, user-friendly and well-designed. - Security is also a key consideration, as the reports will likely contain sensitive information and should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name...

I am looking for a proficient software developer to build an all-inclusive student fee management software. Key Features: • Ability to track multiple types of student fees • Capability to generate detailed fee reports • An automated reminder system. The software must smoothly integrate with our existing systems which include the school management system, attendance system, and our accounting software. Ideal Skills: • Experience in educational software development • Strong background in systems integration • Skilled in automation and report generation.

I urgently require an exceptional market researcher to evaluate the market size and potential for a National Disability Insurance Scheme (NDIS) provider in nsw, Australia in regards to early child hood to young adults. The ideal candidate should have: - Proficiency in relevant research tools. - Understanding of the NDIS service sector or similar industries. - Ability to deliver comprehensive and accurate reports promptly. Your primary responsibilities will be: - Assessing the market size for an NDIS provider. - Evaluating the potential growth of the sector. - Identifying competitive landscape. I look forward to working with a diligent professional who can deliver results ASAP.

I'm looking for a skilled freelancer to integrate MailChimp with my WordPress website. The main objective of this integration is to set up and automate email campaigns. Key aspects of this integration will include: - Setting up MailChimp on my WordPress website - Designing email templates in MailChimp - Configuring automated email campaigns To ensure the campaigns are effective and engaging, it's crucial that the emails are: - Scheduled at optimal times - Personalized to each user's preferences and interactions Ideal Skills and Experience: - Proficient in MailChimp and WordPress - Experience in setting up automated email campaigns - Strong understanding of user engagement strategies

...freelancer who can help me automate my web search for bid opportunities (RFPs) for my telecom company. Currently, I rely on searching manually, but this process is time-consuming and not as efficient as I'd like. Key Project Requirements: - You will be responsible for setting up an automated search that looks for RFPs related to "fiber optic" or other telecom-specific keywords, which are due every May 2024 or similar queries. - This automated search needs to run every 2-3 weeks, ensuring that I stay up-to-date with new bid opportunities and future due dates. - You should have a deep understanding of web scraping and automation to accomplish this task. Additional Information: - I would like to receive notifications about new ...

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

...technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, communication may become challenging depending on the device's location and surrounding environment. Therefore, this technology aims to provide a system that facilitates reliable high-frequency communication between the mobile device and the vehicle's equipment. 【2　Technology Descr...

I'm in need of a skilled Instagram account manager to help me increase website visits. Key Responsibilities: - Manage the day-to-day activities of the account - Create and publish engaging content - Monitor performance and provide regular reports - Engage with followers and respond to comments Ideal Skills & Experience: - Proven experience in managing Instagram accounts - Understanding of Instagram algorithms and best practices - Ability to create engaging content - Strong analytical skills to monitor and report on performance - Excellent communication and customer service skills I plan to have at least three posts a day on the account. I'm looking for someone who can help me significantly boost website traffic through the ...

...looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform d...

...engineer who is proficient in Odoo and Python to help me build a robust CRM system. The project calls for a quick turnaround - I need it to be completed ASAP. Key Features: - Sales Pipeline Management: The system should help me track my sales process from lead generation to conversion. - Customer Interaction Tracking: I want to record all interactions with my customers, including emails, calls, and meetings. - Integrated Email Marketing: The CRM should have seamless integration with my email marketing tools so I can easily communicate with my customers. - Scheduling: I need the system to have scheduling capabilities to help me manage my time effectively. Primary Goals: - Improve Customer Satisfaction: The CRM should help me provide better serv...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilenam...

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I'm in need of a seasoned SEO expert to handle the SEO requirements for my 4 real estate websites in Australia. These sites are crucial for generating leads in the commercial and residential markets. Key Tasks: - Keyword Research and Optimization: I need you to conduct thorough keyword research to target the right audience and optimize the content accordingly. - On-Page Optimization: Ensure that the on-page SEO elements are in place and up to date for all the sites. - Link Building: Build a strong backlink profile for my websites to enhance their SEO performance and increase organic traffic. Ideal Freelancer: - Proven experience in SEO for real estate websites or a similar niche. - Excellent understanding of keyword research and on-page optimizatio...

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal...

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

I'm in need of a comprehensive project report to assist in securing a collateral-free loan for my upcoming Food and Beverage business in INDIA. The key details I want to focus on are: - An overview of the beverage industry, in relation to the current market scenario and potential growth. - Detailed need for the loan, emphasizing how the funds will be utilized and their expected impact on the business. - Financial projections that can demonstrate the feasibility and profitability of the startup, specifically focusing on the loan amount requested (between INR 15Lakh to 20Lakh). - Break-even analysis that can help potential lenders understand the risk and reward of investing in this venture. The right candidate for this job should possess a solid unde...

...experienced and reliable Virtual Assistant to help with SEO-related tasks, particularly focused on off-site activities. The primary responsibilities can be categorized into two main areas: SEO Reporting and Off-Site Support. Key details include: - **SEO Reporting**: I need comprehensive monthly reports. The reports should be clear, concise, and easy to understand for someone with a non-technical background. I will provide a detailed format. - **Off-Site VA Tasks**: - **Link Building Outreach**: This is a crucial aspect of the role. Your task will be to reach out to various websites for backlinks. I will provide you with the process and guidelines, but you will need to be proactive in your outreach. - **Backlinks**: You will be...

I need a uniquely developed tool for managing my Google reviews. The primary feature of this tool should be automating responses and providing analytics to monitor trends. It should also be able to alert me in real-time to any negative reviews. Key Features - Automated Responses: The tool should be capable of setting automated responses depending on the review sentiment. - Trend Analytics: It's important to be able to track review trends to gauge consumer satisfaction and adjust business strategies. - Negative Review Alerts: Immediate alerts on negative reviews for prompt response and reputation management. Ideal freelancers for this job should have experience in software development and familiarity with Google Review systems. Expertise i...

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

...Features for the Kanban Board: - Task tracking: The tool needs to allow me to create tasks and move them across different stages. - Assigning tasks to team members: It should be possible to assign tasks to specific team members. - Adding due dates: The ability to set due dates for tasks is a must. - Notifications: The tool should be able to send notifications to relevant team members when there are updates or changes to their assigned tasks. Key Features for the Gantt Chart: - Creating dependencies between tasks: It should be possible to create task dependencies. - Showing progress of tasks: The tool needs to visualize the progress of tasks in a clear and intuitive way. - Generating reports: The tool sh...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

I need a skilled report writer with experience in writing within IEEE standards. The report is on a technology topic and needs to be of a specific length. The report is on a technology topic and should be written in the IEEE format. I'm looking for a writer who can deliver a well-researched, engaging, and professionally written content. Key requirements: - Experienced in writing reports in IEEE format - Proficiency in the given technology subject - Ability to deliver within deadlines