Retrieve data database excel vba jobs

...beginner in MATLAB and Excel, I'm currently seeking an experienced programmer to guide me through the process of calculating RPM. The core objectives of this project are: -to clearly presented on the g-forces the riders will be exposed to for each of the 3 speeds, whether the forces are enough to pin the riders to the walls, and the rpm of the most suitable ride speed For me, I am aiming - To understand the fundamental techniques of handling three sets of data through Excel. - To learn how to effectively import this data to MATLAB. - Finally, to produce a scatter plot representation of the imported data in MATLAB. This project primarily involves data from an experiment, so I'm aiming at gaining knowledge of not just importing ...

I require a freelancer to assist with the addition of images, links, and information in my database, hosted on Wix.com. Your task involves: - Taking screenshots of images in provided links - Uploading these images, information and links provided in a prescribed format. Ideal freelancer will have: - Familiarity with - Data entry experience - Experience in image handling - Keen attention to detail for successfully linking to correct destinations.

...expert in Power BI to convert raw financial data from Excel into insightful reports. - **Data Inclusion:** - The project involves translating Excel data related to revenue, expenses, and profit into Power BI reports. - **Data Update Frequency:** - The frequency of the data update can be discussed during the project initiation phase. - **Visualization Request:** - The desired output should be a series of simple financial reports, in table form. I'm looking for someone with a strong background in financial data analysis and Power BI. The ideal candidate would have experience in building informative reports, and the ability to transform complex financial data into clear and concise visualizations. - **Data...

I am nearing the completion of my mobile student-teacher interaction doubt app develo...camera part .Just a few hours of coding is left and I need online assistance with that. I need to submit my project on 15/04/24.I need assistance anytime before that. Key tasks include: - Assisting me to effectively integrate Firestore Firebase. - Explaining and demonstrating ways to perform CRUD operations. - Highlighting how to securely store and retrieve data. Freelancers with the following skills are preferred: - Proven experience in database integration with Flutter Apps. - A rich depth of knowledge in Firestore Firebase. - Tremendous problem-solving skills. - Good communication and teaching ability. Interesting candidates should note that no API integration tasks are re...

I'm on a quest for a comprehensive European mailing list, inclusive of Interior Designers and Architects, for networking purposes. This list should cover all regions: Western, Eastern, and Southern Europe. Notably, I'm keen to connect with industry veterans — the list should primarily feature individuals ...mailing list, inclusive of Interior Designers and Architects, for networking purposes. This list should cover all regions: Western, Eastern, and Southern Europe. Notably, I'm keen to connect with industry veterans — the list should primarily feature individuals at a senior-level experience. Ideal skills include: - Research & data collection - Knowledge of the interior design and architecture communities in Europe - Great attention to detail to ens...

...dedicated professional who can skillfully extract data from a targeted website, The project involves listing and comprehensive data extraction including: - Contact information - Company name - License type - Email - Full name - Mobile An efficient process of transferring this information into an Excel spreadsheet is required. Attention to detail is a must to avoid errors. No additional services like data cleaning or analysis are needed; the project is solely for data extraction into a spreadsheet. Ideal skills would include proficiency in data entry, web scraping, and Excel. Previous experience in data extraction would be highly beneficial. I'm seeking a freelancer who can work quickly without sacrificing data valid...

I am looking for a skilled developer that can create a pay-per-post premium locking content system...Proficiency in coding and tech platform adaptability, to cater for the initially unspecified platform or website. Your responsibility in this job will be to develop a seamless integration of the pay-per-post feature that provides a smooth user experience. This wouldn't just be about locking content behind a paywall, but also making sure the implementation doesn't disrupt the overall site experience. To excel in this project, your creative problem-solving abilities and passion for innovation will be key. Impress me with your detailed approach, plan, and initial ideas about this project as you showcase your portfolio. Bear in mind, your past accomplishments will be a deter...

I'm in need of a dedicated freelancer to assist me with some simple data entry tasks. The data involved will mainly comprise of basic information such as names and emails which will be provided in a digital format, mostly in PDF or Word documents. Requirements: - Proficiency in Excel for data entry - Attention to detail - Ability to meet deadlines This job would suit someone who is meticulous and enjoys structured work. Experience with data entry and Excel would be a big plus.

The work is fairly straightforward: * Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - every 12 hours (10AM & 10PM)

* Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - every 12 hours in a day (10AM & 10PM) *USD 15 per month.

I'm looking to translate an excel spreadsheet to an easy-to-use Google Sheet. - Conversion: Translate the full content of the Excel spreadsheet to Google Sheet without compromising the quality or missing any data points. - Functionalities: Ensure all formulas used in the current Excel sheet work perfectly on the Google Sheet. - Logo Placement: Importantly, I want my logo positioned in the top-left corner of the Google Sheet's header, maintaining its clarity and visual dominance in the design. The ideal freelancer for this task would be someone with extensive experience in Excel, Google Sheets, and graphic placement. Practical knowledge of maintaining spreadsheet functionalities during a transition is critically essential.

I require an experienced data entry freelancer with a strong proficiency in Excel and Word. The project entails translating text data from Word documents into Excel. The data is organized in tabular form in the word documents. Key Skill requirements: - Advanced level competency in Excel and Word - Attention to detail to ensure no data discrepancy - Speed and accuracy Experience in similar projects would be an added advantage. This job would suit someone who excels at meticulous organization with a knack for data structure. I await your bids.

I need a developer to create a Wix application that integrates data display features while maintaining a minimalist and clean aesthetic. The specific requirements of this project are: - The application should display specific customer data, class data, and rental data - The application should provide live updates and real-time data - It should have sorting and filtering options for the data display - Customizable data visualizations should be incorporated for users' easy and comfortable navigation The ideal candidate for this project should have strong experience and skills in developing with Wix and Wix Apps, SQL and integrating them cohesively. Understanding the importance of data management and the ability to integrate real...

I am in need of detailed-oriented individuals who can manually extract text and images from specified sections of a website. This data should be compiled into an Excel file and extracted every 4 hours. The work is fairly straightforward: * Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - data should be extracted every 4 hours and sent to me everyday The ideal candidate should be meticulous and reliable, with excellent time management skills. Familiarity with Excel and basic data extraction methods is also required.

I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If y...

I am seeking someone to help me check and complete a trial balance statement (in Excel) so that it balances (or ensure there are no main missing items on it). There are only a few items that are unresolved. I can provide data of income and expense transaction (as needed) in summarized form, including Income Statement, detail of tax filing, bank statement etc. Data will be anonymized (i.e. staff, customer and supplier names concealed) for privacy reasons.

I'm seeking a thorough and accurate compilation of flooring distributor's or contractors, home builders, or property management companies/apartment complexes, within my area...property management companies/apartment complexes, within my area, both at the residential and commercial levels. The information should be geared towards the following: - Contractor Contact Details: Your bid should reflect your capacity to provide me with a comprehensive list of names, phone numbers, email addresses, and physical addresses for these flooring contractors. Having familiarity with data entry, web scraping, and the construction industry would be a plus for this task. My end goal is to have a dependable directory I can refer to as needed. It's essential the information gathered is...

I am urgently in need of a Laravel expert who can successfully run an API request for me to retrieve user profile data from an external API. The data retrieved will be extensively used to display details on the user profile. Key Skills and Experience: - Extensive proficiency in Laravel - Strong experience with data retrieval via API request - Prior experience with user profile data retrieval The successful application will be a sure hand in API requests and data handling. I expect premium deliverables and timely execution for this project. If you meet these requirements, apply today!

Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks

As an employer looking to test the excel proficiency of job applicants, I am in need of a freelancer to create an advanced level excel test. This test should accurately assess applicants' skills in the areas of formulas and functions, data analysis and manipulation and formatting and visualization. Skills and Experience: - Profound experience with Excel including sound knowledge of advanced formulas and functions. - Prior experience in creating excel tests or educational materials. - Strong understanding of data analysis/manipulation techniques. - Competency in formatting data and visualization features in Excel. The ideal person for this job has experience in creating similar proficiency tests and has an 'advanced'...

...to build the backend for my web application. The application should have: - User authentication: The ability for users to create accounts, log in securely and manage their profile. - Data storage and retrieval: I need a system to store and retrieve various types of data within the application. - API integration: The backend should be able to communicate with external APIs, enhancing the functionality and enriching the user experience. Ideal skills and experiences for this project include: - Proficiency in back-end programming languages such as Node.js, Python, or Ruby on Rails. - Strong understanding of database management and experience with SQL or NoSQL databases. - Previous experience with building secure user authentication systems. - Familiarity with in...

...understanding of B2B lead data to enrich/cleanup our current database. The focus of this project will be centered on company data & lead emails. The task's primary purpose is to find and add employee count to each company in the database. The secondary part of the task will involve matching the leads email to the company name. Some leads have multiple emails attached- We only need an email that corresponds to the company they work for. Attached is an image of the current data layout. There are 250,000 rows of data Ideal skills and experience for the job: • Extensive experience in data enrichment, preferably B2B lead data. • Understanding of different company sizes and ability to accurately categorize them. ...

I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficien...

I have an Ubuntu VPS on Hostinger and faced an issue while setting up a tool (iRedMail). In trying to configure it, I mistakenly reinstalled mysql. As a result, I've lost the databases that were prev...specific information about the databases and tables that were deleted. I'm in urgent need of a skilled professional who can help me recover the lost databases. The ideal candidate should possess: - Profound experience in database recovery, particularly on Ubuntu VPS. - In-depth understanding of MySQL database structures. - Ability to work efficiently through command line interfaces. - Strong problem-solving skills and a methodical approach to data recovery. Given the criticality of the situation, I'm looking for someone who can help me swiftly but withou...

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 7 Hours not more then this, i had the excel to work on just make this on new sheet

I need a competent professional to smoothly facilitate the migration of my MSSQL 2019 database to a new server. Additionally, the ownership of SQL Management Studio must be changed effectively. Key job responsibilities: - Safe and efficient migration of the MSSQL 2019 database to a new server - Successfully transfer ownership of SQL Management Studio Ideal Skills and Experience: - Proven expertise in MSSQL 2019 and prior versions - Proficient in handling SQL Management Studio - Experience in successful database migration projects - Detail-oriented in project proposals Please note that only freelancers providing detailed project proposals will be considered. Your proposal should demonstrate your understanding of the project requirements as well as how you intend to ...

...to the digital menu. - **Complete POS System:** Order creation from the counter. - **Order Management and WhatsApp Updates:** Updates for customers and restaurant staff. - **Flexible Ordering:** Options to place orders from the phone, table, or home. - **Auto Invoice Generation:** Invoices sent via WhatsApp. - **Customer/Order Excel Export:** For easy management and analysis. - **Reporting:** Monthly and daily order reports. - **Menu Updates:** Upload menu via Excel, update prices and pictures anytime. - **Unique QR and Link Generation:** For pamphlets and Google business. **Ideal Candidate:** The ideal freelancer should have experience in digital menu creation and POS system integration, with expertise in real-time inventory management, customer relationship management, ...

Looking for a skilled freelancer to efficiently transfer 500 questions from Microsoft Word to an Excel spreadsheet. This task requires precision and attention to detail. If you have experience with data entry and are proficient in both Word and Excel, we'd like to hear from you. This is a straightforward project with clear instructions, offering flexibility and a competitive rate. Join our team and help us streamline our data management process.

I'm in need of a freelancer who has a vast list of verified dentist emails. This list should include the individual's name, company name, city, email address, and phone number. My main goal for this project is t...company name, city, email address, and phone number. My main goal for this project is to utilize this list for a national level marketing outreach. Ideal Skills and Experience: - Proven experience in Email List Building, particularly in the dental industry. - Strong attention to detail to ensure the validity and quality of the email list. - Ability to work efficiently and deliver the list in an Excel spreadsheet format. Please only apply if you have a pre-existing, substantial list of dentist emails. The quality of the contacts is crucial for the success of my...

I need an experienced web developer who will build a custom website tailored to my specifica...main focus of my site. Site Features: • About Us section - This will provide visitors with a comprehensive view of what my business is about. • Team Bios - I want a section where information about the people behind the business can be displayed. • FAQ - A section that will detail answers to frequently asked questions will be required. Ideal Skills and Experience: For this project, you should excel in custom-built web development, have an understanding of infopages design, and be able to build robust FAQ and Bio sections. Your portfolio should show your experience in these areas. Experience with user interface design is a plus as well since the website has to be user-frie...

I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can...

I need assistance with converting various Excel, Word, and PDF documents, making up a total of 32 pages, into a comprehensive and printable directory. Here's what would make you a great fit for this: - Proficiency in data entry and conversion between formats. - Strong skills in Excel, Word, and creating PDFs. - Experience in building and formatting directories. - A track record of delivering high-quality, print-ready documents. Key Tasks Include: - Collation and organization of information from different files. - Conversion of these files into a uniform, printable PDF. - Quality checks to ensure formatting remains consistent and ready for print. Please bear in mind, the final directory is not intended to be searchable. It should be built and formatted for prin...

I need an expert in data management and social media analytics to help create a database for my Instagram followers. Key tasks will include: 1. Organizing the database by follower engagement level. 2. Including both the username and follower count of each Instagram follower in the database. 3. Providing monthly updates for the database. The ideal freelancer for this project should have extensive experience with data organization and social media analytics. Mighty beneficial if you have prior experience creating or managing similar databases. Comfort with Instagram's platform and an understanding of how to categorize user engagement will be crucial to this project.

I'm looking to...looking to hire an experienced WordPress developer to restore both my WordPress database and website files from a backup I have. The site was running on a version of WordPress earlier than 4.x. The restoration will take place on the same domain. Skills & Experience Required: • Proficiency in WordPress database and website restoration. • Experience with restoring older versions of WordPress, specifically versions prior to WordPress 4.x. • Understanding of domain configurations and restoration processes. Please provide evidence of similar projects you have completed in the past. This project requires an expert touch so as not to lose invaluable data during the restoration process. Therefore, knowledge of data handling...

I require a professional with a meticulous eye for detail and proficiency in spreadsheet tools, such as Excel, to handle my data entry project. The data, which needs to be manually inputted, will be derived from scanned documents. Your role will primarily involve re-typing the content into neat and orderly spreadsheets. Ideal skills that you must possess include: - Speed and accuracy in typing - Proficiency in data entry and management - A keen eye for spotting errors or inconsistencies - Familiarity with spreadsheet tools like Excel - Ability to handle confidential information if it arises Your previous experience with similar projects will be a definite advantage. Kindly ensure you include it in your proposal. Please also highlight your availability...

I need assistance with Excel, specifically with its worksheet formatting feature. My main goal is to create tables and charts to visually represent my financial data. The perfect freelancer for this job should have extensive experience in data visualization, especially when it comes to: Creating accurate formulas displaying in a clean manner

As an experienced graphics designer, I need your help to create PNG and Adobe Photoshop artworks s...experienced graphics designer, I need your help to create PNG and Adobe Photoshop artworks strictly for print designs. These designs must align with the specifics in the artwork samples that will be provided. Experience with color matching is a prerequisite since the color scheme should strictly adhere to the provided samples. The sizes and dimensions for each design will be given in an attached excel file, and I require the artworks to follow these exact measurements. Bullet points: - Print design expertise - Excellent color matching skill - Ability to adhere to specific dimension requirements in artworks - Proficient in PNG and Adobe Photoshop Bid you price for all 6 designs...

I'm seeking a freelancer with outstanding Excel skills to compile a comprehensive list for personal contacts. The required data for each contact includes: - Name - Address - Phone number It's essential to meticulously organize and enter the required data into the spreadsheet. Precise attention to detail is crucial to ensure no errors are made when adding the details. While there isn't a specific order for the data I will provide you with, I expect clear and uncluttered presentation will be kept as a consistent standard. The ideal freelancer should have: - Proven experience with data entry - Keen attention to detail - Excellent organizational skills - Proficient Skills in Microsoft Excel. If this sounds like you, I encoura...

I'm looking for a skilled freelancer who can develop a comprehensive Excel dashboard for tracking financial performance. This will primarily involve creating charts and visual representations of the following data: - Sales Data - Expenses Data - Profit Data The main purpose of this dashboard is to facilitate easy tracking and visualization of our financial performance. Ideally, successful freelancers will have: - Relevant experience creating Excel dashboards for financial tracking - A deep understanding of accounting principles

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet

As a client, I'm looking for a Flask expert who can seamlessly integrate an existing Firestore database into my project. This requires a deep understanding of Flask, Firestore, and how to make them work together efficiently.

...of a developer to help me transform the tables on my web platform into a downloadable Excel sheet. This needs to be done in a way that the Excel sheet maintains the same order and all data fields as seen on our website. Job requirements: - Extract all data fields from our websites data tables - Develop a downloadable Excel sheet functionality for each table - Ensure the data maintains the same order as on the website - Use PHP and Javascript languages Key details: - Users are expected to download updates on-demand - The Excel sheet should be styled to match the website's design I'm looking for a developer who is proficient in both PHP and Javascript and has prior experience working with similar data transforma...

...require a solution to fetch real-time stock prices from the National Stock Exchange (NSE). The fetched data should populate in an Excel spreadsheet and refresh every second. Key Responsibilities: - Scrutinize the dedicated NSE platform to fetch live stock prices - Develop a method to automate data update in Excel every second Mandatory Skills: - Proficiency in Excel, with particular emphasis on data extraction and automation - Knowledge and experience of the NSE online system - Familiarity with automatic data retrieval and real-time updating This project must maintain a high standard of accuracy, as any mistakes could lead to misinformed financial decisions. Hence, meticulousness in data management and understanding of stock ...

I need a data entry expert to transpose textual data from word documents into a database system. The data is ready for immediate start and the project will ideally suit someone with solid experience in data entry, particularly with word and MySQL or SQLServer. The ideal candidate for this job should: - Have proven experience with data entry. - Be proficient with Word documents. - Have working knowledge of database systems especially MySQL or SQLServer. - Be detail-oriented and accurate. Note that this is not a one-time job, as more projects of similar nature are lined up. Therefore, demonstrating good performance might lead to more future collaborations.

I have a profile page for logged in users, and he needs to sign up for some preferences. The code will be in HTML - I need it to be saved in the database and integrated into my website on the individual profile page. The code model is this:

I'm seeking assistance with a data cleanup project using MS Excel. - The task involves deleting specific rows and columns from spreadsheets. - The data to be removed should meet particular criteria, which I'll provide. - For rows, the criteria will be either empty cells or certain values. - As for columns, the criteria will be the same. No urgent deadline, so you can work at your convenience. Ideal skills for this job include: - Advanced proficiency in MS Excel - Strong understanding of data handling - Attention to detail - Experience in data cleansing in Excel Looking forward to working with a skilled and efficient Excel freelancer.

I have a need for a meticulous researcher who can work effectively with IDA Pro. The goal is to retrieve lost source code originally written in Delphi XE. An adept understanding of both IDA Pro and Delphi is crucial for this task. Key Skills & Experience: - Proficiency with IDA Pro - Extensive knowledge of c++ programming language - Proven experience in software reverse engineering Your primary focus will be to detect, analyze, and retrieve the lost code. Attention to detail and problem-solving skills are of immense importance for this project. I am looking forward to proposals/responses describing your relevant experience and plan of action for this task.

Set up MailWizz and run several tests to verify that bulk sending emails is working properly. The personalization of emails consists in include information extracted from the Excel file (MailWizz ) and insert it into the text of the email (MailWizz Test ) Likewise, the freelancer will teach how it works to be able to carry out the next campaigns autonomously. To do this, the freelancer will make a video tutorial.

I am looking for an experie...successfully navigated. Requirements: - Expertise in Selenium development for automation - Experience with PDFs, specifically being able to automate their download - Knowledge in Captcha Bypass techniques - Understanding of data extraction procedures The primary focus is the automation of PDF downloads from the specified source. Please note, these PDFs have captcha security hence familiarity with handling such features is a necessity. Essentially, your task will be to retrieve these PDF files from the website for data extraction and offline access. Knowledge of text-based data extraction from PDFs will be an advantage for this project. Please note, this project requires a specific skill set. If you have prior experience in...

...searching for an Excel expert to help me create a dynamic visualization dashboard for health data. - The dashboard will focus on a range of health data - It will need to display specific and diverse health metrics such as age, type of therapy given, time periods, and mortality - so be able to calculate mortality, time periods, - Each individual's health record data will be detailed in a specific manner ie data will be entered as numeric code -Each patient will have about 20 data points Ideally graphs will have consistent coloring eg PD patients orange, HD = green etc- to allow for intuitive understanding The ideal freelancer for this project needs to have: - Proficiency in Excel, especially in creating dynamic and interactive d...