Excel macro csv cells jobs

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'm in need of a scraping tool that can help me identify potential bids from various government bid sites. This tool will need to access the API from known bid sites, and pull specific information from these sites. Key Requirements: - Target Government bid sites exclusively - Extract bid title...access the API from known bid sites, and pull specific information from these sites. Key Requirements: - Target Government bid sites exclusively - Extract bid titles and descriptions - Extract submission deadlines - Extract bidder requirements Data Delivery: The extracted data will need to be delivered to me in a CSV file daily. Ideal Skills: - Proficiency in web scraping and API integration - Experience with government bid sites preferred - Strong skills in data extraction and...

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 ...

As an intermediate data science learner, I'm seeking a seasoned Data Scientist to help me deepen my understanding and skills in various areas. Key Areas of Focus: - Machine Learning Algorithms: I would like to gain a comprehensive understanding of different algorithms and their applications. - Data Visualization: I need assistance in mastering this crucial aspect of data science. - Stati...tutor will have: - Extensive experience in data science and machine learning. - Strong teaching skills, able to simplify complex concepts. - Hands-on experience with big data tools. - Proficiency in data visualization and statistical analysis. I'm looking for a tutor who can provide practical examples and exercises to help solidify my understanding. Read and prepare interpretations on the b...

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 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...

...its functionality and user experience: Optimize CSV Import Performance: Currently, importing large CSV files takes too long and sometimes fails to provide a file for download. I need this process optimized for efficiency and reliability. Enhance Graph Display: The results include graphs, but the values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. 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...

...tool should be able to perform an advanced search on Instagram to locate users based on multiple parameters, specifically gender, age, and city. Details: - The automation should search for users across these three specific parameters: Gender, Age, and City. - Once the users are located, the system should save their profiles for future reference. - I need the ability to export the saved data into a CSV file. Ideal candidates for this project should have: - Extensive experience with Instagram's API. - Proficiency in Python or a similar programming language. - Prior experience with creating automation tools and handling data export. - A solid understanding of Instagram's user demographics and search parameters. Please note, the primary goal of this project is to create...

I'm looking for an AI application that can create precise and engaging auction listing descriptions based on images of items, primarily collectibles such as toys and models. Key Requirements: - The AI should assess the condition of the items. - It should be able to identify the quantity of items in a lot. - It should ...improve in time. Ideal Skills and Experience: - Proficient in AI and Machine Learning. - Experience in developing applications for auction platforms. - Understanding of collectibles, specifically toys and models, would be a plus. - Strong skills in image recognition technology. Please note, the platform for integration hasn't been decided so initially, needs to be application that generates a csv export. The application should be able to handle multipl...

...need to put those screenshots on Anki flashcards. This is a huge project since it's about taking screenshots of 52 episodes. To find the best candidate for the task as a whole, I'm holding this contest. Afterwards, we'll discuss a rate for the entire project. You will need to take screenshots of episode 2 for this task. Find attached a CSV file with a few French sentences. You'll need to watch the show and take screenshots when the sentences in the Excel are said. Each sentence has an ID like LoF-FR-EN-0001. The respective screenshot where this phrase is said should be named "". Make sure to capture the very best moment for each sentence. You might need to watch the same scene several times for that. If there's a dialogue, make sure the...

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.

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.

...on 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 (man...

...deny vacation requests. - **Vacation Calendar**: A comprehensive calendar showing approved and planned vacations. - **Vacation Entitlement**: Manage and calculate vacation entitlement based on company policies. ##### **2.4 Reporting and Analytics** - **Work Hour Reports**: Generate reports on working hours, overtime, and absences. - **Export Functionality**: Export reports in common formats (e.g., CSV, PDF). - **Dashboards**: Visualize working hour data and key performance indicators. ##### **2.5 Licensing and Monetization** - **Subscription Management**: Integration of subscription models (e.g., monthly, annual). - **Feature Tiers**: Offer different feature levels (e.g., Basic, Pro, Enterprise). - **License Activation**: Enable activation of features based on purchased license...

...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...

...for variant consequences, reference local gnomAD and ClinVar databases for allele frequencies and clinical significance, and output an annotated CSV or TSV file. Key Requirements - Must run locally without internet connectivity. - Incorporate local gnomAD and ClinVar data (no external API calls). - Support ANNOVAR or Ensembl VEP (developer can recommend which is more suitable for a fully offline workflow). - Capture essential variant details, including gene/transcript info, predicted impact, and any other relevant annotations from the chosen tool. Input/Output - Input: Standard whole-exome VCF file(s). - Output: Annotated variant file in CSV or TSV. Local Databases - Use local copies of gnomAD (population allele frequencies) and ClinVar (clinical significance). - Pr...

I need assistance converting a CSV file containing geometry data formatted as WKT (Well-Known Text) into a DXF file. The DXF must maintain the curves present in the original geometry data. After the conversion, I also need the project to be visualized in QGIS 3.x. Ideal skills and experience for this job include: - Proficiency in working with CSV and DXF file formats - Extensive experience with QGIS, particularly version 3.x - Strong understanding of WKT (Well-Known Text) format - Ability to maintain curve integrity during file conversion - Excellent visualization skills using QGIS Please note that the specifics regarding the types of curves included in the geometry data have not been defined, as this was skipped in the project questionnaire. Therefore, your ability to ...

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'm looking for an expert to help me in setting up a comprehensive Notion dashboard, optimizing my existing SOPs, and creating useful templates and databases. Key Res...templates and databases. Key Responsibilities: - Create a Notion dashboard tailored to my needs. - Optimize existing SOPs for better clarity and efficiency. - Develop a task template and KPI dashboards that can be populated via CSV upload. - Establish a database linked to my existing web page, incorporating forms for data collection. Ideal Candidate: - Proficient in Notion with a strong understanding of project management. - Experienced in creating and optimizing SOPs. - Ability to create user-friendly templates and dashboards. - Skilled in data management and CSV uploads. - Familiar with web page link...

Create plugin that export email and 10 more WooCommerce DB columns data and create CSV to downald. All WooCommerce DB columns data on images, client can choose user_email and 10 more option from 51 option (exemple on image). Colums names in CSV the same as in exemple images with one exeption, user_email in csv shuld have email column name. Plugin on start show 10 option, on click show all option to export (exemple on image). All operation on exemple images from 1 to 4. Plugin name to be added above the option selection fields. IMPORTANT: - Plugin should have ourself code, not copy from diffrent plugins. - Transfer of full rights to the plugin to us. - The plugin should have the option to check automatic update. - The plugin must be multilingual. - The plugin must be...

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

We are a production company seeking a skilled freelancer with experience using ZoomInfo and Facebook Ads to build targeted advertising campaigns. Specifically, we are looking for someone who has successfully: 1. Extracted data from ZoomInfo and exported it as a CSV file. 2. Uploaded the CSV file into Facebook Ads Manager to create a custom audience. 3. Launched targeted ads based on this audience. Requirements: * Proven experience with ZoomInfo and Facebook Ads integration. * Ability to demonstrate previous successful campaigns or examples of work. * Familiarity with creating and managing custom audiences on Facebook. * Attention to detail to ensure compliance with data privacy and ad guidelines. Project Scope: * Guide us through the process of using ZoomInfo to extract data....

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 n...

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

...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.