Excel vba projekt jobs

I am looking for draftsman to complete some house plans with CAD and dimensions for the attached excel sheet. Please get in contact of you have any queries Regards

I need an experienced Excel professional to create a 5-tab spreadsheet based on a study I have. (Toddler Parameters, Toddler Budget, Infant Parameters, Infant Budget, Total Budget tabs) - The first two tabs will be for data input and analysis results, respectively. Information for the parameters are found on the study, (Total staff, salary, total students, overtime, ) parameters should include all costs and revenues. - Text descriptions will be the primary parameters to be plugged into the spreadsheet. - The spreadsheet should feature automated calculations and data validation to ensure accuracy and ease of use. Categorys in the toddler and infant budget tabs should be label by months (Jan - Dec) screenshot of examples of what it should look like are also below. Need to have ex...

I need help modifying an Excel spreadsheet to ensure names and addresses are formatted correctly for UPS shipping software. This project mainly involves changes to the layout and overall formatting of the spreadsheet. See attached files from Unishippers as to format needed and spreadsheet that needs to be changed

We have an existing spreadsheet of names and locations of people. We'd like to enrich this data set with additional columns of information, including work history information and graduation dates. This will require doing research on each person in the data set through LinkedIn and other websites to gather the correct info on their professional and academic background.

I need a comprehensive report based on two tasks: 1. A detailed analysis of Qlik's e-book "Turn your Excel Reports into Stunning Dashboards." This should include what you learned and insights on data visualization, dashboard design, and excel integration. 2. An exploration of a business application from the Microstrategy website. You'll need to choose an industry, select a business application, and write a report on the insights gained from the associated video. The final report should be 4-5 pages long, formatted in APA style, and include at least three references. Ideal candidates will have strong skills in data analysis, report writing, and familiarity with APA formatting. Experience with Qlik and Microstrategy is a plus.

I'm seeking a skilled Excel VBA developer to create a utility that interfaces with both Serial Communication and IP data, sending the parsed information directly to specific columns in an Excel worksheet for further processing. Key Requirements: - The data being received is mixed, comprising both numeric and text elements. - A significant portion of the project involves data visualization, so experience in working with graphical representations of data in Excel is a must. - The selected freelancer will need to program the utility so that it reflects the parsed data in specific columns of the worksheet. Ideal Skills: - Proficiency in Excel VBA - Experience with data parsing from Serial and IP sources - Strong understanding of data visualiz...

...Using VBA in Excel I am reaching out to seek your expertise in creating an interactive Excel model that includes dropdown boxes and filtered tables using VBA. The goal is to replicate a system where selecting an item from a dropdown box (e.g., a country) automatically filters a table to display relevant data. Key Requirements: Dropdown Boxes (Combo Boxes): Create dropdown boxes that allow users to select specific criteria (e.g., cities, statuses). The dropdown should be populated with a predefined list of items. Interactive Filtering: Upon selecting an item from the dropdown, the corresponding table should automatically filter to display only the rows that match the selected criteria. The filtering should be dynamic and update instantly when a differen...

I need someone to create a quick stock summary sheet. I will provide an Excel file with the 2024 sales data, along with an example format. Your task is to locate the corresponding buy data from the 2020-2022 period using the transaction records I provide and complete the final 2024 Excel sheet based on the given format. Do not use AI please. I will send the buy data ,once you are selected

I am in need of an expert in operations research and mathematical modeling who can develop a multi-objective, multi-period location-routing model, based on several critical assumptions like heterogeneous vehicle and differents types of products. Ideal Ski...Proficiency in developing complex models for multi-objective optimization. - Strong understanding of both location and routing optimization. - Proficiency in GAMS programming. For this task, I expect the following deliverables: 1. Review the proposed model and adjust the formulation as needed to ensure valid results. 2. Refine the mathematical model in GAMS and validate it using test instances in Excel. 3. Implement the multi-objective weighting method to solve the problem and assess the relative importance of the objective ...

I'm looking for a skilled Excel expert to create a comprehensive tracking sheet for my daily store visits. The sheet should have a tab for each day, and a master tab that compiles all customer information and interaction feedback. Requirements: - Track customer interactions during each store visit. - Record specific details about each customer interaction, primarily comments and feedback. - Categorize feedback into follow-up items. Ideal Skills: - Proficiency in Excel. - Experience with data tracking and analysis. - Ability to create user-friendly and organized spreadsheets.

I'm looking for an Excel expert who can create an intuitive spreadsheet for tracking job preparation based on asset availability. Key features: - The spreadsheet should track various statuses such as: - Not Started - In Progress - Completed - Asset not available - Mobilized - Ready for mobilization - Color-coded cells indicating the status of job preparation and mobilization. Ideal skills: - Proficiency in Excel - Experience with project tracking tools - Good understanding of color-coding for status tracking With this tool, I'll be able to easily monitor the progress and prepare accordingly.

...Create additional tables in DB as needed to accomplish tasks 3. Each record will have several actions that can be done to each i. update status ii. Attach documents iii. view details iv. update 4. System will also have ability to run reports that will export into excel as needed. 5. We will have several other functions i. manage users ii. manage techs iii. equiptment management functions Must be a clean and professional front end. Phase 1. is Proof of concept and needs to be done very quickly. NOT fully functional but have the framework up and some ba...

...received goods meet quality standards and report discrepancies. ✅ Restocking & Alerts: Notify the team about low-stock items and help in restocking plans. ✅ Basic Reporting: Generate simple stock reports to support decision-making. Requirements: -> Education: Any graduate or undergraduate (preferably in commerce, business, or supply chain-related fields, but not mandatory). -> Skills: Basic MS Excel/Google Sheets knowledge, attention to detail, and good organizational skills. -> Work Setup: Own a laptop and stable internet connection (if remote). -> Availability: Should be available for 4 hours per day (flexible timing). -> Mindset: Eager to learn, proactive, and able to work independently. What We Offer: ⭐ Flexible Work Hours – Work 4 hours a day at yo...

As agreed!?

I have some work, in an Excel spreadsheet.

I'm seeking an Excel Online expert to help me set up individual spreadsheets for each of my collaborators, linked to a global billing spreadsheet. Key Requirements: - Create separate, individual Microsoft Excel Online spreadsheets for each collaborator. - Each spreadsheet should have 'Edit permissions' for the respective collaborator, allowing them to input their own data. - The data from the global billing spreadsheet should be reflected in the individual sheets automatically and in real-time, without the collaborator having access to the global spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel Online. - Experience with setting up complex spreadsheet systems. - Knowledge in automating data updates across spreadsheets. - Excel sheets ...

Data gathered to an Excel file. Data gather to excel file

I'm in need of an Excel sheet specifically designed for calculating construction costs. The sheet should encompass: - Material Costs - Labor Costs - Total Project Cost In addition, I'd like the sheet to incorporate specific Excel functions and formulas such as: - Sum and Averages - Conditional Formatting Ideal candidates for this project should have a strong background in Excel, particularly with creating complex sheets for cost analysis. Experience in the construction industry would be a plus. Please bid with a brief overview of your relevant experience and examples of similar projects you've completed.

I'm a university student seeking a mentor to help me navigate my data module. The focus is primarily on using Excel functions to sort numerical data. Key Responsibilities: - Interpret and explain the tutorials provided - Help me understand and apply Excel functions to sort numerical data - Provide guidance on data analysis techniques Ideal Skills: - Proficient in Excel - Strong understanding of data analysis - Previous experience tutoring or mentoring university students Looking forward to your bids.

...manual data entry. Usability & Documentation: The model should be user-friendly, with clear documentation explaining the assumptions, methodology, and structure used. Expertise Required: Subject Matter Expertise: A solid understanding of the cattle export industry, supply chain management, logistics, and market dynamics. Financial Modeling Skills: Expertise in building detailed financial models in Excel or other modeling software. The ability to manipulate existing models, apply new metrics, and forecast financial outcomes accurately. Financial Analysis & Ratios: Strong ability to calculate and interpret financial ratios, assess the financial health of businesses, and conduct thorough financial analysis. Experience with Scenario Analysis & Sensitivity Testing: Abilit...

I'm in need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior

I'm looking for an experienced Excel macro developer to create a macro that will import data from a specific TXT file on my computer and format it to match my PDF example. I currently pull the data from an IBM and it is saved on my windows computer as "AP Data." I then need to be able to open an excel workbook and run a macro that will import "AP Data" and format it so it matches the PDF example identically. All numbers in the excel worksheet after import need to be formatted as accounting so something that appears on the PDF Example as 7.50- will change to (7.50). The print area needs to match the PDF example. There are page numbers at the top right of each page and that needs to be how it prints in excel. Below is th...

I'm looking for a professional with expertise in Bartender Software. I need to create barcodes pulling from specific fields in a Master data spreadsheet. The spreadsheet is located in Egnyte and is co-edited using Microsoft Excel Online. The fields I am interested in include GTIN, Catalog Number, Lot Number, Serial Number, Expiration Date, and Quantity. This data needs to be pulled from filtered data based on a blank Allocation column (see attached spreadsheet) Ideal skills and experience for the job: - Proficiency with Bartender Software. - Experience in barcode generation and software integration. - Attention to detail to ensure accurate data pull for barcode creation. Please reach out if you have the necessary skills and experience.

...add office service charges before finalizing the bill. • Generate PDF invoices for clients. • Track payments received from clients and mark invoices as paid/unpaid. 5. Reports & Dashboard • Dashboard Overview: o Total Expenses Logged (Daily/Monthly/Yearly) o Total Pending Reimbursements o Total Payments Received vs. Outstanding o Vehicle Files in Progress vs. Cleared • Ability to export reports (Excel/PDF) for accounting. 6. Web-Based Deployment • Secure login authentication for staff & admin. • Data backup & recovery mechanism. Technology Stack Recommendation: (Developer can suggest alternatives if needed) • Frontend: React.js / Vue.js (Modern UI Framework) • Backend: Node.js () or Laravel (PHP) • Database: MySQL / Post...

I'm seeking for a professional who can help me extract contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting contact information from customer accounts on the website - Delivering the extracted data in an Excel spreadsheet Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail to ensure all relevant contact information is extracted - Experience with delivering data in Excel format Please provide a concise proposal detailing your experience and approach to this project. Show me scraping first 50 details like name,mail,contact number with your term project.

I am in need of a skilled female Indian professional with expertise in Tally and Excel to assist with data entry and recording. The primary focus will be on tracking expense and income. Key Responsibilities: - Accurate data entry of expenses and income into Tally and Excel - General assistance and guidance in categorizing data Ideal Candidate: - Proficient in Tally and Excel - Excellent attention to detail - Able to provide guidance in data categorization - Female Indian professional

I am looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina, South Carolina, Alabama, and Georgia. in the form of an Excel spreadsheet. All hosts are acceptable and there are no specific criteria for inclusion in the list. The ideal candidate should have experience in data mining and compiling email lists. Attention to detail is crucial to ensure that the list is accurate and up-to-date. The list should contain the following: Name, phone number, and email address, and should all be valid and up to date information. We will need around 1000 leads to start.

I'm seeking a professional ...in one location, and we also have to be about to seperate all material and labor $ so we can add sales tax to Material, and or to Labor and show that on the proposal. (many of our jobs are Sales tax exempt on Material and Labor is usually not taxed.. but sometimes is. Key Requirements: - Expertise in cost estimation for materials and labor. - Proficiency in spreadsheet software, particularly Excel. - Ability to present a detailed breakdown of costs clearly and concisely. Your experience in creating or modifying estimating spreadsheets will be crucial for this project. We currently have a spreadsheet but think it could be modified so it it is easier to update material costs, add materials and create "kits" We will provide our existing ...

I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.

I'm seeking assistance with a data entry task involving daily stock prices. Key Responsibilities: - Copy stock prices from the NSE website and Investing.com. - Paste the information accurately into an Excel file. Ideal Skills: - Proficient in Excel. - Detail-oriented to ensure data accuracy. - Familiarity with stock market terminology is a plus. Experience: - Previous data entry experience, particularly with financial data, will be highly regarded.

We are a local plastering and drylining company in Cannock, Staffs WS11 7LG, currently in need of a qualified freelance Quantity Surveyor (QS). The ideal c...of a qualified freelance Quantity Surveyor (QS). The ideal candidate will be responsible for conducting take-offs for both dry lining and plastering. Key Responsibilities: - Regularly attending our office once or twice a week (local to Cannock is a must) - Conducting accurate take-offs for both dry lining and plastering - Delivering take-offs in digital format (Excel files) Skills and Experience: - Proficient in Excel - Prior experience as a QS in the plastering and drylining industry - Able to conduct both dry lining and plastering take-offs - Local to Cannock and able to attend our office regularly Ma...

I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.

...have been awarding projects for 10+ years. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the task ----------------------- Build an AI-enabled application which 1. Recognizes the correct column header and places the correct data in the correct column a. Excel b. Text c. Word document d. PDF 2. Recognizes hand-writing upload from 1. Image files (JPG, GIF or PNG) 2. PDF files 3. Compiles the data into a correct Excel sheet (for students, parent and teacher) 4. Uploads the data into our web application called Kontakkt Please read the attached project file carefully, which explains the output tasks We will provide the winning bidder with a live user account to login to Kontakkt, with data already inside there ...

I'm looking for an expert in Excel and VBA to help me create a custom workbook. The primary purpose of this workbook is to manage and collate employee time entries. Key Requirements: - Design a workbook tailored for tracking employee time. - Implement VBA code to hide and unhide specific worksheets based on user access. - The VBA code should allow each user to only access the worksheets I define. Ideal Skills: - Proficiency in Excel and VBA. - Experience in designing custom workbooks. - Knowledge in user-specific worksheet management through VBA.

I need assistance with entering numerical data sourced from online databases into an Excel Spreadsheet. Ideal Skills: - Proficiency in Excel - Experience with data entry - Familiarity with online databases Requirements: - Accuracy in data entry - Ability to follow instructions - Attention to detail

I need a skilled app developer to create a robust Android-only application for handling Excel formulas and performing calculations on financial data. Key Features: - The app should generate insightful reports and visualizations from financial data. - Ability to create and edit Excel formulas. - Perform complex calculations with ease. Ideal Candidate: - Proficient in Android app development. - Experienced with financial data processing. - Skills in creating data visualization tools. - Familiarity with Excel and its formulas.

I need an expert in either VBA or Python who can help me search, validate, and compare alphanumeric data in multiple cells in Excel. The results should be shared in another cell indicating whether the data is 'Matched' or 'Not Matched'. Key Requirements: - Proficient in either VBA or Python - Expertise in Excel data manipulation - Ability to implement custom logic for data validation and comparison - Capable of creating clear output in Excel Data Validation: - The data will need to be checked for specific patterns. - The patterns are not standard and will require custom logic to identify. Ideal Skills: - Strong experience with Excel's VBA or Python integration - Excellent problem-solving skills for creating custom data ...

I need an Excel guru to analyze my bank statement urgently. - Primary Data: The data to be analyzed is my bank statement. - Specific Analysis Required: I need help categorizing my expenses, as well as summarizing my income vs. my debits. - Categorization Method: All expenses should be categorized by merchant name. Ideal candidates for this project should have strong Excel skills, be able to work quickly and efficiently, and have experience in data analysis and expense categorization. Please apply if you can help me with this task urgently.

...results. 6️⃣ Multiple Test Selection Modes Flexible test selection options: Test by Test (individual test selection). Multi Test Selection (multiple tests at once). Packages or Groups (predefined test bundles). 7️⃣ Advanced Reporting & Graphs Comprehensive lab reports with detailed analytics. Graphs for repetitive tests to track patient progress. Export reports in various formats (PDF, Excel). 8️⃣ User-Friendly Interface (UI/UX) Icon-based navigation for ease of use. Dark Mode support. Multi-language support with easy switching. ? Additional Features: Mobile application for patients and doctors to track bookings and results. Cloud-Based or Local Server setup. Demo version required before finalizing the contract. --- ? Budget & Timeline Flexible ...

I'm looking to work with an experienced Excel specialist who can help me with advanced functions and automation, specifically with sales data. - I need assistance with VLOOKUP and HLOOKUP, PivotTables, as well as Macros and VBA. - The primary goal of the project is to identify trends within the sales data. - I also expect engaging charts, graphs, and summary tables to be created to represent the data visually. - Accuracy and attention to detail are crucial for this project. Ideal candidates for this project should have extensive experience with Excel and data analysis, as well as a keen eye for detail. Skills in creating visually appealing and informative charts and graphs will also be highly valued.

I'm seeking an experienced Data Analyst Trainer to join Xoon Infotech. If you're passionate about teaching and have expertise in SQL, Power BI, Tableau, Python, Machine Learning, R, and Advanced Excel, I’d love to hear from you! Key Requirements: ✅ Extensive experience in Data Analytics, Business Intelligence, or Data Science ✅ Proficiency in SQL, Power BI, Python, R, and Machine Learning ✅ Previous corporate or online training experience preferred ✅ Ability to conduct live online sessions and guide advanced-level students on real-world projects ✅ Excellent communication and mentoring skills What We Offer: ? Competitive Compensation – Get paid per session/hour ? Flexible Schedule – for weekdays and weekend batch ? Engaged Learners – Work with moti...

I'm looking for a simple IMEI database with HTML code that I can use for tracking devices. Key Requirements: - The database should allow me to search by IMEI number. The project will involve creating a basic IMEI database that is user-friendly and efficient for tracking device. I get text or excel file with IMEI and its unlocking code. I just want to upload so user just type in imei on page and can get code from that file,

I'm seeking an Excel expert to analyze my sales data. Deadline ASAP Budget is 20AUD

Hello Sophia, Attached is a Excel for translation into Ukrainian. SLA - March 11th. Thank you, G

Job Title: Freelance Data Analyst (Advanced Excel & Power BI Expert) Job Description: We are looking for a skilled freelance data analyst with strong expertise in advanced Excel, data management, dashboard creation, and Power BI. The ideal candidate should be able to analyze complex datasets, generate insights, and build interactive dashboards to support business decision-making. Key Responsibilities: Manage and clean large datasets efficiently. Develop and automate dashboards in Excel & Power BI. Perform data analysis to derive actionable insights. Create visual reports and interactive dashboards for stakeholders. Ensure data accuracy and integrity. Requirements: Proficiency in advanced Excel (PivotTables, VLOOKUP, Power Query, Macros, etc.). Experi...

I have a project that involves cleaning mixed data in Excel. Key Tasks: - Remove duplicates - Handle missing values - Standardize formats Ideal Skills: - Proficient in Excel - Experienced in data cleaning - Attention to detail and ability to follow specific instructions

I'm looking for an Excel expert who can make some changes to an Excel file. The task must be completed today.

...Italian. In addition, I have 2 files of phrases (totaling 188 phrases) that need to be translated, though audio is not required for these. Key Requirements: - Utilize an online voice synthesizer as per the attached instructions or any alternative that produces equivalent output. - Deliver the .mp3 files as 3 individual ZIP files, corresponding to each word list. Ideal Skills: - Proficient in Excel - Strong attention to detail (ensuring all output files are consistent in volume) - Familiarity with the Italian language (not compulsory, but preferred) - Native or advanced proficiency in simplified Chinese or Arabic (a plus, as we can discuss extending the project to include these languages) Additional Information: - A female voice should be used for female-specific words, and a ...

I'm seeking an experienced Excel professional to assist me in creating a dynamic table that will track employee data. Key Requirements: - The table should allow for filtering and sorting of data to facilitate easy navigation and analysis. - Data will be entered manually, so the structure needs to accommodate ease of input and maintenance. Ideal Skills: - Advanced Excel skills, particularly with creating dynamic tables. - Experience with data management, preferably with employee data. - Good communication skills to understand and meet project specifications.

Steps: 1. Go to 2. An Excel sheet with specified columns will be shared with you 3. Search database by state and compile information such as company, contact, url, email address, etc.