Filling cells excel vba jobs

Hi, I have done it as discussed.

I need support with the ICE application, specifically filling out the IEng Experiential Learning Application Form. The role includes: - Technical Support: I need a professional who can assist in filling up the form with the required technical specifications. - Guidance: I require step-by-step instructions on how to complete the form. Ideal candidates for this project should have: - Proficient knowledge of the ICE application. - Excellent communication skills for clear instructions. - Experience in technical support and form filling guidance.

...Vendor/contractor database for outsourced maintenance or repairs. • Assign tasks to staff/vendors and track progress/costs. 8. Advanced Analytics • Occupancy trends, vacancy patterns over time. • Maintenance cost analysis (by property/unit). • Potential for predictive insights (rent forecasting, AI-driven maintenance). 9. Import/Export & Data Migration • CSV/Excel bulk-import for existing records (properties, tenants, etc.). • CSV/Excel export for accounting, sharing with partners, or offline analysis. • Simple data migration tools to ease transition from legacy systems. 10. Security & Compliance • Role-based access control, encrypted credentials, and secure endpoints. • Audit logging (track who edited what ...

I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks

EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce on lase...

I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that the data is correctly organized.

I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intuitive interface. Plea...

I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!

I'm seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and ability to present d...

I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details

I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: ...Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projec...

We are looking for...unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for reporting progress. Payment Structure: - $100 for every 50 live and verified links. - Bonuses available for exceptional performance and securing links from high-authority sites (DA 50+). Websites You Can Offer in Exchange:

I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Hiring and interviewing team members - Managing existing team and content in excel Skills and Experience: - Strong communication skills English/Hindi - Proficiency in Excel and PPT Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.

I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.

I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills

I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you have a solid ...

...addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel, Google Sheets). Strong web research...

PHP Survey Script Tweaks Project Description: I have installed a raw PHP survey script and require the following customizations to improve its functionality and user experience: Optimize CSV Import Performance: ...This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for graph enhancements) Experience with data processing and performance optimization Deliverables: Improved CSV import functionality with faster processing and guaranteed file availability. Graphs with displayed values inside bars. Averages displayed in both on-screen reports and exported Excel files. Additional Notes: Please ensure the changes are thoroughly tested before delivery. Let me know if you require access to the server or additional information to ge...

Delivery Cost Mapping for WooCommerce example below Base Pricing by County and Weight Tier County Light (€) Medium (€) Medium Heavy (€) Heavy (€) Very Heavy (€) Fastway (€) Dublin 20 30 60 80 100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcha...

...data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Experience with Figma to web replication - Strong understanding of minimalistic design principles - Ability to work wi...

I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .

...in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Excel and Go...

Looking for a detail-oriented data entry specialist for product catalog management. (~1,500 products) Key responsibilities: Manual data entry of product information into Excel/Google Sheets Accurately copying product image URLs from provided online sources Following provided guidelines for data organization Requirements: Strong attention to detail Proficiency in Excel/Google Sheets Reliable internet connection Ability to handle repetitive tasks with accuracy We provide full training and ongoing support throughout the project. Part-time/flexible hours available. Please share your relevant experience and availability to get started.

We are looking for a DLL written in C# that can be used with MS Access through VBA code using late binding. The library should be capable of sending controlled error emails from MS Access and returning a response confirming the success or failure of the sending.

I'm looking for a professional who can assist me with the onboarding process for Zepto, BlinkIt, and Bigbasket. Your responsibilities will include: - Guidance & consultation on the best practices for onboarding - Help with form filling and documentation - Providing ongoing support after the initial onboarding process Ideal candidates for this project should have extensive experience with these platforms, excellent understanding of their onboarding processes, and be able to provide strategic advice. Good communication skills and a proactive approach to troubleshooting will be key in ensuring a smooth onboarding journey.

Project Brief: eCommerce Data Analysis and Visualization Objective: To leverage data analytics tools to enhance decision-making, improve sales performance, and optimize customer experience within an eCommerce platform. Key Contributions: Excel: Cleaned, organized, and processed large datasets to ensure accuracy and consistency. Conducted advanced analyses using pivot tables, VLOOKUP, HLOOKUP, and data validation techniques. Developed dynamic dashboards for real-time tracking of sales, inventory, and customer metrics. Power BI: Designed interactive dashboards to visualize KPIs like revenue growth, cart abandonment rates, and customer acquisition. Connected multiple data sources to create unified reports, providing actionable insights for stakeholders. Implemented DAX functions f...

I'm looking for a freelancer to help me link my Excel file containing employee names and shifts to another file. The data is personal and related to roster information. Ideal skills for this job include: - Proficiency in Excel - Experience with data linking - Understanding of personal data handling and privacy - Attention to detail

I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those involving dashboard creation and automation.

I'm looking for an expert in data management and Excel/CSV manipulation. The project involves merging multiple CSV files with custom combination rules. Key Responsibilities: - Analyze and understand the structure of the provided CSV files. - Implement custom rules to merge specific data from those files. Ideal Skills: - Proficiency in handling and merging CSV files. - Excellent understanding of Excel and its data manipulation capabilities. - Ability to understand and apply custom rules for data combination. - Strong attention to detail. Experience with data science or data analysis is a plus.

I'm seeking an Excel specialist to design a financial dashboard for monitoring investments. The dashboard will primarily display financial data and needs to be tailored to track investment metrics. Ideal Skills: - Advanced Excel skills - Data visualization - Financial analysis - Dashboard creation Your proposals should reflect your experience with similar projects.

...a map. Display active trips with pickup and drop-off points. Heatmaps to show areas with high demand or low supply. Well-Organized KPIs: Track drivers, passengers, trips, and revenue. Clearly display statistics in an interactive and accessible way. User Profiles & Reports: Detailed profiles for drivers and passengers (with activity and performance history). Exportable historical reports (CSV/Excel). Notifications & Alerts: Automatic alerts for zones with demand-supply imbalances or high cancellation rates. Manual notifications to users directly from the dashboard. Specific Requirements: Experience with Similar Projects: Dashboards for transport or delivery platforms. Real-time tracking with interactive maps. Technical Skills: Proficiency in Flutter Web (mandatory). E...

...for my Excel file "Report1". Here's the functionality I need: - When the user clicks the "Select File" button in the Excel file, they should be able to choose the Word document (e.g., "SampleForm1"). The macro should transfer the text fields from the Word file to the corresponding columns in the Excel report. - Additional clicks on "Select File" should add a new row for each new entry. - The Word file uses legacy forms, which may complicate things, but this needs to be handled. Considerations: - The software versions in use are Office 365. - Text fields from the Word file should match with the columns in the Excel file by field name. - If a field from the Word file does not exist in the Excel template, it...

I'm seeking a diligent data entry professional to help with manual data entry from printed documents into Microsoft Excel. Key Responsibilities: - Manually transcribing data from printed documents into an Excel spreadsheet. - Ensuring accuracy and attention to detail during the data entry process. Ideal Skills and Experience: - Proficient in Microsoft Excel, including knowledge of basic functions. - Prior experience with manual data entry. - Excellent attention to detail and ability to maintain focus over extended periods. Please only apply if you have experience in manual data entry and can maintain high levels of accuracy.

I am looking for an Excel professional with strong problem-solving and analytical skills to assist with data analysis. Ideal candidate should be: - Well-known in the field of Excel - Proficient in data analysis - Excellent at problem-solving - Able to create complex formulas - Skilled in data visualization

...online advertising, click data, or anti-fraud systems is preferred. - Familiarity with popular automation testing frameworks and tools (e.g., PyTest, Selenium, etc.). - Ability to set up and maintain testing environments, simulate user behavior, and design tests for boundary cases and abnormal scenarios. - **Data Analysis & Problem-Solving Skills** - Proficiency in using tools like SQL and Excel for data extraction and analysis. - Strong logical thinking and analytical skills to quickly identify and report issues discovered during testing. - **Communication & Teamwork** - Excellent communication skills with the ability to collaborate effectively with development, product, and security teams. - Highly self-motivated and responsible, able to perform well and m...

I am looking for an Excel expert who can create a shortest distance freight matrix for me using Australia's NHVR route planning tool. The matrix will be based on specific truck combinations that I will provide. Initially, I will supply a list of origins and destinations, but I need the matrix to be easily expandable for future use. Key Requirements: - Creation of a simple distance-only freight matrix - Integration of a user-friendly Excel form to add new locations - Incorporation of specific truck combinations into the route planning I am not familiar with programming or VBA, and I would like to know if this project is feasible before awarding it. Please, check the NHVR API tool link: Ideal candidates should have

Job Title: Create Excel/Google Sheets by Extracting Data from Instagram Profile Description: I am looking for someone to analyze my Instagram profile and create an Excel or Google Sheets file based on publicly available data. The file should contain 3 separate sheets with the following information: Followers: A list of all followers. Likes: A list of all users who liked a specific post. Comments: A list of all users who commented (only the names of the commenters). Platform: Instagram only Data Scope: Approximately 320 individuals total (for all three categories). No additional data will be provided. All information can be extracted directly from my public Instagram profile. Deliverable: A clear and organized Excel or Google Sheets file with the above information in ...

...technical 2D drawings (.dwg or .dxf) with standard views (front, section, details) and a complete Bill of Materials (BOM). The assembly includes only 4 non-standard parts; all other components are ISO/DIN standard pieces. Deliverables: Final assembly file in .x_t/.step format. 2D technical drawings in .dwg/.dxf and exported as PDFs. Updated BOM included in drawings or as a separate Excel file. Important Notes: Only apply if you have expertise in bearings and mechanical assemblies. Bids should include your price based on the details in this ad. No price negotiations will be conducted. The project must be completed within 3 days. Please indicate how soon you can start. If you have experience in mechanical engineering and CAD assembly, please submit ...

Please Sign Up or Login to see details.

I need an Excel sheet designed to facilitate data entry, enhanced with picture drop-downs and regular option drop-downs. Key Features: - More than 10 drop-downs in total, strategically placed to aid data entry - Picture drop-downs, with images inserted directly into the Excel sheet - Regular option drop-downs for standard data input Ideal Skills and Experience: - Proficiency in Excel - Experience in designing user-friendly spreadsheets - Ability to creatively incorporate images into an Excel sheet

I'm looking for a skilled data visualization expert to design a Tableau dashboard primarily for sales analysis. The dashboard will be used by analysts to deri...will be used by analysts to derive insights and make informed decisions. Key Requirements: - Proficiency in Tableau with a strong portfolio of previously designed dashboards - Expertise in sales analysis - Excellent understanding of data visualization principles - Ability to design intuitive dashboards for analysts Data Sources: The dashboard will draw data from various sources, predominantly Excel/CSV files and databases (SQL, NoSQL). Experience in integrating these data sources into Tableau is crucial. Please note that the primary users of the dashboard will be analysts, so the design should cater to their needs an...

I have a dataset in an Excel spreadsheet containing purchase order details. I'm looking for a skilled data analyst to perform descriptive analysis and multi linear regression on this data. The primary goal is to identify trends in purchase orders. The analysis should focus on the order value for the regression analysis. The job needs to be completed and delivered within 24 hours. Ideal Skills and Experience: - Proficient in statistical analysis and data interpretation - Experienced with multi linear regression techniques - Capable of delivering comprehensive analysis reports under tight deadlines

I am looking for an experienced data specialist to create a comprehensive Excel guest tracking sheet for my ranch. The sheet should include all necessary details about our guests: name, address, email, birthday, nights stayed, food allergy/preferences, family names, clothing sizes, hometown, education, personal habits, licenses and notes. Key project features: - Pre-designed template: I have logos that need to be integrated into this Excel sheet. The sheet should be aesthetically pleasing and professional. - Organized by invitation category: The guests should be categorized based on who invited them to the ranch. The categories are "BCI, MSI, CWI or Other". This categorization should be easily accessible and not buried in the notes section. - Seasonal tracking: Th...

...adverts or documents localized to Namibia. Scraping Local Newspapers: Collect tender advertisements published in local Namibian newspapers. Scraping Specialized Websites: Scrape two key websites that focus on advertising tender documents: A government-owned website (URL to be provided). A subscription-based website (URL to be provided). Data Output: The scraped data should be exported to an Excel file with the following details: Entity Name: The organization publishing the advert/document. Publication Date: When the advert was published. Closing Date: The deadline for submission. Contact Information: Any available contact details. Download Link: A direct link to the tender advert/document. Scraping Frequency: The scraper should run daily and only scrape data published on the ...

I'm looking for a professional with excellent data entry skills to help me transcribe mixed data from physical documents into an Excel spreadsheet. Requirements: - Proficient in Excel and data transcription - Able to accurately transcribe mixed data (text and numeric) - Experience working with physical documents - Attention to detail to ensure data is entered correctly

I need an Excel macro that can automate the creation of product labels. The macro should be able to generate labels that include: - SKU number - SKU Description - UOM (Unit of Measure) - Up or Down Arrow The ideal freelancer for this project should have extensive experience in Excel and VBA (Visual Basic for Applications) for creating macros. Please provide examples of similar projects you have completed. The macro should recognize various size labels based on avery sheet label sizes. The Description, font size and number of characters should adjust based on size of label. I have existing file but would like to review as I speak to a developer to ensure needs are understood before sharing.

Excel project as discussed And separating the pdf bills

I'm looking for an Excel expert to set up a comprehensive database for tracking customer information, specifically contact details and addresses. Key Requirements: - Design an Excel database to track customer information effectively. - Incorporate automated data entry forms to streamline data input. - Develop customizable reporting templates for tailored data analysis and reporting. Ideal Skills & Experience: - Proficiency in Microsoft Excel, with extensive experience in database setup. - Prior experience in designing automated data entry forms and customizable reporting templates. - Knowledge in data analysis and reporting.

I need assistance with data entry and PDF file management. Specifically, I have a series of PDF bills that need to be processed. Tasks: - Enter bill details from the PDF into an Excel sheet with specific column headings. - Split the PDF files into smaller PDFs based on date ranges. Ideal Skills: - Proficient in Excel with experience in data entry. - Familiar with PDF splitting software or tools. - Attention to detail to ensure accurate data entry and proper file splitting.

I'm in need of a skilled developer who can create an API for me that retrieves various product data in real-time. This includes everything listed on an Excel file I will provide, such as price information, inventory status, and product descriptions. Key responsibilities: - Develop an API that can retrieve all product data listed on the provided Excel file - Ensure the API operates in real-time - Implement necessary data transformation for optimal retrieval Ideal skills and experience: - Proficient in API development - Experience with real-time data retrieval systems - Familiarity with handling and transforming data from Excel - Prior experience with product data APIs is a plus. Please bid only if you can deliver a high-quality, efficient and reliable API. Tha...