Vbscript update excel pivot table jobs
...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
I'm looking for an experienced web developer with strong WordPress and Elementor skills to update our corporate website. The main focus of this project is to add a blog/news section and a careers section to our site. In addition to these main tasks, there are various other content updates required. Key tasks involve: - Designing and customizing the blog/news section with a custom layout and related posts section. - Implementing a comprehensive careers section including job listings, an application submission form, and employee testimonials. - Updating text and images across the site and adding new pages as needed. Ideal candidates should have: - Proven experience with WordPress and Elementor. - A strong portfolio demonstrating success with similar projects. - A keen eye for ...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...
...and receipts for orders. 4. Shipping and Delivery Tracking - Record shipping details, including carrier, tracking number, and expected delivery date. - Update order status when shipped and delivered. 5. Reports and Analytics - Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Crea...
Seeking an experienced firmware engineer to create the firmware on an STM STA8089FG GNSS chip to customize the data sent out via its UART interfaces. The task: - Obtain firmware source code and SDK from ST - Modify firmware to allow custom UART data output: UART0 - GNSS, UART2 - debug strings - Provide source codes so we can update debug messages if needed
...consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous wo...
Hi I have a python matplotlib script that allows user to scroll through a 3D image, in nifti file format. It has a slider that allows you to scroll through the z axis of the image. I would like for the image to have a text box that updates chosen coordinates that are selected by clicking on the image at a given slice. I would like for the chosen coordinates to only update if the user clicks on the canvas where the image is. I would also like for the text box to be outside the canvas and slider. If you have previous experience with Matplotlib, this should be no problem. Thank you!
I need...to plug in that content. - Products Page: Not needed for now. - Services Page: This page should include detailed descriptions of the services we offer along with the respective pricing. - Contact Us Page: A standard contact page with a contact form, email address, phone number, and a location map. - Must be familiar with !! The site should be built using WordPress, allowing me to update content myself in the future. The design should be clean, professional, and aligned with the nature of a tile company. Ideal Skills: - Proficient in WordPress development. - Experience in creating clean and professional websites. - Understanding of basic SEO practices to optimize the site for search engines. - Familiarity with creating a contact form and integrating it into a website.
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
...expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's ...
I need some minor changes made to a HTML template. The email template needs to be optimized for various email clients, including Gmail, Outlook, and Apple Mail. I need the new layout to be inspired by specific designs I will provide.
...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...
...enhance topical authority for blog posts, ensuring content is displayed in a topical authority format on the blog page. • Monitor and analyze SEO performance metrics, making data-driven decisions to improve organic search rankings and traffic. 2. Plugin Management: • Audit existing plugins to identify redundant or outdated plugins that can be removed to streamline site performance and security. • Update and maintain necessary plugins, including 301 Redirect Pro and WP Rocket, to ensure compatibility and optimal functionality without conflicts. 3. Site Performance Optimization: • Implement caching, lazy loading, and other performance enhancements using WP Rocket to improve site speed and overall user experience. • Collaborate with the team to achieve speed...
I am in need of someone with expertise in updating tasks in a digital planner. I would need the freelancer to: - Automate the initial task in bucket 1 to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so o...to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so on. I specifically require these tasks to be automated using Power Automate. The ideal freelancer will have experience in digital task management, Power Automate and task automation. This should allow for a smooth update of tasks in my planner with...
Project Budget: $100 Project Deadline: 1-2 Days Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH ea...WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH each a day - Import post data and create all new posts as DRAFTS, to go live on the specified post schedule & keep a suitable log that can be checked - Insert the new POST IDs back into the original CSV file & automatically download the update CSV for a user 5* FEEDBACK WI...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge ...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enabl...quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock mana...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I'm seeking an experienced Android developer for a major interface update to my app. We need to facilitate a better user experience through user interface design enhancements and additional features. Key project aspects: 1. UI Design Updates: - Specifically, I want to improve the layout and navigation of my existing app. This process requires an innovative approach to enhance user experience and navigation flow. 2. Adding New Features: - Although I'm open to your expert suggestions for new features, the direction was not specified upfront. Potential freelancers must be proficient in Android development with a keen eye for intuitive, modern design. Working remotely, your ability to maintain clear communication for updates and changes on a shared session is cruci...
...customer service. - POS & Credit Management: An integrated point of sale system that also incorporates credit management functionalities. - Finance Management: A module dedicated to tracking financial transactions, generating reports, and managing financial records. Additionally, I'm interested in the following eCommerce functionalities: - Product Catalog Management: The ability to easily create, update, and manage product listings on my online store. - Shopping Cart: A user-friendly interface that allows customers to add items to their cart and proceed to checkout smoothly. - Payment Gateway Integration: Secure and reliable integration with popular payment gateways to facilitate seamless online transactions. Ideal Skills: - Proficiency in developing ERP systems with a...
I need a proficient Google Ads manager to handle my campaigns. I'm looking for someone who can update, create, and manage my Google Ads campaigns on a weekly basis. The main goal of these campaigns is to boost my product sales. You should be well-versed in the following types of Google Ads campaigns: - Search campaigns - Shopping campaigns I need someone with the following skills and experience: - Proven track record of managing successful Google Ads campaigns - Strong analytical and problem-solving skills - Excellent understanding of Google Ads and SEO - Ability to create compelling ad copies - Experience in boosting product sales through Google Ads is a plus. If you think you're the right person for this job, I'd love to hear from you.
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-friendly interfaces for Excel.
I'm looking for a PHP developer to assist in the web development of a web page for a customer I'm working with. The primary focus will be on implementing the ability to display customer raffle ticket numbers from the database to a WordPress page. Current page was rendered obsolete by a plugin update and needs to be rewritten. Ideal Skills and Experience: - Proficient in PHP, with a good understanding of its ecosystems - Experience in web development, particularly with WordPress - Knowledge of database management for websites - Ability to integrate and display data in a clear and user-friendly manner
I'm looking for a tech savvy freelancer to rectify a persistent issue I'm experiencing when trying to use my DualSense controller natively with the game, Brawlhalla. Despite having support for DualSense, Brawlhalla no longer responds appropriately to the controller. Notably, I've already made an attempt to update the DualSense controller firmware; unfortunately, the issue persists. Your objectives will be to: - Diagnose the problem's root cause - Develop and apply effective manuver to fix the issue - Test to ensure the problem is completely solved The right person for this job should possess the following qualifications: - Proven experience in troubleshooting and resolving tech-related issues on Steam and Windows. - Familiarity with DualSense controller and ...
I'm looking for a talented individual to build a data dashboard that will display our procurement spend data in a user-friendly and visually appealing way. Key Requirements: - Display Procurement Spend Data: The primary focus of this dashboard is to showcase our procurement spend data, broken down by different categories. - Manual Data Update: The dashboard should be updated by uploading files manually. Ideal Skills and Experience: - Prior Experience: I'm looking for someone who has previously built data dashboards, preferably ones that deal with procurement or financial data. - Data Visualization: Understanding of how to best present data in a simple, yet informative manner. - Tableau or Similar Tool Proficiency: Experience with tools such as Tableau that can integrat...
I'm in need of a de...Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The credentials will be provided to the selected freelancer. The table looks lik...
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...
I'm in need of an interior designer with experience in modern design aesthetics who can completely transform my living room and dining area. My preference is for a neutral color scheme with whites, grays and browns being the prominent tones. Key Elements include: - A medium sized and mpressive dining table, as I often entertain guests - A comfortable seating area that promotes relaxation, chats, and comfort. - Media Wall - Maximization of natural lighting - an aesthetic that capitalizes on light will be highly favored - Incorporation of features like a console, mirrors, wall art, center rugs, a media wall, and sofas with accent that combine style and utility. Special Attention should be paid to: - Nice, lush curtains that complement the modern aesthetic and enhance the spa...
When button clicked, the field of another table will changed to required. Only FTP no cpanel
More details: What type of integration are you looking for? Product inventory syncing How frequently should the product inventory update occur? Every few hours Are there specific product categories that need to be prioritized in the syncing process? Horse feed
I require a skilled contractor to integrate an existing API from an unspecified shipping carrier into my Prestashop store. This integration would enable automatic interaction between the carrier and my store. The key functionality sought is for the automatic posting of customer orders to the carrier's system and the subsequent status update in the Prestashop system whenever the carrier adjusts this status. What I expect from freelancers: - Past work details should be included in the application to demonstrate experience and expertise. Required API Functions: - Customer orders made in Prestashop should automatically post to the carrier system via their API. - Any changes of status made by the carrier should reflect in the Prestashop orders panel. Anticipated Status Changes: -...
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
I require an experienced photographer to help me update my business's headshots and capture some shots for our YouTube channel. The style of photography I'm seeking is artistic, with unique angles and lighting. It's crucial that the photos stand out and possess a creative touch. The photo shoot will be conducted indoors. It's important that the photographer has the knowledge and equipment to manage lighting and other indoor challenges to ensure top-quality shots. - Experienced with both headshot and YouTube photography - Possess an artistic and creative approach - Skilled in working with indoor lighting - Familiar with creating images for a business context Please provide a portfolio of your previous work that demonstrates your ability in these specific area...
Design and implement one page website. The website shall have a design similar to...libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that h...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
LOGO: - Update/Rebranding current logo in 3 variants. - Creating color variations of the logo selected by the client. - Other additional drafting and preparation - Logo to be the same font as the recommended for to use in post social media and site LOGO PACK (PNG/AI/SGV/PDF/Pozitive/Negative). PATTERN: - Creation of 3-4 brand patterns. - Preparation of files in variants (PDF and PNG). SOURCE: - Identification of new fonts for social media and site. - Preparing the font package and delivering them.
...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...
As an organization using Exchange 2019, we've recently applied a Cumulative Update. However, post-update, we're encountering issues with both OWA ECP and Exchange PowerShell. The specific problems we're experiencing include: - OWA ECP failing to load properly - Exchange PowerShell unable to connect We are seeking a skilled professional who can assist in rectifying these issues. The ideal candidate should have: - Extensive experience with Exchange Server (preferably 2019) - Proficient in handling issues post Cumulative Updates - Adept at troubleshooting OWA ECP and Exchange PowerShell problems The goal is to have our OWA ECP and Exchange PowerShell fully operational again, following the CU installation. If you're confident in your ability to diagnose an...
...up and redesign my website. This project will involve four main areas of focus: Design Layout, Content Organization, and Speed. Design Layout: - Change color scheme: I need a fresh color palette that is visually appealing and cohesive. It should include a black and white core like my logo with red/blue accents. The images should be updated with the same colors using photoshop recoloring. - Update fonts and typography: I am looking for a modern, readable and consistent font that matches my logo. - Optimize for mobile devices: The website should be responsive and provide a great user experience on all devices. It is already setup like this, but may need some fine tuning. Content Organization: - Rearrange pages and sections: I want to organize my website in a way that is intu...
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.
...examples is provided in the json format. We plan to have 1000 entries in this json at least. The database includes: Photo (each person will have at least one phone), name, birthday, occupation, transaction table, ... (please see the json file). Animations: when a user scrolls down new information block appears. Layout: The page should start with a photo of the person and a name on the left. See the attached file. In the middle of the page should be a table with trasactions, use a component from react here (or other possible framework): DData for the table comes from the json file. Please add in the bottom after all information from a user sign: Need more info come to us. Please add 2024 to the end of the page. The website should be mobile and
As the developer for a flutter application, you would resolve an issue with the calendar not displaying correctly. Despite not using any third-party libraries, our calendar is not updating with new data. As an ideal candidate, you should: - Have proven experience in Flutter app development - Identify and resolve bugs efficiently - Know how to handle data update issues - Prior experience in calendar functionalities is a bonus
...Appstore and Google store, seamlessly interacting with both Apple and Samsung devices. The key features should include: - Task/Event Management: The app should provide an avenue for the creation and assignment of tasks or events. It will be fundamentally used for administrative organization and must hence accommodate this featured component efficiently. - Notification System: Having a reminder and update system is crucial for the app’s functionality. Timely notifications about upcoming tasks or events should lead to seamless organization. - RSVP Functionality: Incorporate a system that allows users to RSVP or sign up for tasks or events, thus ensuring a steadfast and dependable participation record. The ideal professional for this project will have excellent skills in IOS...
I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
