Vba refresh excel web query jobs

I'm looking for a freelancer who can help me parse the entire database from the website. The data needed includes: ...who can help me parse the entire database from the website. The data needed includes: - Name of the institution - Founder’s name - Email - Authorized capital - Taxpayer Identification Number (TIN) - Address - Phone number The parsed data needs to be delivered in an Excel format, as I plan to use it for marketing purposes. This is a one-time task, so I do not need the parsing to be done periodically. Ideal skills for this project include: data parsing, data entry, and Excel proficiency. Experience with web scraping and handling large datasets is a plus. Please ensure that your bid reflects your ability to deliver this data accurately and...

I'm looking for a skilled professional to help me compress some company data into an Excel file. The data primarily stems from our sales, specifically customer information. The current format of this data is a database export. Your main task will be to efficiently manage and compress our sales data for easy access and analysis. Ideal Skills and Experience: - Proficiency in Excel - Experience with data compression - Familiarity with handling database exports - Understanding of sales data, particularly customer information

...that need to be exported to Excel. The contacts are listed in a consistent, tabular format, making them amenable to Optical Character Recognition (OCR) software. Specific Requirements: - Extract contact details: First Name, Last Name, Company. - Enrich each contact in Excel with their LinkedIn Profile URL, LinkedIn Job Title, and LinkedIn Company. - Example: For the contact Johan Abel from Port of Antwerp-Bruges, the final output should be: Johan Abel, Port of Antwerp-Bruges, , Business Development Advisor Connectivity, Port of Antwerp-Bruges. Ideal Skills and Experience: - Proficient in using OCR software for data extraction. - Familiarity with LinkedIn for profile searching and data enrichment. - Advanced Excel skills for data organization

I need a Tableau dashboard that connects to my Excel files and MySQL database. Ideal Skills: - Proficient in Tableau - Experienced in data visualization - Knowledgeable in MySQL and excel data integration - Able to create user-friendly, insightful dashboards. Please provide samples of similar projects you have completed. Dear Participants, "Today many big organizations are sitting on large chunks of data, not knowing what to do with it. They invite consultants & business analysts to have a look at data and come up with insights that could help the organization run their business better. There is no clear set of instructions in such open-ended problems and it is expected of the consultant to do a lot of exploration first and formulate the problems themselves. Thi...

I have a project involving the conversion of approximately 800 pages of mixed text and tables from PDF to Excel. The data is fairly simple and I expect a high level of accuracy (99%+). Key Requirements: - Converting mixed text and tables from PDF to Excel. - Following standard Excel formatting for the converted data. - Ensuring high accuracy with minimal errors. Need very limited details in excel 3-4 types of details like Company name Contact number Email Id/s Ideal Skills: - Proficiency in data entry and Excel. - Attention to detail. - Experience with PDF to Excel conversion. Please note, there are no special characters or non-English text in the data, so a focus on accuracy and standard formatting is paramount. Need work to be done 27th Ja...

...Responsibilities Calendar management and scheduling Travel arrangements and logistics coordination Basic budgeting and accounting support Document preparation and management Email and communication management Administrative workflow optimization Required Qualifications Native English speaker with excellent written and verbal communication Advanced proficiency in: Microsoft Office (Word, PowerPoint, Excel) Google Workspace (G Suite) Microsoft 365 environment Strong organizational and time management skills Detail-oriented with ability to handle confidential information Self-motivated with excellent problem-solving abilities Preferred Skills Experience with automation tools (Zapier, ) Previous virtual assistant experience Background in technology industry Technical Requireme...

We are looking for a python developer to create a scheduled program that uses an Excel sheet template with placeholders and data from a Mysql database to create paginated reports and saves the reports as pdf. Be aware that the Excel sheet will contain content like imported images, a page header, etc., which has to be considered during the pagination process. Program needs to run on Ubuntu, not Windows

...selection, and service booking. Future iterations (up to MVP 7) will expand upon this foundation to include additional features and enhancements. Key Features and Requirements: 1. Authentication: Sign In Screen: Fields: Email/Username Password Submit Button: Calls an API for authentication (API is pre-developed). Stores the returned access token and refresh token in the app's key vault. Access tokens are used for backend API calls; refresh tokens (valid for 3 months) are used to generate new access tokens. Language Selection(Small): Dropdown list with default language as English. App content dynamically updates based on selected language. Sign Up Screen: Separate options for "User" and "Professional" registration. Mandatory fields (6 fields,...

...unique user ID assigned to each customer during account creation. The operators can then print the QR code and provide it to their customers. Customers will use their respective QR codes to make monthly payments conveniently. Customer Management Panel with QR Code Generation, Payment Gateway Integration, and Telegram Notifications ________________________________________ Project Overview I need a web-based platform with a secure login system for managing customers, generating unique QR codes linked to their accounts, and integrating a payment gateway (PhonePe) to track payments. The platform should also include a dashboard for tracking customers and payments, exporting data in various formats, and generating reports. Additionally, the system should have the ability to scale with ...

...need a skilled developer to create a custom website for me. The key features of this project include: - Social Media Login : The site should have Facebook login functionality. - Chat Feature : The site will have a chat feature that allows users to communicate. The chat functionality should include: - Private Messaging - Group Chats - Media Sharing - ChatGPT Integration : Users should be able to query ChatGPT directly from the chat feature. - Blogging: The site should have a blogging feature. - API Calls: The site will need to make API calls to external websites. I have a preference for the development to be done in JavaScript. The ideal candidate would have experience in: - Front-end development with JavaScript - Social Media API Integration - Chat feature integration and cus...

I need an Excel spreadsheet that lists all Liquor Stax stores and their addresses across Australia. Please note: - Only store name and addresses (number, street, suburb, postcode and state) are required, I do not need contact information or specifics about the stores. - The final deliverable should be an Excel (.xlsx) file. Ideal candidates for this project would have experience with data gathering and Excel, and preferably familiarity with retail store research. Attention to detail is crucial to ensure all information is accurately compiled.

Hey i have reviewed your profile and would like to offer you my project

I'm looking for a skilled professional to add a custom tab in MS Word for me. This tab should replace words as I type from my organization's customised abbreviation dictionary. Key Requirements: - The abbreviation dictionary primarily ...looking for a skilled professional to add a custom tab in MS Word for me. This tab should replace words as I type from my organization's customised abbreviation dictionary. Key Requirements: - The abbreviation dictionary primarily contains general terms. - I would like to access the abbreviation dictionary from a local file, specifically an Excel file. Ideal Skills: - Proficiency in MS Word and familiar with custom tab creation - Ability to work with Excel and integrate it with MS Word - Understanding of general terminology ...

I'm looking to enhance my website's functionality and features, while also giving its design elements a much-needed refresh. Key areas of improvement: - **Functionality & Features**: The website is functional but not fully functional. I want to add interactive forms and widgets to boost user engagement. A Blog/Articles section is also needed for regular updates and a Testimonials section (possibly in a carousel) to build trust with our visitors. Design Elements: - **Color Scheme & Branding**: I want to align the website's color scheme with our brand identity. - **Typography & Readability**: Enhancing the typography and readability is crucial to making the site more user-friendly. - **Images & Visuals**: I'm looking to improve the overall visual...

...MESSAGES OR ANYONE ASKING QUESTIONS I HAVE THE ANSWERS FOR BELOW. I'm looking for a professional to assist in updating my Shopify store every 3-6 months. This includes: - Updating prices - Adjusting stock levels - Modifying product descriptions - Adding new listings - Removing discontinued listings my website my suppliers website I have an excel spreadsheet with parts, prices, quantities and dimensions, that I need to be matched up to what is currently listed on my website. I need all this information uploaded correctly under the relevant categories and sub categories. I can also provide you with my suppliers website so you can use as reference. This must be done correctly, so attention to detail is a MUST. I also will need the dimensions

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is cr...

Hi, I’m Nirajan Neupane, a skilled professional specializing in cybersecurity and computer-related technologies. With a strong foundation in IT and a passion for problem-solving, I also excel in freelance writing, delivering high-quality, well-researched, and engaging content on technical and non-technical topics. Skills and Expertise Cybersecurity and system protection. Writing and content creation for technical topics. IT-related problem-solving and consultation. Research and documentation on advanced computer technologies. Why Work With Me? I bring a blend of technical expertise and creative writing skills to every project. I ensure clear communication, timely delivery, and meticulous attention to detail. My goal is to help clients achieve success with insightful,...

I'm looking to give my logo a contemporary refresh. The primary goal is to modernize the logo to keep up with design trends and to enhance its visual appeal. Key Aspects: - Typography: The updated typography should embody an 'elegant and sophisticated' style. - Icon/Design Elements: A revamp of these components is also necessary to align with the overall modernization goal. Ideal Skills: - Proficiency in typography and design - Experience with rebranding and logo design - Understanding of contemporary design trends Please provide samples of your relevant work. I also would like to revamp my email signature as well to fit in with the new logo The logo will need to be on my socials - facebook, linked in etc and my website I have added the current logos I have

I'm looking for an expert in Microsoft Excel to help me create a visually appealing and functional spreadsheet for tracking PM maintenance checks and notes. The ideal candidate should have a strong background in: - Advanced Excel features: You will need to use conditional formatting and create drop-down menus. - Visual design: The spreadsheet should be easy to read and visually engaging. - Understanding of maintenance schedules: The spreadsheet will be organized by maintenance type, so an understanding of this field would be beneficial. Please, include in your proposal examples of similar projects you've done in the past.

I need to connect my website ( ) buttons and data capture to a MySQL database on Hostinger. I'm hoping to integrate 1 to 2 of my websites into this system. The key data points to c...database on Hostinger. I'm hoping to integrate 1 to 2 of my websites into this system. The key data points to capture include: - User contact details - Paypal Donations - Other Forms of Donation - Petitions Additionally, I need a simple way to export this data. Primarily, I would need to send it off as an Excel file. Ideal Skills for this Job: - Proficiency in MySQL - Experience with Hostinger - Web development skills - Ability to set up data capture from website interactions - Excel data manipulation skills Please provide examples of similar projects you've work...

I need an Excel expert to analyze my sales data and generate visualizations. The ideal candidate should be proficient in Excel, with a strong understanding of data analysis and visualization techniques. Key Requirements: - Analyze sales data to determine profits - Create a variety of visualizations including bar charts, pie charts, and line graphs Experience in data analysis and Excel is necessary for this project. I hope to gain a clear understanding of my profits and any related patterns through this analysis.

I'm in need of a highly skilled Excel professional to create a customized spreadsheet for managing our stainless steel kitchen items. This spreadsheet should not only track our inventory, but also automatically calculate prices based on various factors. Key Features: - Automatic pricing calculations per meter for each item, as well as for single items. - An easy-to-use inventory tracking system. - A system for manual data input as our inventory grows. - Accommodation for fixed amount price adjustments reflecting market fluctuations. - Versatility to handle different pricing for different units of measurement, specifically meters. Ideal Skills and Experience: - Proven expertise in creating intricate, user-friendly Excel spreadsheets. - Comprehensive understanding of inv...

I'm looking for a skilled Excel expert to create a bespoke spreadsheet for our stainless steel custom kitchen items. Key Requirements: - The spreadsheet should automatically calculate prices per meter per item as well as for single items. - It should have an inventory management system. - There should be capabilities for price adjustments reflecting market fluctuations. - I need to manually input the data for each item over time. - The spreadsheet should accommodate different pricing for different units of measurement. Ideal Skills and Experience: - Extensive experience with creating complex Excel spreadsheets. - Strong understanding of inventory management systems. - Previous work with pricing calculations based on varying units of measurement. - Ability to create u...

I need a professional who can convert my scanned PDF bank statement into an Excel. I have been trying to do it via a python script and while I can extract the text the data is not being pasted into the correct columns. My script is not accounting for the fact not all columns are populated. The primary purpose for this conversion is data extraction for analysis. The data should be organized in the Excel file by column from the statement. Specifically, I need the following columns from the bank statement to be included: Date, details, Debit €, Credit €, Balance €. Ideal Skills: - Proficient in data extraction and analysis - Experienced in Excel script creation - Detail-oriented to ensure accurate data conversion

I need a freelancer to enhance my spreadsheet by adding two new text columns, C and D. Using the first tab, PLCMON, as a template, these columns should be labeled 'Pass/Fail' and 'Comment' respectively. Key Requirements: - Insert the new c...new text columns, C and D. Using the first tab, PLCMON, as a template, these columns should be labeled 'Pass/Fail' and 'Comment' respectively. Key Requirements: - Insert the new columns into the spreadsheet - Populate column C with 'Pass' or 'Fail' - Place the text 'Comment' at the top of column D - Utilize the first tab, PLCMON, as a reference for data placement Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong attention to detail - Ability to...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project.

I'm looking for an Excel expert who can create a pivot table for me. The main purpose is reporting on customer data. Specifically, I want to gain insights into expenses per category. Ideal Skills: - Proficient in Excel, particularly in using Pivot Tables - Experience in data analysis and reporting - Ability to interpret and present data in a clear and concise manner Please bid if you can assist with this task.

I am looking to have a excel spread sheet created for my small buisness, I already have my branded business logo so I would also like that to be featured on the spreadsheet, I am looking for a basic 1)Profit & loss spreadsheet 2) General Ledger Spreadsheet 3) Balance sheet. I have P&L Templet along with a General Ledger Templet I can provide for reference if needed. the spreadsheets I have will need a few adjustments but are pretty basic. I am also open to some templates you provided for reference if you have any Thank You

I am looking to update my CRM database with a couple simple excel tasks in a macro. See tabs in excel sheet as I download these when needed, and upload the new DataBase values when needed. • Household Id is unique to a household • Id is unique to a person. • You can have many people in a household 1st Task: I would like to update “Manual Household Last Note” in the Last Note Report Excel Tab to the most recent date from any of the people inside a household associated with their Household Id. Place in same date format. – Purpose: this will show me recent activity of anyone in the house when I run my report from my CRM. I would like to make this in an excel macro that I can use again in a few months. Report which ones were ch...

I need someone to create printable labels from an excel sheet. The labels will be used for products and should include the following details: - Product details - Expiration date - Ingredients list - Price - Others These labels need to be designed to fit on letter size (8.5 x 11 inches) sheets. Ideal skills for this project include proficiency in Excel and label design software, attention to detail, and experience with product label design.

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I...

Basically I have this single 1 .doc File. In this file, there are 2 "words/sentences" that need to be changed. They appear in the document maybe just 3-4 times.... 1. - one is a code for a product, like ABC1234 2. - one is the description of this products like "Cat Epithelium" ... I already have an Excel file with all the 750 different variants... Can somebody help me out here? THanks

The objective ...(including any environment setup needs) • a database design document including ER diagrams and database schemas • A data dictionary • All design documents • evidence that the tables are appropriately normalised, indicating in each case which normal form was chosen and why. • Screen traces that show the creation of all database objects – including populating the tables • screen dumps of all table and query structures • printouts of test runs showing that each of the functional requirements (forms and reports) has been met. Notes: 1. The solution should be in a form that the instructor can download and execute 2. Present the material in a logical manner for the reader 3. The user manual must contain specific system information ...

...Impactful Work: Your efforts will directly contribute to the success of food entrepreneurs. Open to New Ideas: Be part of a team that is always ready to try out new concepts and ideas to push the business forward. Supportive Team: This is a great team with a lot of opportunities to grow and challenge the status quo. We encourage you to think outside the box and provide the platform and support to excel, fail, and try different things. Explore us—you won't regret it! Interested? For more information about our work, please visit our website at Dishefs.com. You can also connect with us and follow us on social media: We look forward to having you on our team!...

...experienced PowerApps developer to create a PowerApp that mirrors my Excel Online spreadsheet. This project involves: - Replicating the first three tabs of the spreadsheet (SLS Input, jSKU input, PB input) within the PowerApp. - Ensuring all functionalities of the embedded macros in the Excel are integrated into the PowerApp. - Implementing the ability to add/edit rows in separate SharePoint Lists. This project is the first phase of a larger initiative. If the initial project is successful, there will be further opportunities for development into dashboards and automation using PowerBI and Power Automate. Ideal skills for this project include: - Extensive experience with PowerApps and SharePoint. - Proficient understanding of Excel Online and its embedded macros...

I'm looking for a professional with extensive experience in Apache Calcite to help me to set Apache Calcite to optimize Snowflake queries and give me a crash course on Calcite. Key Requirements: - Expertise in Apache Calcite, specifically in query optimization - Proficient with Snowflake - Ability to optimize simple, complex join, and analytical queries - Strong understanding of SQL parsing and execution - Experience with custom data source integration

I'm seeking a data analyst with a strong background in operational metrics and excel spreadsheets. The primary goal of this project is to analyze our operational data with the intent of improving our presentations. Key Areas of Focus: - Data analysis: You will be tasked with scrutinizing our operational metrics to identify potential areas for enhancement. - Performance improvement: The aim is not just to collect data, but to derive actionable insights that can lead to tangible improvements in our production process.

**Please post your correct bid account. We are seeking a highly motivated and creative Virtual Assistant to join our team. The ideal candidate will excel in managing social media content, creating engaging campaigns, and overseeing ad accounts with a special focus on the supplement industry. If you have experience in driving results for supplement stores or related niches, we want to hear from you! Responsibilities:Plan, create, and manage engaging content across multiple social media platforms (Instagram, Facebook, TikTok, etc.).Develop creative strategies to boost engagement, reach, and brand and optimize ad accounts (Google Ads, Facebook Ads, etc.) to maximize trends in social media and apply them to create innovative , analyze, and report on

I need someone to organize my tax receipts into an Excel sheet. Group them by month Jan 2024, Feb 2024, etc....into food, gas, etc. So each month Ill know what i spent total on gas, food, vehicle repairs, office supplies etc in that month. If there is something you dont know then put it in a mics section for that month. Should take less than 2 hours easily.

I require an Excel-based scorecard for my small team. This scorecard should track both year-to-date and monthly performance, with priority weights differing for each team member. - Team Size: There are only 4 members in the team. - Priorities: There are 5 priorities, with the weight for each specified in Tab 3. - Visualization: All data should be presented in a table layout. The scorecard should specifically include metrics on productivity. As such, an ideal candidate for this project would be someone with robust experience in Excel, data visualization and performance tracking. Thank you for your assistance.

...extract and organize product data, including: Part Numbers Manufacturer Information Pricing (New, Used, and Repair Service options) Project Scope: Extract product details from provided sources (websites, PDFs, or spreadsheets). Organize data into a structured format for easy import into our database (e.g., Excel or CSV). Ensure accuracy and completeness of all extracted information. Requirements: Proven experience in data extraction and handling. Proficiency in tools like Python, Excel, or other scraping software. Attention to detail to ensure error-free data entry. Ability to manage large datasets efficiently. Deliverables: Completed dataset with part numbers, manufacturer names, and pricing details for all conditions (new, used, and repair). Documentation of the e...

I'm looking for a Windows-based standalone PHP web app that scans QR codes and compares them with an Excel file containing employee attendance data. The app should visually indicate whether an employee is scheduled to work with a popup alert. Key Requirements: - Well-documented source code The app should display a popup alert for each matching entry. - For non-matching entries, it should display an error message. Ideal skills and experience: - Proficiency in web app development, particularly for Windows. - Experience with QR code scanning integration. - Ability to work with Excel file data. - Skills in creating user-friendly interfaces with visual alerts.

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

Everything that was discussed will be carried out based on the documents sent.

...successful sales, and customer ratings for ease of using app and willingness to refer app to others. - Strict adherence to KYC and AML guidelines with a focus on customer data safety. - A secure login system based on PAN/GST Number and Aadhaar OTP verification. - Simple interface for adding, modifying, and removing referral links. - An admin dashboard for managing the app. - Ad integration. - Daily Excel and PDF reports for leads generated. Ideal Skills and Experience: - Proven experience in Android app development. - Strong understanding of KYC and AML guidelines. - Experience with secure login systems. - Ability to create user-friendly interfaces. - Experience with ad integration and generating reports. I am looking for a developer who can create a secure, efficient, and use...

I have a set of flowcharts and process diagrams in Excel that I need converted into Visio. The complexity of these charts is moderate, with multiple steps and branches. Key Requirements: - Proficient in Microsoft Excel and Visio - Experience with converting flowcharts and process diagrams - Familiarity with standard Visio templates - Able to accurately represent moderate complexity flowcharts Please ensure that the flowcharts are converted using a standard Visio template. I can provide this template if needed. The ideal freelancer for this project will have a keen eye for detail and a strong understanding of flowchart and process diagram conventions.

I'm looking for an expert in Excel to assist me with creating Excel-based solutions.

I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.

...they are aligned with quality standards (the order is in the right subfolder, requirements, technical documentation) - update this list of routine and on-demand routine Support for HR is required - Recruiting on online platforms - Opening jobs, - making interview and tests ( We will share a technical test to be done), - first selection - Payments and follow up document template creation (Word, Excel), Marketing material, like power point presentation, brochures, business proposal lead verification and generation from Linkedin, mail and follow feedbacks Required skills - SELF SUFFICIENCY in completing required technical tasks. - Confidentiality: you will work in close contact with CEO, this means you will have access to private and sometimes confidential information, both person...

I need assistance in renaming a set of JPG image files based on an Excel spreadsheet. Key Details: - The current naming of the image files is arbitrary, with names consisting of random numbers and letters. - I have a specific Excel spreadsheet that outlines the desired new names for these files. The ideal freelancer for this project should have: - Experience in file management and renaming tasks - Proficiency in using Excel - Attention to detail to ensure every file is renamed accurately.