Vba import info web attached excel file jobs
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...
...created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to...
...providers in footer) - plugin for google analytics - facebook pixel SHOP Page: - play gif on hover like in reference1 - display name and price per product - product filtering styled to fit website design SINGLE product page: - photo gallery (possibility to have gif as main product photo, play indefinitely) - size picker - adjustable accordion selection, we will start with three sections: details, fit info and shipping as in reference website - product availability - one or two lines for product description - Checkout page Product categories: - we will start off with ​​all, hoodies, long sleeves, shirts, recommended but should definitely be adjustable if we add/remove categories in future product migration - dont need, we will create just one or two test product to test the we...
I need an experienced developer to handle a two-way synchronization between the Bling system and the ERP DeluxeUp. - You will need to import vendors from the Bling system and update their information on the ERP DeluxeUp. - Also, you'll update the Bling system with the latest information from the ERP DeluxeUp. - A GitHub connection is required for the DeluxeUp vendor registration. The synchronization process should be scheduled to run daily and should work efficiently. The ideal candidate for this project should have: - Proficiency in API integration, specifically with the Bling system and GitHub - Experience in two-way synchronization between systems - Strong understanding of the ERP systems Please note that access to the Bling system's source code is a requirement ...
Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi concrete market, one data point at a time!
I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.
I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.
I'm in need of a dynamic and well-connected brand ambassador for a new freelancing platform, Firmxxperts. Please visit for more info The ideal candidate: - Must possess excellent communication skills. - Have an established strong social media presence. - Have relevant experience in influencer marketing. Key responsibilities include: - Crafting compelling social media content that captures our message and engages our audience - Actively promoting Firmxxperts through collaboration with influencers -Actively promoting Firmxxperts on social media Our core target audience is freelancers looking for fresh opportunities. Therefore, a solid understanding of this demographic and their needs is key. Proven experience promoting services to this group is a huge plus. Looking
I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.
BILINGUAL WORDPRESS SITE that includes a basic CRM to manage content (in the form of products or services) and users. Once authorized users log in, they will be able to view specific info not shown publicly on the website. Web users must log in to view specific content. Admin should be able to assign what content may each user view. You must copy content that is available on a specific website I will provide you to this new WordPress site and adapt it to the image provided on the project I will send you before I select a freelancer. Website fully optimized for Mobile and Table View. URLs must follow a specific structure (view on slide 4 of the project). Once the project is completed, uploaded to my server and fully working the project will be paid in full. To secure you...
I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the abil...
I'm in need of an expert WordPress developer or programmer with a keen understanding of JSON API, URL redirection, and content importation. The specific project tasks are: - Import diverse news content types — including text, photos, and video articles — from JSON API into my WordPress site. - Perform a one-time importation of these news articles with the view of possibly updating this in the future. - Undertake a URL redirection process where old URLs are successfully redirected to new URLs, minimizing any potential disruption for site visitors. Ideal candidates should have proven success with similar projects involving JSON API and WordPress, as well as URL redirection. Proficiency in handling large batches of data and importation tasks is crucial, and meticul...
Development and Enhancement of Excel VBA Project Tracker.
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
...recipe ingredients and I need nutrition info for all those ingredients from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate file. Outcomes - 1. My Excel files - with name...
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...
...focused on identifying Effluent Treatment Plant (ETP) and Sewerage Treatment Plant (STP) manufacturers, as well as wastewater treatment plant suppliers in Maharashtra. As a freelancer, your task would involve comprehensive research to compile a database of relevant companies operating in the field of wastewater treatment across Maharashtra state. The information gathered will be organized into an Excel sheet, including but not limited to: Company Name Email Address Website Address Location and Address Contact Number The scope of the research will cover suppliers located in major industrial estates and towns across Maharashtra. This includes but is not limited to areas such as Mumbai, Pune, Nashik, Aurangabad, Nagpur, and others with significant industrial presence. Your role ...
I'm seeking a skilled developer to integrate Steam login into my phpBB 3.3.11 forum. The project involves displaying public Steam profile information, and setting the integration to sync only when users request it. Key Requirements: - Implement Steam login: Users should be able to register and login to my phpBB forum using their Steam accounts. - Display Steam Profile Info: The integration should also automatically retrieve and display the user's public Steam profile information on their forum profile. - Sync on User Request: The integration should allow users to manually sync their Steam profile information with their forum profile. This should not be automatic. This plugin can replace the default phpBB login/register form and process to log them in using Steam when cli...
...an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past work as well as your experience in the field. This will assure me of...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required ski...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
I am seeking a talented website developer experienced in WordPress to build a website for a restaurant. This project requires in-depth knowledge of WordPress and excellent web designing capabilities. The envisioned website should consist of the following sections/pages: - Home - About - Menu (will be in PDF version) - Restaurant - Beach Club - Members Club - Gallery - News (for the blog, events, etc. types of articles) The page layout prototype is attached, along with the logo and fonts. You can use pictures from 3d interior and outdoor render, or you can use any suitable pictures from any photo stock. You are free to choose a suitable design template (after agreeing with me in advance). The main condition is that the final website should be no worse than competi...
...en and x-default <link rel="alternate" hrefLang="ar" href={`${location?.pathname}`} /> the location?.pathname is adding ar/tag to slug which is fine for ar, but for en and x-default it should only have /tag with no ar import React from "react"; import { graphql } from "gatsby"; import Layout from "../components/Layout"; import { Helmet } from "react-helmet"; import PostLoop from "../components/PostLoop"; import Seo from "../components/Seo"; import { GatsbyImage, getImage } from "gatsby-plugin-image"; import { useTranslation } from "gatsby-plugin-react-i18next"; const Tag = ({ data, location }) => { const tag = ; co...
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...
...en and x-default <link rel="alternate" hrefLang="ar" href={`${location?.pathname}`} /> the location?.pathname is adding ar/tag to slug which is fine for ar, but for en and x-default it should only have /tag with no ar import React from "react"; import { graphql } from "gatsby"; import Layout from "../components/Layout"; import { Helmet } from "react-helmet"; import PostLoop from "../components/PostLoop"; import Seo from "../components/Seo"; import { GatsbyImage, getImage } from "gatsby-plugin-image"; import { useTranslation } from "gatsby-plugin-react-i18next"; const Tag = ({ data, location }) => { const tag = ; co...
I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliable, acc...
I'm seeking a skilled researcher experienced in public records and FOIA requests. The project involves Researching to find info on the type of footage needed and requesting access to police departments to acquire police body camera footage for posting on YouTube * Ideal Skills and Experience: * Familiarity with public record acquisition, especially police bodycam footage * Experience working on journalistic projects This project requires someone who understands the nuances of public records Requesting and Journalistic Research
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...
I would like to develop an information website about a slimming product. - The website should include sections with product descriptions and benefits, testimonials and success stories, as well as health tips and weight loss guides. Each section must be clearly delineated, easy to navigate and reader-friendly. - The website also needs to have an order page where customers can buy the slimming product directly. - I already have part of a logo and colour scheme that we need to integrate into the website design. New suggestions are welcome. The ideal freelancer for this project (in German) can technically implement a website according to our supplied ideas with supplied texts, images and layout (for PC and mobile phone). We would like to be able to integrate the pages into our existing o...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the portal]". • Automate th...
For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...
I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an additional bonus.
I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Excel spreadsheets, making t...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.
I'm looking for an experienced developer who specializes in creating Google Spreadsheet plugins. The purpose is to export mixed data type including both text and numerical data. Key Objectives: Development of a Google Spreadsheet plugin. Integration for data from a web-based app. Build up functionality of data import/export. Ideal Skills: Experience in developing Google Spreadsheet plugins. Proficiency in handling both numerical and text data. Experience in integrating with web-based applications. The project involves developing a plugin for Google Spreadsheet that enables sharing specific spreadsheet data with our users, subject to their permissions. Upon sharing, users can view and potentially interact with the data. Additionally, the plugin should provide us...
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
As discussed I have completed the template for Home Team Workbook.
Do you use Glyphs app? Expert with RoboFont and FontForge? I require you to import a font (the bold instance of ) and decompose each letter into elemental parts. As an example, decomposition of upper case E would result in three horizontal elements, and two vertical elements. I'd be interested if you can also isolate serifs, but that's not really required here. For the successful bidder, I have a LOT of work (please don't overbid)! Don't bid unless you can demonstrate proficiency with Glyphs app, RoboFont, or FontForge. I am not seeking solutions in other applications.
I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...
...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and r...
...Flutter developer to create an Android and iOS mobile app for an event package. The developer should possess the skills necessary to create an interface that is intuitive, visually appealing, and seamlessly navigable for users. Prior experience in designing and implementing user friendly UI/UX elements is crucial. The app's core functionalities include providing event details, schedules, committee info, speaker profiles, multi participant registration, cost estimation, secured logins, profile, payments history. Please note that no payments will be processed through the app, and there is no requirement to integrate with any Payment Gateways. The app must seamlessly sync registration data with a MySQL backend. It should also fetch and display payment history and other releva...
We are looking for a skilled and experienced web developer to build a professional website using Webflow where users can share their Google Maps Saved Lists URLs and other users can search and filter these lists by city, country, categories, keywords, review rating, min. number of reviews and more. Users can sort by newest at the top, or by highest ratings, or by our algorithm. The website needs to be visually appealing, user-friendly, mobile-friendly and optimized for SEO. Currently I have a webflow, zapier, and airtable account, but happy to use other tools should the website developer prefer. Attention to detail, creativity, and the ability to meet deadlines are essential. Web developer's input into design and UX/UI are very much appreciated. If you have a portfol...
I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size...that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX";"...
We have our own ERP...in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you're confident in your ability to handle these tasks, I would ...
...functionality and leads import from various users to our website. The project involves integrating Facebook login into our React front-end and importing leads data from Facebook Pages and Ads from different users into our Laravel back-end. Responsibilities: Implement Facebook login functionality using the Facebook API and SDK. Develop a seamless user experience for Facebook login on our React front-end. Design and implement a secure and efficient data import process for leads from different users. Integrate the leads data into our Laravel back-end, ensuring proper validation and storage. Collaborate with the team to ensure smooth integration with existing systems and workflows. Troubleshoot and resolve any issues related to Facebook login and lead...
I need a system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by non-technical team members. - Working with...
