Excel vba refresh web query copy datapráce

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've wor...

I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...

I am looking for professional css, html, and js developer who is familiar with django. Mostly interested in CSS. Knowlaage of SEO is required. I need to make my website look professional and add a few things to it such as map and others...look professional and add a few things to it such as map and others. I will give you my intial design and you need to work on it on your own. Intial design means htmls, css only but I will not provide any backend code. After you get done with the design you will remote into my machine and plug everything in so I can test it. Important: My remote computer is monitored from the server, any try to copy any code will be immediately blocked. Sorry I am trying to protect my work. If you have the skills and willing to work with me please submit a f...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized d...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and ...

...central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and familiar with Filezilla - Experience with network security and data ...

...Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has t...

I am looking for an experienced content writer to craft a company profile that promotes my company's products/services. This profile should have a professional tone, and it needs to capture the essence of our brand. Key information should be compellingly delivered to engage potenti...of the company: Impart a reliable and customer-focused company image, detailing our journey, mission, visions, and values. - Detailed product/service information: Provide comprehensive and persuasive information about our products/services. -Inclusion of past work deck Ideal candidates will have previous experience writing professional company profiles and a knack for marketing and advertising copy. A strong understanding of brand development is also appreciated alongside excellent written commun...

...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistic...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.

I'm looking for a website designer who can Design our website to be more attractive and user-friendly. Our primary goal is to create an engaging platform that effectively delivers information to our audience of business professionals. Key requirements include: - **Design Refresh:** The website needs to be visually appealing and professional to cater to our target audience. - **User-Friendly Navigation:** The design should be intuitive, making it easy for visitors to find and access the information they seek on any device, Desktop, Mobile Phone, or Tablet. - **Contact Form Integration:** We'd like to incorporate a contact form that allows our visitors to easily reach out to us. Ideal candidates for this project should have: - A strong portfolio demonstrating their experie...

I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom and w...

I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.

...the task of building a web application where users can input company names, and any publicly available information (uploaded on MCA portal by registered companies ) about those companies will be retrieved. There are already existing web apps that do this, for example [India fillings search]() [quick company company search]() [MCA portal]() However, these don't allow bulk input. I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties

...the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. Translate it into the appropriate language for the country you will be speaking with) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Norway. Some of the records include

I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.

...multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process...

I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation...

Only two site links need to be implemented identically: = One-time check of Naver Place ranking = Daily check of Naver Place ranking for keywords and registered businesses Use the following credentials for testing: ID: qmfh123 PW: qmfh123! You'll understand better by trying it yourself. After implementing the two links above identically, additional features should be added: When registering for Naver Place ranking check, users can register up to three keywords: For example: "강남맛집, 압구정맛집, 서울맛집" (Keywords) - "강남로코컴플렉스" (Business name) For example: "강남맛집(강남로코컴플렉스) 11위, 압구정맛집(강남로코컴플렉스) 6위, 서울맛집(강남로코컴플렉스) 30위" Member functions - Permission separation into Master, Manager, and Team Leader: Master

...project include: - Crafting engaging and informative website content: The copywriter should be able to create web content that not only informs potential customers about the product features, but also engages them and encourages them to explore further. - Writing a compelling press release: A press release needs to be concise, engaging and informative. The copywriter will be expected to create a document that piques the interest of journalists and potential customers. - Understanding of the target audience: The ideal candidate should have an understanding of the automotive industry, including car enthusiasts, automotive mechanics, and vehicle owners, and be able to tailor the copy to these audiences. Ideal skills and experience for this job include: - Prior experience wri...

Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...

Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

Bought together modification of wordpress sales page, At present, it is a function of wpc bought together, and pop-up windows have also been developed. You need to refer to the functions of the two websites "" and "", and the amount is $150. Working hours are 7 days. ★ Copy the functions and appearance of ""： 1: Title: It is limited to only 2 lines of text, followed by「 ... 」to display, the same as the current title 2: Hover picture or title: display all title names 「Refer to the home page picture,v 3: Only display "selling price" 4: Move the tick in the upper left corner to the lower right corner 5: For mobile phones or sliders that reduce the screen, , 「4/1」of the product image will be left on the far

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues...

I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of you...

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

I am looking for a skilled developer to port an existing monitoring program from Windows XP, written in C#, to a modern Windows version or to Linux. The program is currently written in C# Key Features: - Real-time monitoring: The program should be able to continuously monitor and display real-time data. - Data visualization: It should have the capability to present the monitored data in a graphical format. - Data logging: Record selected inputs/outputs at predetermine interval - Error logging: The program should be able to log any errors or issues that occur during monitoring. - Control: The ported program should support control features like: - Adjustment of monitoring settings: The user should be able to modify the monitoring parameters. - Remote control...

I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're t...

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases sh...databases should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medi...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.

I need a skilled copywriter to create sales copy for B2B email marketing campaigns. The ideal freelancer will read through the attachment in this post and follow what is provided. - Write engaging, friendly emails that resonate with our audience - Utilize their expertise in lead generation to achieve our campaign goals - Have experience in B2B sales, specifically in the accounting industry The main objective of this project is to increase our lead generation, so if you have proven strategies to achieve this, we would love to have you on our team.

Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento

O trabalho consiste em digitar 140 páginas de extratos que estão em PDF para uma planilha do Excel, conforme modelo (os extratos a serem digitados e o modelo de planilha estão nos anexos deste projeto)

I am seeking a bilingual Sales Specialist with a mid-level experience in enhancing our Service Sales. (5 Sales Specialist needed). Key Requirements: - Fluency in English and Spanish - Mid-level experience in sales. Ideal Skills and Experience: - Proven track record in service sales - Strong communication and negotiation skills - Bilingual proficiency in English and Spanish - Ability to excel in a fast-paced environment. The Sales Specialist will focus on sales effectiveness through phone calls. The primary target market is the Telecom/Home service. The ideal candidate should have a solid understanding of this market and be able to communicate effectively in both English and Spanish. Training on our Services and related will be given. We offer excellent Commissions. Join our tea...

I need assistance in copying product data from the manufacturer's site to ours. This is only for approximately 20-25 products. Key responsibilities include: - Transferring product descriptions - Moving over technical specifications The ideal candidate will have: - Proficiency in data entry - Understanding of eCommerce platforms, so that the formatting is correct on our site. Here is an example product: The description should be placed in our description tab. The other info, from Connections to Warranty should be entered in our Tech Specs tab, while retaining the formatting, including symbols. I will provide full URLs to each of the images in the tech specs. I do not want to link to their images. You will not need

I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a ...

I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering ...

I'm seeking a graphic designer to refresh one basic image I drew on Powerpoint. My website is focused on Bitcoin and I need the images for a blog post I intend to post. Therefore the images must match the style of the website I want the images to look professional, with bright colours and increased contrast. This project would benefit from someone who can also effectively incorporate text into the design. Your expertise in modern design techniques will play a vital role in successfully achieving these improvements.