Excel macro filling cells jobs
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'm seeking an expert in FileMaker to assist in creating a simple yet effective nutrition database. The project involves transforming the way I track my nutrition, currently done via an Excel spreadsheet, into a more sophisticated system leveraging FileMaker's capabilities. Key Requirements: - Each day should be a separate record in the database - Daily food items will need to be selectable via both a search function and a drop-down menu/list - Nutritional values should be linked from a resident table - The system should generate summary reports over various time periods (week/month/year) and allow data to be assembled in different ways (e.g. grams of protein from seafood in March, average grams of tuna per day, etc.) - The database should utilize advanced structures with...
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 portfolio demo...
...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.
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 a professional developer who can create a macro 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 ...
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 am looking for professionals experienced in developing macros for SolidWorks, specifically in the SWOOD module. The goal of the project is to optimize and automate key processes within this environment, ensuring efficiency and precision in design. Key Requirements: - Proven experience in developing macros in SolidWorks. - Advanced knowledge of the SWOOD module. - Ability to understand and adapt solutions to customized processes. - Capacity to document and explain the developments made. - Good communication skills and willingness to collaborate with our technical team. Project Details: - Creation and/or modification of specific macros for process automation. - Integration of advanced SWOOD functions within SolidWorks. - Testing and adjustments to ensure optimal functionality. Initially...
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...
I'm seeking an efficient and detail-oriented freelancer for manual Excel data entry of product inventory. The job primarily involves: - Inputting data from various sources into Excel spreadsheets - Ensuring the accuracy and completeness of the data - Identifying and rectifying data discrepancies Ideal candidates should have: - Proficiency in Excel - Excellent attention to detail - Experience with data entry - Skills in identifying and correcting errors in data Please apply if you have these skills and are ready to start immediately.
I'm looking for a skilled Excel developer who can create a customized desktop-based Excel application for me. This application should help me track my progress on various claims, manage each claim, and keep a record of estimates I need to write and follow-up calls I need to make. Key Features: - Progress Tracking: I should be able to see my progress on each claim. - Claim Management: Each claim needs to be accounted for. - Follow-Up Reminder Notifications: The application should have a system for reminding me of follow-up calls so no claim gets lost or forgotten. The ideal freelancer for this project should have extensive experience with Excel and desktop application development. They should be able to deliver a comprehensive tracker that is easy to navi...
I'm looking for an experienced SAP OOPS coder with a strong focus on ALV Reports. Key Requirements: - Expertise in implementing factory method ALV grid output - Ability to import data from Excel into ALV Reports Skills and experience: - Proficiency in SAP OOPS coding, particularly in ALV Reports - Prior experience in Module Pool programming - Knowledge of creating and manipulating ALV Reports for various functionalities - Strong understanding of Object-oriented programming within SAP - Familiarity with Excel data import processes in SAP OOPS
I need assistance in creating a Macro that would convert data from multiple worksheets in an Excel workbook into pipe-delimited flat files. - Data Source: The data is sourced from multiple worksheets within the same Excel workbook. - File Representation: I want specific worksheets to be converted into flat files, not all of them, nor a single combined file. -Worksheet Selection: The specific sheets to be included in the conversion follow a particular naming pattern. - Create header from a specific cell in worksheet and pull data from specific row Ideal skills for this project should include: - Proficiency in Excel Macro Please include examples of similar past projects in your bid.
As a student, I am in the process of developing an Excel spreadsheet for a project. I require professional assistance in creating this spreadsheet, which will primarily involve numerical data. Key Needs: - Implementation of Formulas and Functions: I need these to manipulate and analyze the data effectively. - Creation of Charts and Graphs: These will be used to visually represent the data, so I need someone skilled in designing clear, accurate, and visually appealing graphs. - Using Pivot Tables: I need help in organizing and summarizing my data using pivot tables. Ideal Skills: - Advanced Excel expertise: You should be proficient in using Excel and have a strong understanding of its features. - Data Analysis Skills: You should be able to help me analyze my numerica...
I require a system to automate the processing of results from Microsoft Forms. This includes generating reports in Excel and sending automatic emails via Outlook based on the results. For example if the answer to one of the questions on the microsoft form is "NO" an email will automatically send to a specific email address with other key data from the microsoft form. Key requirements: - Create an automated system to generate Excel reports from Microsoft Forms results. - Develop a mechanism for sending automatic emails through Outlook based on the data. - Ensure the system is user-friendly and efficient. Skills & Experience: - Proficient in Microsoft Forms, Excel and Outlook. - Previous experience in automation of data processing preferred. - Strong und...
I need assistance with entering text data from online content into Excel. The job involves basic formatting such as using bold and italics where needed. Ideal skills and experience for the job include: - Proficiency in Excel - Attention to detail - Ability to follow formatting instructions - Familiarity with data entry from online sources
I need an experienced Excel professional to refine my financial report. The tasks will primarily involve: - Creating visually appealing and informative graphs and charts - Specifically, I need a pie chart to represent a portion of the data An ideal freelancer for this project should have: - Extensive experience with Excel, particularly in working with financial reports - A keen eye for detail, ensuring all visual representations are accurate and well presented - Skills in creating engaging and informative visuals that can enhance the readability and understanding of the report Please include examples of similar projects you've completed in your bid. Thank you!