Macro vba excel example punët
I need a web-based application that can automate the swapping of tags with data from an Excel sheet. Key Requirements: - The application should be accessible online and be compatible with major browsers. - It should provide an interface where I can upload an Excel sheet with the necessary data. - The application must be able to recognize specific tags in a template and replace them with corresponding data from the Excel sheet. - should work with PDF , Word document - Document / Arrangement Formatting MUST be maintained - Able to export into doc or pdf Experience and Skills Required: - Proficiency in web development, particularly in creating online applications. - Strong experience in working with Excel files and data extraction. - Knowledge of automation techn...
We are currently seeking a highly skilled Senior Web Designer to join our team on a freelance basis, with a potential pathway to full-time employment. Ideal candidates will hav...Key Requirements: Proven experience in designing sophisticated websites at a senior level. Expert knowledge of UX/UI principles, responsive design, and current web technologies. Ability to collaborate closely with our development team to ensure seamless implementation of designs. Strong communication skills and a proven track record of meeting deadlines. This role is suited for individuals who excel in a dynamic, fast-paced setting and are open to transitioning from freelance to a full-time role. We are excited to offer this opportunity to tackle engaging challenges and advance at the cutting edge of web t...
I am seeking an experienced photo editor who can help elevate my personal photos. The tasks required include: - Basic retouching to improve overall image quality. - Background removal to highlight the photo's main subject matter. - Lighting adjustment to amplify the mood of the image. Knowledge of JPEG format is necessary as all images come in this format. ...Knowledge of JPEG format is necessary as all images come in this format. Ideal candidates will have a keen eye for detail and the ability to enhance images in a tasteful manner. A sensitivity to personal photography and an understanding of image composition will also be highly regarded. The aim here is to ensure every image conveys the story beautifully. If this sounds like a project you'd excel in, I would lo...
I'm in need of a professional's help to create static line graphs in Microsoft Excel for scientific data presentations. Ideal Skills and Experience: - Proficiency in using Microsoft Excel to create line graphs - Experience with scientific data visualization - Understanding of best practices in graph creation Additional notes: - The data for the graphs will be provided to you - The graphs are expected to be clear, accurate and visually appealing - Familiarity with scientific terminology is a plus, but not strictly required.
...YouTube Shorts Scriptwriter in the Tech Niche. 1) Skilled Writer + 2) Technology Enthusiast. [Long-Term, Per-Project Pay] We are launching a new YouTube channel dedicated to exploring emerging and interesting technologies. Our goal is to stand out with content that captivates and educates by delving into the latest interesting technological advancements and innovations - from AI products, VR, to macro level tech changes. This role is perfect for someone who is deeply passionate about technology, stays abreast of tech trends, and possesses a witty and engaging writing style. You are always on twitter, product hunt, etc… and you get excited about cutting-edge developments. You will be paid on a per-project basis. Responsibilities: * Write engaging, informative, and creativ...
Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover valuable insights.
I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data...
I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills
I'm seeking a talented designer who can make a 3D rendering for my rental units. Your tasks will be: - Create a visualization rendering of individual units. The central focus should be the interiors. - Bring the renderings to life with high attention to det...renderings to life with high attention to detail including lighting, textures, and shadows. Ideal skills: - Strong proficiency in 3D modeling and rendering software. - Demonstrable experience in creating high detailed 3D renderings focused on interiors. - Ability to adhere to a specific design brief and create visually appealing and realistic renderings. This project will be a great fit if you excel in creating lifelike 3D representations and have a keen eye for detail. I look forward to seeing your previous work in ...
...Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an excel based GAP analysis of desired Asset Management state vs current, based on Parent Company's expectations and standards. 4. Define a recommended plan for addressing these GAPS in a viable way. The ideal candidate for the project should: - Possess vast experience in IT asset management - Have intricate knowledge of Documentation Process and Workflow diagram - Have proven...
I am looking for a proactive and detail-oriented lead generation assistant to help me with data research and email outreach/follow-up. The main focus will be on the B2B sector. Key Responsibilities: - Conducting thorough data research to find relevant contacts...research to find relevant contacts and organizations in the B2B sector - Managing email outreach and follow-up with these leads Ideal Skills and Experience: - Proficiency in data research and collection to identify potential leads - Experience in email outreach and follow-up to engage and nurture leads - A good understanding of the B2B industry and its dynamics - Ability to deliver leads in an Excel/CSV format If you have a track record in delivering high-quality B2B leads and can assist with these tasks, I'd like to...
My company and I are looking for an experienced freelancer to develop an Excel tool for Electrical energy savings. The tool should be able to calculate energy savings, graphically represent data, and compare different scenarios all according to the formulas and calculations I will provide. We prefer to communicate technical details via telephonic discussion. The freelancer should have experience creating similar tools and should present a proposal for development.
To create a canvas powerapps screens similar to the Excel provided to Florian.
I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.
As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.
My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.
I'm seeking a talented writer with a nutrition background to create a high protein recipe E-Book for my online training and nutrition coaching business based in Australia, Key project elements: - The book should be in PDF format. - It should include recipes with complete nutritional information, particularly macro breakdowns for each one. - Should include breakfast, lunch, dinner and snack options. - The ingredients should be Australian based- things that are sold in Australia Ideal Skills: - A strong understanding of nutrition, specifically macronutrients. - Experience in ebook writing and formatting, preferably with a focus on recipe or health books. - Ability to create engaging and informative content. - Precise, clear, and concise writing style. Please note, additiona...
I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?
...developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a quote at a reasonable rate. Thank you in advance fo...
I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is automo...
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...
I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.
...experienced Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google Excel and enhancing its functionalities. - Profici...
I have image form i want to make the form in excel to print it directly
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
I'm looking for someone to develop a stock prediction program specifically targeted at the Saudi market. Key Requirements: - Programming Language: You can use any language you're comfortable with, whether it's Python, Java, C++, or another language or excel sheet. - Technical Requirements: The program should be highly accurate, providing predictions with an accuracy rate of over 90%. - Data Sources: The program should utilize a range of data sources to inform its predictions. These should include historical stock data for the Saudi market and any other relevant information that you can source. Be creative with your data sources and demonstrate a strong understanding of the market. Ideal Skills and Experience: - Strong background in programming and algorithm develop...
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tra...
I am searching for a dynamic Sales Executive well-versed in technology, specifically software solutions, to drive sales in the business sector. Key Responsibilities: - Building and maintaining relationships with business clients ...maintaining relationships with business clients - Presenting and selling software solutions ( web designing and social media marketing and management ) Ideal Profile: - Experience in B2B sales, particularly in technology - Understanding and passion for software solutions - Excellent communication, presentation and negotiation skills. This is a commission-based role offering the opportunity to excel within the tech industry while working closely with businesses. Comession is based on deals you will it is going to be between 8% - 20% on every succe...
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong crede...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
...real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead our efforts in leveraging machine learning technology, guiding and managing our talented teams to innovate and excel. Exciting Growth: VRAS is expanding rapidly, and we're looking for our next partner to join us on this thrilling journey. Equity Only Offer: This partnership opportunity is equity-only, reflecting our commitment to building a collaborative and mutually beneficial relationship. What We're Looking For: Technical Expertise: Extensive experience in machine...
I'm looking for someone to assist in transferring data from digital files (mainly PDF and Word) into Excel spreadsheets. Key Responsibilities: - Accurately inputting data from PDFs and Word documents into Excel - Ensuring data integrity and quality is maintained throughout the process Ideal Skills and Experience: - Prior experience with data entry, particularly with Excel - Meticulous attention to detail to ensure accurate data transfer - Proficiency in Excel and ideally some experience with PDF and Word files - Ability to work independently and meet deadlines
I have a large PDF file with a mix of text and numbers. It contains over 300 pages, but there are generally less than 10-20 lines of data on each page. I'm looking for a freelancer to convert this data into an Excel spreadsheet. I'm only in need of data entry, not analysis, so the task is straightforward. Ideal Skills: - Proficiency in Adobe Acrobat - Strong knowledge of Excel - Experience in data entry This is a simple but time-consuming job, so please provide a realistic timeframe for completion when bidding. Accuracy is important, as the data will be used for further analysis.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong crede...
I'm in need of a research professional who can collate and organize details about the Corporate Social Responsibility (CSR) activities of a specified list of 400 companies, together with LinkedIn profile URLs of respective team members. Key Task Requirements: - Research and compilation of CSR project details of the identified companies - Use of Excel for data presentation in an organized manner - Gathering of LinkedIn URLs of team members from each company Ideal Skill Set: - Proficiency in web research - Expertise in data entry and data organization - Familiarity with LinkedIn and its functionalities - Detail-oriented approach - Experience in Corporate Social Responsibility research is a plus. Your job will be instrumental in providing in-depth insights about the afore...
I need a minimal flutter example app for android. The app must scan Bluetooth Ibeacons. I do not need a complete UI, simply a button to start scan and another to stop scan. The information obtained from beacons can be showed in a textbox. The monitoring of beacons mut be "Ranging" (each transmition of beacon must be received and showed) Is very important the scan continue in background. When the app is minimized or out of focus, the app must launch a foreground service (or the foregrounn service can be allways active on all the life of app) when te foreground service is running, a permanent notification must be showed (android policy to allow foreground service). The app must request all permitions required to user on start. When the app is minimized, and the foreground...
Preciso que rode conforme video em anexo, eu tentei mexer mas não consegui usar o macro recorder
I have an excel exercise as part of a financial modeling course which i need to solve It is regarding determining debt size and repayment profile while keeping DSCR at a fixed ratio. I will also need to record a Macro of the debt sizing, sculpting and leveling profile
I need a skilled statistician/data analyst to assist with imputing missing data in a meta-analysis of clinical trials dataset using SAS or Stata (ideally). I can supply the results of 28 trials (with 15 with missing data) with n events / n total in ACA analysis and n missing in both intervention and control groups (in Excel format) Key Responsibilities: - Impute missing data: The primary task will be to impute missing data in the clinical trial dataset. This is crucial for maintaining the integrity and accuracy of the overall analysis. - Generate ACA, ICA-0, ICA-1, ICA-pc, ICA-pe, ICA-p, ICA-b, ICA-w, Gamble Hollis analysis and IMRO (2/0.5 and 0.5/2) analysis plots - Generate L'Abbe plot(s) (for further details please see attached file) Ideal Skills and Experience: - Proficie...
I'm looking for a comprehensive Excel dashboard that can help me manage resources for my projects. This project will involve visualising project management data, with a focus on resources management and planning. The key elements of this dashboard will include: - Resources Planning: Visualising the availability of team members, their skills and current project assignments. This should help me in efficiently allocating resources for various tasks. In addition to these, I'm also interested in other data such as budget tracking and milestone tracking. The ideal candidate for this project should have experience in: - Advanced Excel skills, with a focus on creating visually appealing and user-friendly dashboards - Experience in designing project management dashboard...
To help streamline operations in our manufacturing firm, I'm seeking a professional with deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills and experience for this task.
Hiring a hybrid NYC remote assistant for a clean energy company. Job is Mond...calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of working pr...
I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and work through complex data structures...
I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and e... Irwin & Dow - Premier Recruitment - ManpowerGroup - Mark Williams - Robert Murray - Future Tense - Black & Grey - Education 1st recruitment - Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets.
i will create 1 power power point and 1 excel sheet adding the equations
I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.
