Excel vba import csv file into worksheet jobs
I'm in need of a freelancer to assist with entering data into an Excel spreadsheet. The data will need to be organized by date for easy reference and future use. The project will focus on the following tasks: - Accurately entering data into Excel - Organizing data by date - Ensuring the data is error-free Experience with Excel and a keen eye for detail is crucial for this project. The ideal candidate will have a background in data entry, especially within Excel, and be proficient in using Excel functions for organization.
I'm looking for a skilled developer who can create a program that will facilitate the sending of multiple emails from an excel spreadsheet, with a PDF attachment. Key requirements include: - Using Gmail as the email service provider. - The emails will be sent to multiple recipients with the same content. - The frequency of sending emails is irregular. The main responsibilities of the program are: - Extracting email addresses and any other necessary information from the spreadsheet. - Attaching a PDF to each email. - Sending out the emails. Ideal skills: - Proficiency in Python or similar programming language. - Experience in working with Gmail API. - Proven track record in developing email automation tools. Please note that while personalization is not currently required, t...
I need a python programme to download historical prices on daily basis of a list of stocks from the BSE India (Bombay Stock Exchange) website. Data should be stored in csv or excel file. Retrieve data accurately and efficiently.
I need a fluent, efficient typist to convert an English PDF into an doc -formatted Word document. Requirements: - The primary task is to convert the text from the PDF into a Word document. The original PDF is in English. - The Word document must be formatted in doc style. Familiarity with this style is a must. Pdf file must be typing and i need word .doc file . The PDF does not contain any tables but does include images. These images need to be included appropriately in the Word document. Ideal Skills: - Proficient typist - Strong understanding of APA formatting - Experience with incorporating images in Word documents Please provide a brief description of your relevant experience.
I'm seeking a freelancer skilled in Excel, Numbers, and Constant Contact, to collaboratively prepare and execute a one-time mail merge email campaign. Key Requirements: - Use the provided Excel list to create a mail merge email. - The purpose of the email is to promote a product or service. - Assistance in designing the email content is needed. The ideal candidate should have: - Proficiency in Excel or Numbers for mail merging - Experience with Constant Contact, particularly in executing mail merge - Ability to design visually engaging email content Your role will be paramount in ensuring a successful email campaign. Please include examples of previous work, particularly in email marketing, in your bid.
I have a sizeable amount of data that I need inputted into Excel to generate reports. This data is a mix of textual information and numerical data. There are numerous columns that this data needs to be sorted into. The ideal candidate for this job will have: - Proficiency in Excel and experience in data entry - An understanding of how to organize mixed data into clear, readable reports - Strong attention to detail to ensure accuracy of the entries - Good time management skills to complete the task in a reasonable timeframe. I need the output to be organized, coherent, and easily understandable, so please only apply if you have a strong background in Excel and data entry.
I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.
I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure
...maintaining dependencies and task sequences. Set up triggers to initiate automations based on specific actions (e.g., task creation, completion, or status change). Email Integration: Integrate our email system with ClickUp to enable direct email sending from within ClickUp. Ensure that email addresses prepopulate as contacts' details are typed into the email address field. Create and configure email templates for common communications. Contact Management: Import and manage a large contact list (approx. [specify number]) within ClickUp. Ensure synchronization of the contact list with external sources if needed. Checklists and Task Management: Organize and automate around 20-25 checklists with varying numbers of tasks. Set up dependencies and automate the flow of tasks ...
I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accou...
...of a proficient designer with experience in SVG file creation for both laser cutting and etching purposes. The project entails transforming my hand-drawn sketch design into an SVG file format, showcasing simple yet specific shapes. The following are the project specifications: - The SVG file will be used for a medium-sized (1-3 ft) project, meaning attention to detail in scale factor is essential. - The material targeted for laser cutting and etching is acrylic. Hence, prior experience working with this material will highly be considered. Ease in following instructions, excellent communication skills, and the ability to creatively interpret sketches into clean digital designs will be key in picking the ideal candidate. I’ve attached a file...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in ...the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. ...
...suppliers, products, and purchase orders from various data formats (CSV, XML, JSON) and seamlessly import them into Microsoft Dynamics GP 2016. This will greatly enhance the efficiency of our purchasing workflow and eliminate the need for manual data entry. Ideal Skills and Experience: - **Microsoft Dynamics GP 2016 Proficiency**: A thorough understanding of Microsoft Dynamics GP 2016 is essential for this project. Previous experience working with this ERP system is a must. - **Database Manipulation**: Given the preference for direct database manipulation, the selected freelancer should be proficient in creating secure, efficient, and reliable integrations. - **Data Formats**: The ability to work with multiple data formats, such as CSV, XML, and JSON, is cru...
...as players progress through the endless waves, keeping gameplay engaging and unpredictable. - Design dynamic environments that evolve and present new obstacles or opportunities as players face more difficult waves of zombie pets. - Introduce periodic challenges and special events within the endless mode to shake up the gameplay and provide additional objectives or rewards for players who excel in their survival efforts. 5. Art and Sound Design: - Create visual cues and feedback that convey the increasing intensity and complexity of each successive wave of zombie enemies as players persevere. - Develop audio cues and immersive sound effects that enhance the tension and excitement of facing relentless zombie onslaughts in the endless mode. - Design striking visual e...
I'm in need of a freelancer who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validati...
...can create a Windows GUI application. This app should be capable of opening and editing a pre-formatted CSV file. Key Features: - The app should have interfaces for inputting free-form English text in certain fields and selecting options from drop-down menus in others. - It must offer normal file saving and opening functionalities. - The design should incorporate a professional and corporate-looking splash screen graphic and an about page. User Interaction: I aim for a straightforward user experience. The app should be intuitive and easy to navigate without the need for an extensive guided walkthrough. Ideal Skills: - Proficiency in Windows GUI app development - Experience working with CSV files and handling user inputs - Strong understanding of UI/UX desi...
...skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project w...
...delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go to Horse Index A-Z Starting with letter A all the way through
I'm in need of a professional who can help me edit a PDF document. I would like to make some text edits, add some new text, and also enhance the document with the additio...PDF document. I would like to make some text edits, add some new text, and also enhance the document with the addition of a few images. Ideal Skills: - Proficiency in PDF editing - Skilled in text addition and reformatting - Experienced in image editing and addition I already have the original document that was used to create the PDF, so you can make the required changes directly from the source file. I would prefer someone with a keen eye for detail and design, who can make the document visually appealing as well as functionally accurate. Please reach out if you're confident in your PDF editing and ...
...school (e.g., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availabilit...
...a WordPress real estate theme for my website. Additionally, I need the developer to transfer all listing information from an existing website to the new one. Project Details: Theme Installation: Install and configure a WordPress real estate theme that I will provide. Hosting: Recommend and choose a suitable hosting package. Data Transfer: Extract all listings from a specified website and import them into the new WordPress site. Focus Area: The new website will only feature the sales section. Requirements: Experience with WordPress theme installation and customization. Familiarity with real estate themes. Ability to transfer data accurately and efficiently. Strong attention to detail to ensure all listings are correctly migrated. Good communication skills to update me on...
I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.
...descriptive statistical analysis: You should be able to generate valuable insights from the data and present it in a clear and comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the data which includes calculating the central tendencies, measures of dispersion, and other relevant statistical indicators. You will also need to present this information in a visually appealing format that is easy to understand and digest. I am looking for a freelancer who is not...
Wanting a sketchup file with the terrain and image matches and scaled
...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity w...
...API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refu...
...Blog section - All type of Users can read, like, share on multiple social media platforms, and add comments on posts (only logged in user), - Admin: content creators can login to write and publish blogs in their desired design and format. Blog contents could be videos hosted on YouTube and other platforms • University data and pages - Admin: o can update university data in bulk using excel or other supported file formats o can update individual university data from university page (separate login for data entry operators, data is published online once validated by a proper assigned user on the admin side) - Public users (no login required) o Can search universities based on key factors such as country, program name etc., - Registered student users (have an account) o...
Please Sign Up or Login to see details.
I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed an...
Seeking someone to fix, or create a file: for new hires to complete onboarding forms. Currently, when new hires join our agency, they receive and fill out mountains of paperwork. My agency will not move away from having hand signed forms and documents. Before someone is hired, we mail a packet containing forms to complete and turn in on their first day along with other agency information. When they arrive on their first day, (aside from the documents they’ve received in the mail), we provide more forms to complete. So they’re stressed by starting a new job, and now they have to shuffle through all these forms and papers, it’s a lot to deal with. I’ve already started the process of changing this. My idea is this: new hires will still receive the pap...
I am looking to significantly revamp my home's exterior in order to increase its c...include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and the capability to execute window replacements and dormer additions smoothly. Previous experience working on similar proj...
I need an experienced 3D designer to modify an STL file quickly. The specific modifications are unspecified, but I need them done promptly. The final deliverable should be an STL file, though I'm open to other file formats. It is essential that the designer has the ability to make complex modifications and is experienced in the software necessary to perform the task. Please bid only if you're available immediately and can work on the project promptly.
I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to support my marketing ef...
I'm in need of a freelancer with the ability to translate English to Chinese (and vice versa) and experience in selling products on AliExpress in China. AliExpress uses two log...AliExpress communication with the customers so that the customer only received our branded confirmation e-mail? 5. What are the fees for the Intake of Merchandise. Storage, Order Picking, Packing Materials, etc.? 6. What are the international shipping rates for underwear (~80 grams total weight)? 7. How to integrate the AliExpress back-end with the Shopify back-end? 8. How are custom forms for the import of packages created? In the event the initial assessment turns out positive, we would like to hire the candidate for the actual application process with AliExpress and for other ad-hoc tasks on a lon...
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
I'm in the business of importing and distributing promotional products. The goods are mainly m...I'm keen to ensure that all products being dealt by my business are REACH compliant. Thus, I'm looking for an expert in REACH compliance who has experience with items such as these. Ideal skills would cover: - Expert knowledge in REACH compliance - Experience in the advertising and promotion products industry - Proficient in compliance for plastic and aluminium items - Detailed understanding of import and distribution sectors The role will involve scrutinizing the products I deal with to ascertain REACH compliance and advise or implement necessary actions. Your expertise will greatly contribute to the sustainability of my business, adhering to environmental guidelines a...
I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.
I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.
I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets ...
I'm in search of a skilled video editor to work on my projects which are typically 5-10 minutes in length. Requirements: - Experience in Cinematic style video editing is desired. - Proficiency in various editing techniques such as color grading, slow motion, and animated text. - Ability to work on videos of 5-10 minutes. This role would suit someone with an eye for detail, creative flair, and a strong understanding of narrative structure. Please provide examples of your previous work that align with these requirements.
...developer who is adept at developing systems using PowerApps and PowerPages. The task at hand involves creating an appraisal system for an organization, which includes the following elements: - Performance tracking - Goal setting and tracking - Feedback and comments section The system will not integrate with any existing systems, instead, it will be a standalone system with the capability of data import/export. A key prerequisite for this task is understanding and implementing varying access levels based on the role hierarchy of the organization. Each role within the organization will have different user permissions. Restrictions will be employed, allowing certain roles comprehensive access, while limiting access for others. The ideal candidate should be experienced in PowerA...
I have an illustration file that needs some detailed work in Photoshop. I am specifically looking for someone who can enhance details by hand, and not just run the file through a software. The main focus will be on small details, specifically the fine lines on characters. I've noted that the print size is showing poor resolution in the eyes of the animals, and this is particularly what I want fixed. The lion and zebra are eye level for a child ( this is a kids playroom) and they need to be better quality....without changing the color and feel of the mural. We have tried using other people and they run it through a software that is changing the other parts of the mural. Key Skills: - Proficient in Photoshop - Attention to detail - Experience in enhancing fine l...
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...
I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numer...
This is a quote for starting the work on this page: We will transform the pages to static HTML with creating a simple CMS to manage the articles.
This is a quote for starting the work on this page: We will transform the pages to static HTML with creating a simple CMS to manage the articles.
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I want someone who can convert my pdf file to word file
I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sor...
