Data excel workbook master workbook using vba jobs
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.
I'm urgently seeking a skilled developer to set up a Helios 2 Lidar camera for detecting human figures and calculating distances up to 10 meters. Key Requirements: - Proficiency in setting up and customizing Helios 2 Lidar camera - Mastery of object detection, specifically human figures. - Capable of implementing short-range distance calculation (up to 10 meters) The project demands someone who has a strong understanding of Lider camera configurations, and advanced skills in object detection and distance measurement methodologies. Your competence in creating systems to accurately detect human figures and calculate short-range distances will be the driving forces behind the success of this project.
I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in...
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
FOR EXPERTS IN TRAVEL INDUSTRY: I need someone to OPTIMIZE current campaign We have: 10 campaigns - divided by countries Each campaign has approx. 10 ad groups I'm in need of a skilled Google Ads expert to spearhead a campaign specifically designed to generate potential leads. As I'm targeting a worldwide audience, I require someone capable of effectively reaching all corners of the globe. - Key Objective: Lead Generation - Geographic Reach: Worldwide - Audience Targeting: Based on Interests The ideal freelancer should possess a strong background in Google Ads management with a focus on lead generation, a keen understanding of leveraging interests in targeting strategies, and experience in managing global ad campaigns. Success in this project will be measured by the quality...
...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...
Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...
I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided numerical data, organized in a tab...
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
...affecting the sale of water heaters This project requires hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantag...
I'm looking for a freelance graphic designer with experience in modern, sleek logo design to help revamp my current logo to improve my brand identity. It should be state of the art (I think gr...portfolio in modern logo design and brand identity development. A deep understanding of current trends, especially in the IT sector will be greatly valued. Excellent knowledge of color theory and the psychological connotations of shapes is also crucial. I attach an anonymized business card with my old logo to get an idea about current situation. The logo is for a freelance IT Consultant holding master degrees in computer science and economics. A second similar style logo for the second branch of the owner would be good. Second branch is production of renewable energy with photovoltai...
I'm in need of a custom Python parser using the pylatexenc library. It should mainly feature: - Special Feature Parsing: This parser must be able to parse through figures, tables, and equations specifically, while remaining in original LaTeX format. - Format Conversion: convert to simple text The ideal candidate for this project will have proven Python skills, familiarity with the pylatexenc library, and knowledge of LaTeX. They should also have experience with custom parser creation, and be familiar with converting LaTeX into other formats. Note: extensive testing on sample latex projects needs to be conducted to make sure its generalizability.
...The ideal candidate would be proficient in market research with experience in the specific industry, customer profiling, and an understanding of energy appliances. Knowledge of the local market is crucial. Your insights will shape our market strategy, so accuracy and attention to detail are paramount. Deliverables: Comprehensive report with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project....
...Auto Complete, Error Detection, and supporting both HTML/CSS and PHP languages (PHP support is optional). The plugin is intended to be a standalone component, not embedded or replacing any existing editor. the editor should include a file search (to search through templates) - similar to shopify but as well as searching filenems it shoudl also search in contents The editor shoudl work with a master theme/child theme style system such that when a template is modified its auto-copied to the child theme Key requirements: - Develop a code editor plugin similar to Shopify's - Implement Syntax Highlighting, Auto Complete, Error Detection - Support both HTML/CSS and optional PHP languages - Integrate as a standalone plugin Ideal skills and experience: - Proficiency in PHP and J...
As the client for this project, I urgently require an expert in VBA.
I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type...
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save...
I need assistance with entering data into an Excel sheet. Ideal Skills: - Proficiency in Excel - Meticulous attention to detail - Fast, accurate typing skills - Experience with data entry and data organization Please note, the specific data format will be provided.
I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create u...
...that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong kno...
I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel form...
As the VP of sales for a fast-growing coding BootCamp company, I require a highly proficient individual to assist me with several key tasks. 8am - 5pm PST availability, full time role. Key Responsibilities: - Data Analysis: You should be able to dissect and interpret a variety of data sets, particularly surrounding sales, leads, and conversion rates. - Report Generation: Using Excel or Google Sheets, you will be responsible for creating detailed reports on sales performance, lead generation, and conversion rates. Ideal Skills and Experience: - Fluency in Excel/Google Sheets - Previous experience working as an executive or virtual assistant for sales managers or VP of sales, ensuring you understand the requirements and demands of the role - Exceptional a...
...children’s workbook designed to teach financial literacy concepts to children aged 5-8. This project will involve the creation of vibrant and educational illustrations to engage young learners in understanding money management, earning, saving, and spending through interactive activities. Project Objective: Our aim is to produce a 50-page workbook that not only educates but also captivates and motivates young readers. The illustrations will be critical in making financial concepts accessible and fun, helping children visualize and understand the lessons effectively. Illustrator Responsibilities: Collaborate closely to grasp the educational goals and content of the workbook. Design engaging, colorful illustrations that complement and enhance the educational c...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I'm a professional audio editing who can provide a variety of services across multiple platforms. Key...This will involve cleaning up the recording to remove any unwanted noise or background sounds. Also Ican to reduce noise to guarantee a smooth listening experience. - Mixing and Balancing: I have expertise to mix and balance the audio tracks, ensuring that all the elements are well-integrated and the audio levels are consistent throughout. - Mastering: To give the final polish, you will need to master the audio to make it ready for public consumption. - Multi-platform experience: I have prior experience with editing audio for Podcasts, YouTube, Audiobooks, and even music. Software: - Protools, Logic Pro, Izotope, Waves, etc. Some examples of previous work are in my pro...
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented...
...send me your sample work.*** I'm looking for a skilled lighting designer to work on a small residential apartment complex and car park. The project requires an understanding of Australian standards for lighting. Key Responsibilities: - Design lighting for common areas - Individual apartment lighting - Car park lighting *All lighting to comply with Australian Standards. *Project must be designed using AGi32 or DiaLux software Skills and Experience: - Proficiency in lighting design - Knowledge of Australian standards - Should be able to use AGi32 or DiaLux Software Note: Scope of work is attached along with some Sample drawings. Deliverables: 1. Dwg & pdf drawings with lighting fixture layout along with lux levels noted on them. 2. Lighting legend & schedule 3. Eme...
I have some basic knowledge of Photoshop but I'm looking to improve my skills specifically in ...knowledge of Photoshop but I'm looking to improve my skills specifically in editing portrait photos. I'm seeking a skilled Photoshop tutor who can guide me through the process of skin retouching. Key Project Details: - The focus will be on portrait photography and product photography. - The specific editing technique I'm aiming to master is using similar techniques to some of my favorite photographers in fashion and lifestyle. Ideal Skills and Experience: - Proficiency in using Adobe Photoshop for portrait editing. - Previous experience in teaching or tutoring Photoshop would be a plus. - A good understanding of photography principles and experience in...
I'm seeking a skilled FPGA developer to construct an intermediate-level chessAI project. The AI is expected to run real-time on a Spartan-7 FPGA board, using Vivado and Vitis. Key Project Details: - **Real-time Performance:** The AI should be optimised for real-time operation on the FPGA board. - **Intermediate Complexity:** The chessAI should be capable of intermediate-level game play, providing engaging and challenging performance. - **FPGA Model:** The project is designed for a Spartan-7 FPGA board, hence prior experience with this model is preferable. Key Skill Requirements: - Proficiency in FPGA development, particularly with Vivado and Vitis. - Prior experience in designing chessAI or comparable AI projects. - Expertise in optimising AI models for real-time FPGA impleme...
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
...skilled freelancer who can develop a simple process of click few buttons and select input file to extract numeric digits from JPEG images hosted on a cloud server using the Google Vision API with their TEXT_DETECTION. More detail information from google on text extraction on remote image: The task involves extracting numeric digits using Google's TEXT_DETECTION feature from JPEG images hosted on a cloud server.: - Image URLs are provided in an Excel file (sample attached), with over 200 URLs. - The extracted numeric digits need to be added to the same Excel file in columns next to each corresponding image URL. We require only the digits with a length between 4 to 8 digits. Other text information is not needed. Google
I'm seeking a seasoned expert to completely transform my existing website. Sure, here's a revised version of your request: • We are looking for a developer who can successfully integrate our platform with our master distributor's EDI connections. Our previous software developer was unable to accomplish this, so we need someone with the expertise to handle it effectively. • The website needs to undergo a full layout redesign. The new design should be modern, user-friendly and aesthetically pleasing. Mastery in User Interface (UI) and User Experience (UX) design is a must. • The navigation should be entirely revamped for better and seamless user journeys. Factors like breadcrumbs and clear categorization are key, requiring excellent knowledge in info...
...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on gene...
...bedrooms with all ensuite and walk-in wardrobe. Second Floor 2nd floor should have 10 bedrooms including the master bedroom with all walk-in wardrobes and ensuite bathrooms, toilet must be separate from the bathing and shower area in all rooms including guest rooms, and all bedrooms to have a separate study room, must have a staircase leading to the other floors from the rear of the property also a staircase from the rear leading directly to the roof but must have lower floor guard on the staircase to prevent intruders and children from accessing without permission. Master bedroom must have His and hers walk-in wardrobe, his and her bathroom, male bathroom to have a urinal Master Room Master bedroom must have His and Her’s walk-in wardrobe, one larg...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...
...proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and c...
I'm on the hunt for a highly experienced video editor to expand the reach of my product-centric promotional content through social media reels. Key Responsibilities: * Basic Editing: Your primary role is to make my product shine using basic cuts, seamless transitions, and dynamic text overlays. Ideal Skills and Experience: * Master of Video Editing Softwares: Proficiency in using state-of-the-art video editing software is a must. You should be able to deftly marshal these tools to bring out the best in raw footage. * Social Media Expert: You need to have a grasp of the quirks and features of different social media platforms, especially the ones that utilise reels. * Detail-oriented: A keen eye for detail is important to ensure a smooth viewer experience. * ...
I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames...unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experienc...
...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...
I'm looking for a skilled C++ software developer to create a software on a esp32 which talks to a nrf24 module. The Software parts can be taken from the Github directory: I need only the functionality which can be seen on the pictures in the code. All the web and network stuff can be ignored.
Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.