Excel worksheet vba jobs
I need to convert data from XML to Excel. I've got an example XML file that can be used as a reference for the conversion. Ideal Skills: - XML - Excel - Data Conversion - Attention to Detail Please ensure that the conversion is precise and matches the structure of the example XML.
I'm an e-commerce seller seeking a proficient Excel specialist who can create formulas and automate processes for my inventory tracking. Key Responsibilities: - Develop Excel formulas and automate processes to enhance efficiency - Create inventory level alerts to prevent stock shortages - Conduct sales tracking and analysis to inform business decisions Skills & Experience: - Advanced Excel skills with a focus on automation - Previous experience in e-commerce inventory management - Proficient in sales tracking and data analysis.
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
...expectations. • Provide timely and well-documented cost breakdowns for bids, proposals, and budget planning. Qualifications & Skills • Experience in material takeoffs and cost estimation in [industry, e.g., construction, manufacturing, engineering]. • Strong understanding of engineering drawings, blueprints, and CAD models. • Proficiency in estimation software (such as Bluebeam, PlanSwift, Excel, or industry-specific tools). • Ability to work with engineers, architects, and project managers to refine estimates. • Strong analytical skills with attention to detail. • Excellent communication and negotiation skills for working with vendors and suppliers. • Ability to manage multiple projects and meet tight deadlines. Preferred Qua...
I am seeking an Excel expert who can create a master Excel file and a child file with limited columns. The key requirement is that both files need to be synchronized, ensuring that any changes made in one file are automatically reflected in the other. Key Tasks: - Create a master Excel file with specified columns (details will be provided) - Create a child Excel file with limited columns - Set up synchronization between the two files - Use IF formula where necessary to ensure smooth functionality Ideal Skills: - Proficient in Microsoft Excel - Experience with IF formula and other Excel functions - Ability to create and manage linked files - Detail-oriented to ensure accurate synchronization The synchronization should be triggered by any of the ...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
I'm in need of an Access database designed specifically for reporting and analyzing opera...storage and retrieval while also providing general reporting capabilities. Key requirements include: - Development of custom reports tailored to my operational data needs, specifically Profit and Loss Statements on a per operating unit and collective/all units basis. - Creation of user-friendly dashboards for easy data visualization. - Implementation of automated data import processes involving excel and/or cvs file uploads. Ideal candidates for this project should have: - Extensive experience with Microsoft Access database development. - Strong skills in data analysis and reporting. - Prior experience in designing dashboards and custom reports. - Knowledge of automating data imports i...
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
I'm seeking a professional to review and optimize the VB code in my Excel file, which has been modified over the past 20 years. The primary goal is to streamline the code for future users. The code has sections that handle macros and automation scripts. These scripts involve data import, formatting, and report generation. Ideal skills and experience for the job: - Proficient in Visual Basic for Applications (VBA) - Extensive experience with Excel - Previous experience in code optimization for performance - Excellent problem-solving skills, particularly with macros and automation scripts - Ability to simplify complex code for future understanding
I need assistance with integrating my Excel spreadsheet with an API and webhooks to fetch customer data from external sources. I am not quite sure which API service to use, so your expertise in identifying the appropriate REST, SOAP, or GraphQL API will be crucial. Key Requirements: - Understand and implement API integration in Excel - Expertise in identifying suitable API services - Experience in working with webhooks - Proficient in Excel I am looking for someone who can automate the process of fetching this data, allowing for a seamless and efficient workflow. Your experience with manipulating Excel for data processing tasks will be a significant advantage for this project. Please provide examples of similar projects you've completed in your bid.
I need an Excel expert to build and automate a user-friendly price sheet for me. Key Requirements: - The sheet should cover various categories: electrical items, labor, markup, taxes, etc. - The price sheet should be easily exportable to PDF & CSV format. Ideal Skills: - Strong proficiency in Excel - Experience in building automated Excel sheets - Ability to create user-friendly interfaces - Understanding of pricing components (labor, markup, taxes) - PDF & CSV export experience The goal is to create a comprehensive, user-friendly, and automatable price sheet that I can use for various categories. Please only apply if you have the relevant experience.
...Reference for expense categories and summary formats. Milestone 4: Final Review & Revisions ($15) Tasks: Apply final corrections based on feedback. Deliver the completed spreadsheet with all data cleaned, formatted, and summarized. Files to Reference: All project files (including feedback notes, if provided). Final versions of the cleaned data and formatted tables. Guessing python, power query, vba, macros, some AI workspaces or other data analyst tools can make this smooth for you. Need done by Feb 13. Budget is $80 ...
I am in need of a seasone...and monthly reports. These reports will be derived from our job sheets, which are Word documents stored in Dropbox. Key Responsibilities: - Develop an automated system using Power Automate to generate weekly and monthly reports from our job sheets. - Ensure this system sends the reports to our management team. - Present the data in an easily digestible format using Excel. Ideal Skills: - Proficient in Power Automate and Excel. - Excellent understanding of data visualization through graphs. - Experience with interpreting and reporting on employee performance, repeat clients, and staff performance data. As for the data visualization, the type of graphs used will depend on the specific data being presented. Therefore, a flexible and analytical mind...
I'm looking for a skilled Excel developer to create a custom Excel form for me. This form should automate the generation of professionally designed, formal and professional PDF donation receipts. The Excel form will need to collect: - Donor information - Donation amount and date - Custom messages or notes The ideal freelancer for this job should have extensive experience in Excel, PDF generation, and ideally has a background or understanding of creating formal and professional documents. The final output should be a single receipt per PDF.
I need a data entry form with over 100 fields. The form will...need a data entry form with over 100 fields. The form will be used for inputting mixed data (text and numbers). The entered data should be able to be synced into 10+ sheets with the push of a button. Requirements: - Design a data entry form with 100+ fields - Mixed data input (text and numbers) - Data synchronisation into 10+ sheets manually with a button Key Skills: - Proficient in Microsoft Excel or Libreoffice Calc - Experience in creating complex data entry forms - Knowledge in setting up data synchronisation - Familiarity with data validation rules Some fields in the form will need validation, so experience with setting up data validation rules is essential. Please reach out if you have the relevant skills and e...
...encouraging and supportive work environment? We are looking for a trustworthy and reliable EA/PA for a philanthropist / filmmaker with an interest in wildlife. The tasks will involve working on ad-hoc projects with the charities, film shoots and assistance with personal matters. The role is not just about organisation - it’s about a long-term partnership. If you have excellent communication skills, excel with logistics, have an analytical mindset and enjoy making this happen, the role is for you. Please note that the role is remote-based and the client is primarily based in Europe. Main tasks Carrying out various personal assignments of the manager related to business: real estate search, insurance, service provider companies; Search for contractors for assigned t...
I need assistance with data entry focused on numerical data sourced from printed documents. The data needs to be entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry from printed documents - Ability to handle numerical data Please note, this project requires meticulous data handling to ensure accuracy and completeness.
Sending Email and PDF generation from Excel
...Display of Seating Chart: A live seating chart should be available to display on a TV screen at the library branch. This will help new subscribers see which seats are available in real time. 10. Technical Requirements: Frontend: HTML, CSS, JavaScript (React.js preferred) Backend: Node.js with (or Django/Flask if using Python) Database: MySQL or Firebase for storing seat assignments Excel Handling: Google Sheets integration for exporting and updating seat reservations 11. User Roles: Library Owner/Admin: Full access to assign/release seats, manage branches, and add/delete seats. Staff: Can assign and release seats but cannot modify system settings. 12. Expected Outcome: A fully functional seating arrangement system with an intuitive UI. Real-time updates on seat reservatio...
I would like to request the completion of data extraction for all matches of the 2024-2025 season and the integration of this data into the existing file while maintaining the Excel format. Additionally, please provide me with the source code used for the data extraction process. Let me know if you need any further details. Looking forward to your response. Please note that the final deadline for submission is today. Let me know if you need any further details.
I'm seeking an experienced d...experienced data analyst to dissect COVID-19 data. The focus will be on death and recovery rates, with the ultimate aim of pinpointing the geographical spread of the disease. Key Aspects: - Analyze death and recovery rates from COVID-19 - Identify geographical patterns in the data - Present findings in a clear, accessible format Ideal Skills: - Proficiency in data analysis software (e.g., Python, R, Excel) - Strong statistical skills - Ability to communicate complex findings simply - Ability to visualize and present data in a smooth, easy-to-understand manner Expected outputs: - The file should contain data analysis and graphics that illustrate these analyses. Deadline: - It is preferable to deliver the work within seven days from the date of...
Service Member Excel Tracker. I need an Excel spreadsheet with automated formatting and drop-down lists. Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered. Drop-Down Menus – "Types of Service" in Column B "Reason(s) for Visit" in Column I with all the requested options below: • Army Credentialing Assistance • ArmyUniversity BNCEDP • ArmyIgnitED Enrollment • ArmyIgnitED Problems • ArmyIgnitED Information • ArmyU Credentialing • BSEP Counseling • Chapter Counseling • College Information • Commissioning Assistance • Dashboard • Exception to Policy Counseling • Financial Aid Information • HE Track C...
Service Member Excel Tracker. I need an Excel spreadsheet with automated formatting and drop-down lists. Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered. Drop-Down Menus – "Types of Service" in Column B "Reason(s) for Visit" in Column I with all the requested options below: • Army Credentialing Assistance • ArmyUniversity BNCEDP • ArmyIgnitED Enrollment • ArmyIgnitED Problems • ArmyIgnitED Information • ArmyU Credentialing • BSEP Counseling • Chapter Counseling • College Information • Commissioning Assistance • Dashboard • Exception to Policy Counseling • Financial Aid Information • HE Track C...
I'm looking for a skilled Excel VBA programmer who can help me fix my current VBA code. The code is supposed to automate repetitive tasks, but it's producing incorrect results. - Code Fixing: The primary task will be troubleshooting and fixing the existing VBA code. - Automation: After fixing, I will need the coder to enhance the script to automate more tasks in Excel. Ideal candidate should possess: - Proficient knowledge in Excel VBA - Experience in coding for task automation - Problem-solving skills to rectify existing code - Attention to detail to ensure accuracy in results.
I need 50 thousand companies name and Email. This should be only from CHINA region and the companies should be manufacturer. This is on urgent basis The data should be provided in an Excel file format. Focus on manufacturers in the Technology industry. The data should be delivered within 2 days. Please include the following details: Email and company name. No Please include the following additional details for each company: None. The data should be collected from: any site. Ensure all email addresses are verified for authenticity and validity. None. Please ensure the emails are specific to the Manufacturing department.. PLEASE SEND 5000 SAMPLE FIRST TO GET AWARDED THIS IS URGENT SO ONLY REAL PERSON.
...40). The sessions should be held on separate dates, March 3-7, 2025, and March 24-28, 2025. May choose to hire for one or both sessions. Pay: $4,000 per session, not to exceed $8,000 total for both sessions. Travel costs will not be provided. Trainee Skill Levels: Attendees have varying levels of experience with Power BI, ranging from basic to intermediate, with many being advanced Microsoft Excel users. The training should accommodate this diverse skill set. Content: The training must cover topics such as connecting to data sources, data cleaning, data visualization, advanced analysis techniques, creating dashboards, and sharing reports. All training materials must be provided digitally at least one day prior to the start of training. The training must also include demos a...
...company channel. 3. Company Channels & Groups: o A dedicated company-wide channel for announcements. o Ability to create department-specific or project-based channels. 4. Direct Messaging & Group Chats: o Employees can chat one-on-one or create group conversations. o Read receipts and typing indicators for real-time communication. 5. File Sharing & Storage: o Upload and share documents (Word, PDFs, Excel, images, etc.). o Cloud storage integration for easy file access. 6. Communication History & Search: o Chat history is saved for future reference. o A search function to find messages, files, or contacts. 7. Notifications & Alerts: o Push notifications for new messages, mentions, and file shares. o Customizable notification settings for users. 8. User Roles &a...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
I need assistance with a data entry task involving mixed data (both text and numbers). The data is sourced from digital files in Excel format. Key Requirements: - Proficient in Excel, with excellent data entry skills. - Able to accurately transcribe mixed data (text and numbers). - Detail-oriented to ensure data integrity. - Prior experience in similar data entry tasks is preferred.
I have a basic rules file edited in...basic rules file edited in notepad or similar. I would like to duplicate and modify the rules (name, 5 conditions and 2 values) into the duplicated rules. I have all the data that needs inputting in an excel table. I am happy to enter the required data but am looking for a tool that will create/edit the rules file with the desired amounts. I have a rules file in notepad that needs to be rewritten into an Excel file. The rules are conditional formatting rules and are relatively simple. The data in the notepad file is structured as plain text with delimiters. Ideal Skills: - Proficiency in Excel - Understanding of conditional formatting rules - Ability to interpret plain text with delimiters Experience in data entry and condition...
I'm looking for a skilled Power BI dashboard developer to assist me in creating a comprehensive dashboard. The primary purpose of this dashboard is to track various performance metrics. Requirements: - Integration with Excel spreadsheets - Visualization of data in the form of charts and graphs Ideal Skills: - Proficient in Power BI - Extensive experience with Excel - Excellent data visualization skills - Strong understanding of performance metrics tracking Please provide examples of your previous work with Power BI dashboards.
I'm seeking an Excel expert to upgrade my existing sheet, initially designed for resource capacity planning, to incorporate varying cost calculations dependent on the project at hand. Key Requirements: - The upgraded Excel sheet should be suitable for project management, particularly in resource planning. - It should allow for the use of multiple labor rates in cost calculations, reflecting the different costs associated with various projects. - The sheet should be able to accommodate changes in cost based on the specific project being worked on, enhancing the accuracy of resource cost forecasting. Ideal Skills: - Extensive experience with Excel, particularly in creating complex formulas and calculations. - Prior experience in project management resource plannin...
I'm looking for a professional who can assist me in sending promotional broadcast messages to my customers via WhatsApp. - Content: The broadcast will primarily consist of promotional off...messages to my customers via WhatsApp. - Content: The broadcast will primarily consist of promotional offers. - Customer List: I already have a ready list of customer phone numbers, so I need someone who can efficiently handle the sending of the messages. - Format: My customer list is in an Excel/CSV file, which I can provide. Ideal skills for this project would include experience with WhatsApp Business API, understanding of promotional messaging best practices, and proficiency in handling Excel/CSV files. Knowledge of data privacy regulations and best practices for customer co...
You will get a high-end and robust calendar based entirely on Excel! I have over ten years of experience in automating tasks in Excel using formulas and VBA code, and I know that a few automations at the right spots can simplify your daily routine, save you dozens of hours, and boost your performance while focusing on what matters! In the delivered calendar, you will have the option to customize the categories/personnel that will be assigned the tasks or appointments. Based on the selected version, more features are available, like customizing colors, attaching documents, exporting to PDF, and more.
I'm seeking a data analyst with experience in SQL and Crystal Reports. The task invol...crystal report to generate monthly Intrastat declarations derived from our sales data. This data is stored in a SQL database and needs to be transformed into Excel format for the reports. Key components of the reports: - Sales data fields: Product information, Transaction value, Date, Invoice No, Customer Name, Item Description, Quantity, Item Amount Value, Nominal Code, SIC, Weight Each, Line Weight Amount, Gross Amount Value, Type, Customer VAT No. - Customer-based segmentation for the reports. Ideal skills: - Proficiency in SQL and Crystal Reports. - Experience with sales data analysis. - Ability to segment data by customer. - Excel expertise for report formatting. Looking forw...
I'm looking for a professional with extensive experience in MS-Access and VBA to help me fine-tune my existing database. This database tracks the stays (assignments = Ents) of school members (participants = Tln) who are doing internships or foreign courses at specific locations (hosting organizations = AO). Ideal expertise: - MS-Access (2016) proficiency - VBA scripting skills - Data integration troubleshooting - Report generation optimization The project involves: - Modifying the existing forms and layouts - Improving the data integration between tables - Enhancing report generation Most of the tables, forms, queries, and reports are already set. However, some integration points need to be adjusted, and this is where your expertise will come in handy. An extensive do...
I'm seeking a proficient English typist to assist with transcribing scanned images into PDF documents. The tasks will include: - Typing documents from scanned images - Data entry into MS Excel - Copy and paste tasks Ideal candidates should have exceptional typing skills with a knack for accuracy and speed. Proficiency in MS Word and MS Excel is a must, as well as experience with data entry. If you're capable of delivering high-quality work in a timely manner, I look forward to your proposal.
I need a freelancer to transcribe a research questionnaire into an Excel spreadsheet and populate it with 500 dummy data entries. Key Requirements: - The questionnaire consists of 60 questions, most of them in a Likert scale format and focused on collecting demographic and behavioural data. - The final Excel file should simulate 500 responses to the questionnaire, based on criteria provided Ideal Skills: - Proficiency in Excel - Experience with data entry and data simulation - Familiarity with Likert scale and behavioral research. Please ensure that your proposal includes relevant experience and a brief outline of your approach to this task. Include the word 'Ninja' in your PM.
Need help organizing messy Excel data ? I'm here to assist! With expertise in Excel, I offer professional services to clean, format, merge, and split data, ensuring your files are organized and ready for use. Services Provided: Data Cleaning: Eliminate duplicates, fix errors, and maintain data integrity. Data Formatting: Apply consistent styles, format dates, and more. Data Merging: Combine data from multiple sheets or files seamlessly. Data Splitting: Separate data into categories or individual sheets. Custom Solutions: Tailored services to meet your specific needs. Why Choose My Services? Experienced: Skilled in Excel with a focus on accuracy and efficiency. Timely Delivery: Committed to meeting your deadlines. Client-Centric: Your satisfaction is my priority...
I'm looking for an efficient Executive Assistant who can help me manage my daily workflow. The primary focus will be on data management and organization. Key Responsibilities: - Manage and organize data using Microsoft Excel and Google Sheets - Sync my calendar with existing calendar apps Ideal Skills: - Proficiency in Microsoft Excel and Google Sheets - Experience in data management and organization - Excellent coordination and communication skills Good communication skills Good English spoken as well as written
About this Gig: "Is your data messy or not organized? I can help!" With my skills in data cleaning, processing, merging, and splitting, I will turn your raw data into a clean, organized d...I will combine data from multiple sources (spreadsheets, CSV files, databases) into a unified, comprehensive dataset, ensuring smooth integration. Splitting: I will split large datasets into smaller, more manageable segments or break down columns into multiple categories, improving clarity and usability for better decision-making. Why To Choose My Services? : Skilled in Excel, Python and MySQL & Detail: I pay close attention to every aspect of your data to ensure its error-free and well-structured. Pricing: Professional data services at a competitive rate
I'm a skilled professional to design a Power BI dashboard that analyzes various Human Resource trends. The dashboard will effectively track metrics such as attrition rate, average salary, and retention rate. Key Requirements: - Proficiency in Power BI and Excel - Experience with HR analytics - Ability to visualize complex data and trends clearly The dashboard will utilize public datasets alongside our internal data to create a comprehensive view of our HR trends. The primary users of this dashboard will be our HR managers, so the design should cater to their specific needs and decision-making processes. The ultimate goal of this project is to empower our HR team to understand attrition trends and make informed decisions with 100% accuracy. A specific focus will be on how sa...
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I'm seeking a proficient English typist to assist with transcribing scanned images into PDF documents. The tasks will include: - Typing documents from scanned images - Data entry into MS Excel - Copy and paste tasks Ideal candidates should have exceptional typing skills with a knack for accuracy and speed. Proficiency in MS Word and MS Excel is a must, as well as experience with data entry. If you're capable of delivering high-quality work in a timely manner, I look forward to your proposal.
I'm looking for an Excel script that can automate the checking of my SKUs against a consolidated list that includes URLs and titles. The script will need to perform the following tasks: - Check against a consolidated list with URLs and titles - Download images - Rename files according to the SKU The SKU list is located in an Excel file and the consolidated list with URLs and titles is also provided in an Excel file. Ideal skills and experience for this job include: - Proficiency in Excel and Excel scripting - Ability to create scripts that can automate repetitive tasks
I need assistance in converting a multi-tab Excel file into a detailed table for record-keeping purposes. The data should be organized in the table by category. Key details: - The table should only contain raw data, with no specific calculations or summaries needed. - The ideal freelancer for this project should have strong Excel skills and experience in data organization.
I'm looking for a professional who can design an Excel spreadsheet tailored to my specifications. The primary purpose of this spreadsheet will be analyzing sales data, with a specific focus on product performance. Ideal Skills and Experience: - Proficient in Excel and its advanced features - Experience in designing spreadsheets for data analysis - Understanding of sales metrics and product performance tracking
...reliable working relationships, clarifying rights and responsibilities, and minimizing potential disputes. To simplify this crucial process for you and provide professional support, I am here to offer freelance contract development services. Areas of Expertise: Understanding your business and industry is my priority. I provide tailored solutions for contract development in online platforms, Word or Excel documents, in both English and Turkish. Whether it's a general template or a customized contract, I can address all sorts of contract requirements. Diverse Industry Experience: From capital corporations to real estate sectors, construction projects to business relationships, I can assist you with creating contracts that cater to specific needs across various industries. T...
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
