Excel vba access sheet data jobs

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiti...

...leaving their accommodations. We are seeking a talented graphic designer to create an attractive call to action set of materials (e.g., table tents, frames, refrigerator magnets) that will be displayed in hotel rooms, public areas, and in houses/apartments. These materials should promote our service and engage visitors to scan and order. Each design should contain a QR code that guests can scan to access our food ordering platform. This project could lead to a permanent collaboration for all our design needs. Requirements: design should be modern and inviting, appealing to tourists and business travelers. should be minimal, not intrusive, and able to blend in from a budget hotel to a luxury villa. the QR code is central and easily scannable (black and white color for the

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...

I'm running a website with an Apache2 server backend and a React frontend. The problem is, the frontend is loading with HTTPS while the backend is using HTTP, despite having a proper SSL configuration in the etc/sites-available confi file. I'm currently using a reverse proxy server to redirect HTTPS traffic to my backend server and I'm using a secur...communicate between the reverse proxy server and the backend server. Key tasks include: - Troubleshoot configuration issues to identify the cause of the HTTP/HTTPS discrepancy - Ensure that the SSL configuration on the Apache2 server is indeed correct - Verify that the reverse proxy server is properly configured to redirect HTTPS traffic to the backend server No access can be shared - work will be done via Screensharin...

I need a freelancer who can conduct a comprehensive background check for pre-employment purposes. The task involves: - Conducting a thorough check on the candidate's criminal records - Verifying the candidate's employment history - Confirming the candidate's educational qualifications The ideal freelancer for this project should be well-versed with background checks, have access to reliable databases and be able to compile the information accurately and efficiently. Please note that the privacy and confidentiality of the candidate's information is of utmost importance.

...as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file, each html file contain multiple tables. Python to extract specific table and stack them together to create an Excel file. name "現金流...

My objective is to create short duration (5-10 minutes) documentary-style videos showcasing interesting video footage of your local models for our platform. We are hiring freelance video photographers like you, to shoot easy fashion style video shows with local female models you recru...you invite to model for you, and we pay you from US$500 per shoot project, more once you become familiar with shooting for us. ModelsUpClose are video entertainment producers,  hiring video photographers from across the world in fashion style General Exhibition video shows since 1997.   It is essential we agree on your proposed model before starting a project. We have a Job Specification sheet to ensure your success and can discuss storylines and themes to suit you and your models...

My WordPress website, , is currently down and displaying a 'White screen of death'. Although I have not added or updated any themes or plugins recently, I'm unable to access the WordPress admin dashboard. I'm in urgent need of a skilled developer to troubleshoot and restore my site. Key tasks include: - Diagnosing the 'White screen of death' issue and resolving it to bring the website back online. - Investigating the root cause of this error and ensuring it does not reoccur in the future. - Restoring access to the WordPress admin dashboard so that further updates can be made, if necessary. Ideal skills for this job: - Proven experience in troubleshooting WordPress issues, particularly 'White screen of death'. - Strong background in we...

Need someone to go through one of my company bank statements for the last 8 months and prepare both years financial statements (profit/loss and balance sheet).

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

Hi I'm about to advertising a learning course. I will be delivering the co...moodle to post course materials, and interact with the course participants. A draft of the course information is attached. I'm looking for a freelancer who can support me with my Moodle platform. I have never used moodle before, so I need help with installation and setup, and ensuring that our required functionality is possible. I am working with an assistant and we both need to be able to access the participant forums to respond to queries, and to upload and receive materials. Please provide a succinct proposal, and an expectation of how long this would take. I am after a very simple solution at this stage, as the moodle element is only for communicating with participants, and not for th...

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...

I have a 5-10 minutes MP3 file that needs to be transcribed urgently. I need the transcription to be accurate and in a sheet format. Ideal Skills and Experience: - Proven experience in audio transcription - Ability to deliver high-quality work under tight deadlines - Proficiency with sheet formatting - Strong attention to detail This is an urgent project, so I am looking for someone who can start right away and deliver the transcription quickly. If you have the required skills and can meet this deadline, please bid on this project.

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

As a client, I'm in need of a few highly skilled red teamers to demonstrate that administrative level access can be gain on hardened targets. Key Requirements: - The primary goal of this project is to discover any potential weaknesses in the security of the network environment and gaps in the cybersecurity infrastructure's configuration. - We need to show the SOC how their security products can be bypassed. Ideal Skills and Experience: - Proven experience in red teaming. - Solid understanding of common security vulnerabilities and how they can be exploited. - Strong problem-solving skills and the ability to think like a cyber attacker. - Proficiency in using various pentesting tools and frameworks (metasploit, cobalt strike, sliver). This is a critical project and...

I need an employee time tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calcula...the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity with employee attendance tracking - Ability to create a user-friendly interface that can handle dat...

As an individual requiring assistance with a coloring task, I'm looking for a freelancer with proven expertise in both digital and traditional coloring. A proficient colorist is required to add life to my photographs, invoking emotions and enhancing their overall aesthetic. Key requirements: 1. Skilled in both digital and traditional coloring processes 2. Access to appropriate tools or software for digital coloring 3. An eye for detail and color - to reproduce colors accurately in digital and traditional formats 4. The ability to handle digital photos, specifically. 5. Ability to meet agreed deadlines Experience in similar projects will be a huge plus. Looking forward to seeing your amazing work.

We are building a financial application whereas you can put money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on ...

...assist in tracking, restocking, and managing our inventory efficiently. - Customer Management: Maintaining customer details for smoother transitions and personalized customer experiences is crucial. - Sales Reporting: We require comprehensive sales reports to review our business's progress and areas for improvement. Users: The software should easily accommodate 1-5 users at once, with unique access capabilities for each user. Ideal Candidates: I'm seeking professionals with experience designing and developing business-centric software. Experience with .NET, Java, or other relevant programming languages would be beneficial. Knowledge of Windows-based software development and expertise in back-end databases are essential. Applicants who understand the needs of small-t...

...enhanced by AI to provide deeper insights. - Comparison Tools powered by AI to highlight key differences. - Exportable Reports with AI-generated summaries. 6. **Security and Integrity** - AI-driven Proctoring for real-time monitoring. - Plagiarism Detection with AI. - Environment Lockdown managed by AI. 7. **Integration and API** - ATS Integration with AI-powered matching. - API Access with AI-driven functionalities. 8. **Support and Documentation** - Help Center with AI-powered search and suggestions. - Customer Support augmented with AI chatbots. - Tutorials and Training with AI recommendations. 9. **Additional Features** - Gamification with AI-generated challenges. - Mobile Support with AI enhancements. - Customization with AI-driven ...

I will need to go through your flow and also have the appropriate access to troubleshoot the issue

I need an electronic hydrometer to measu...undercharging. Key Features: - The hydrometer should have a standard accuracy of ±0.01. This level of precision is essential to correctly assess the battery health and predict any potential issues. - The data collected from the hydrometer needs to be available through a web interface. This online access will allow me to monitor multiple batteries from a central location, offering more convenience and control. Ideal Skills and Experience: - Experience in designing and developing electronic hydrometers or similar IoT devices. - Proficiency in interfacing such devices with microcontrollers. - Data should be passed to serial port of controller - Understanding of battery health and the importance of specific gravity measur...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I'm looking for a skilled professional who can assist me with updating product information on two PDFs. Additionally, I need a one-page "specials" sheet created with a professional and corporate style. This sheet should be in line with our company's branding guidelines. Key Tasks: - Update product information in two PDFs - Design a one-page "specials" sheet - Ensure the design is professional and corporate, adhering to our branding guidelines Ideal skills and experience: - Proficient in Adobe Acrobat for PDF editing - Strong graphic design skills and experience in creating corporate designs - Ability to follow existing branding guidelines while designing new assets - Attention to detail to ensure all changes are implemented accurately ...

...aesthetic. - Materials: The bathroom will feature quartz countertops. A minimum 60-inch vanity with a double sink A toilet separated from the rest of the suite by a wall and door. A tiled shower with subway tiles for both the walls and floor, possibly with a built-in bench. A walk-in closet/dressing room. Full-size 32-inch doors. If possible, the walk-in closet and dressing area should have direct access to both the bathroom area and the bedroom. We have a total area of 8 ft x 16 ft (128 sq ft) if you remove the walls. Ideal candidates for this project should: - Be experienced in designing modern and contemporary spaces - Have a strong understanding of bathroom layouts and fixtures - Possess excellent communication skills to ensure our vision is accurately captured. We are bu...

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

I'm looking to implement a user registration system for a paid tutorial video platform. Here's what I need: Script for user registration for gaining access for paid tutorial video Workflow Register new account / login fields: full name | email | password Once user creates his account, only he will access his account if he is using the same device where he first registered. Users need to register to gain access to a tutorial video. Once the registration is approve by the administrator, user will be able to login to watch video. Administrator will need dashboard for accounts administration: Registered users: Fields: full name | email | password | [Botton to active or disactive accounts. User IP/Geo Location/Device ID

For App Promo Video for Project Access, Kaybe Virtual Assistant.

...detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. ...

I'm seeking individuals with websites in various industries to place links to my three websites. I'm willing to reciprocate by placing links to your site on my platforms. The primary objective of this project is to enhance my website's traffic through valuable backlinks. $3.00 for 1 website, $5.00 for 2 websites or $10.00 for 5 websites, Not Negotiable. Key...from different industries - You should be willing to place links to my 3 websites on your platform - I will reciprocate by placing links to your websites on my platforms - The primary aim is to increase my site's traffic Ideal Skills: - Proficiency in SEO and backlinking strategies - Prior experience in link building and guest posting - Good understanding of online marketing and web traffic - Access to we...

...Backend. The backend should integrate with a PostgreSQL database. Key Functionalities: - User Registration and Login: Implement a secure user registration and login system that allows players to create accounts and access the game. - Game Settings Management: Develop a platform that can manage the game settings, with a particular focus on the Slot Machine settings. These include Win Occurrence, Free Spin, Balance, and other relevant parameters. - Database Integration: Connect the Flask backend to the PostgreSQL database so that it can store and retrieve the necessary game and user data. Ideal Skills and Experience: - Proficiency in Flask and PostgreSQL. - Previous experience in converting HTML5 games to online backends. - Understanding of casino game mechanics and settin...

I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and sh...bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so ple...

I have a Python file that was running fine last night for data analysis purposes. However, after trying to upload the '' file to GitHub, I encountered an error due to the file size being too large for GitHub. I need to get the Python file running again, but with the '' file stored on an external service to work around the file size limitations of GitHub. Key requirements include: - Identifying and resolving the issue causing the Python file not to run - Storing the '' file on an external service and adjusting the Python code to access it from there Ideal Skills and Experience: - Proficiency in Python - Experience with data analysis and handling large datasets - Familiarity with version control, specifically using GitHub - Ability to trou...

I'm looking for a skilled SAP FICO consultant with expertise in the Financial Accounting (FI) module. The selected professional will primarily handle: - General Ledger (GL) management - Accounts Payable (AP) - Accounts Receivable (AR) - Bank-related activities Additionally, you will be required to generate key reports including: - Profit and Loss Statement - Balance Sheet - Cash Flow Statement Ideal candidates should have in-depth experience managing the above tasks within the FI module. Extensive knowledge of SAP FICO and a keen understanding of financial reports are vital for this role.

I want someone who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's relate...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...

I've developed a database using MongoDB for dummy user data. I need an expert to review and enhance it in terms of schema design and security. Key Aspects for MongoDB Schema Design Review: - **Naming Conventions**: Ensure the names of collections and fields align with established conventions. - **Data Types**: Verify that the data types are correctly assigned and appropriate for each field. - **Indexing**: Check if indexes are set up and utilized effectively. Security Measures and CIS Benchmark Review: - **Authentication and Access Control**: Validate that the authentication mechanisms and access controls are properly implemented. - **Encryption and Data Protection**: Review the existing encryption measures and data protection strateg...

I'm seeking a skilled and innovative freelancer who can develop a ride optimization algorithm platform for Uber, Lyft, IDrive, and Get Transfer drivers in the United States. This platform should give drivers access to the most profitable rides in real-time, ultimately increasing their revenue and efficiency. Key Platform Features: - Ride Optimization Algorithm: The platform must have an algorithm that helps drivers select long and more profitable rides in real-time. - Real-Time Demand Prediction: It should also predict real-time demand to help drivers make informed decisions. - Fare Estimation Tool: The platform should have a feature to choose the longest and pricing ride from the App ride pool, as well as automatically accept the best rides for the driver. Additional Featur...

...chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data integration possibilities. Please bid only if you are skilled in these areas and ready to collaborate on this task. 'm looking for a skilled freelancer to program an AI chatbot that integrates seamlessly with Google Assistant. The chatbot should handle verbal prompts to perform various tasks, access phone functions when given verbal permission, and search online public sites for data collection and ana...

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

We are looking for individuals who are task oriented and can assist in saving audio documents from online databases with full permissions. Your main task is to focus on ...Have a Dropbox account with a minimum storage capacity of 1TB. - Exceptional attention to detail to ensure each file is stored properly and organized. - Ability to work quickly and efficiently, with 1 day deadlines. - Has unlimited internet connection with high download and upload speeds. Required Skills and Abilities: - Good file management skills to ensure all files are organized and easy to access. - Ability to work independently or in groups and complete tasks on time. If you meet the qualifications above and are interested in joining our team, please submit your experience with managing audio files and usin...

Introduction We are seeking proposals from experienced web scraping and data analysis firms to conduct a comprehensive data collection and analysis project. The purpose of this project is to gather detailed information on menu items, pricing, customer ratings, promotions, and deals from various food delivery mobile apps operating within our city. The goal is to mine this data for actionable insights to inform our advertising, promotional strategies, and competitive benchmarking. 2. Project Scope The selected vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer ratings, and associated promot...

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

...These suppliers will send us three specific types of data through their APIs - customer information, product information, and order information. Key Requirements: - Connect the webapp with Supplier A, Supplier B, and Supplier C APIs. - Extract and process customer information, product information, and order information sent by these suppliers. - Display this data on the webpages of the application. - Store this data efficiently in a database. Skills and Experience: - Proficient in PHP and API integration. - Strong understanding of database management. - Experience in handling customer, product, and order data. - Detail-oriented to ensure accurate data extraction and display. - Ability to create a seamless user experience through webpage data p...

I need an expert in construction and steel design to create a model for a mild steel mezzanine. The primary purpose of this structure is storage, and it's intended for storing warehouse goods. Key Requirements: - Familiarity with mild stee...create a model for a mild steel mezzanine. The primary purpose of this structure is storage, and it's intended for storing warehouse goods. Key Requirements: - Familiarity with mild steel construction - Ability to design a sturdy and durable mezzanine suited for storing warehouse goods - Knowledge of safety regulations and requirements for storage mezzanines - Experience in designing ship ladder access routes The final deliverable should include detailed specifications for construction. Please, include examples of similar works co...

...Google Sheet with Tranferz API. We need the API to retrieve and update data on our sheet based on the following specifications: - Fetching and updating Driver Information: The API will need to fetch and update data related to drivers. This includes their availability, current location, and other relevant details. - Displaying Ride Details: The API should be able to fetch and display ride details for each driver. This information is crucial for the drivers to efficiently manage their schedule and assignments. - Updating Payment Information: It is essential that the API updates payment information in our Google Sheet. This includes payments received, pending payments, and other financial details. I'm looking for a professional who can ensure that ...

...person within each company. This could be anywhere between 10 to 30 people per company. - The information should be accurate and up to date. - If you have a strategy for obtaining this data, please share it in your bid. Skills/Experience: - Strong research skills - Data entry and data mining expertise - Proficient in Saudi Arabian business landscape - Attention to detail and accuracy - Web scraping - Web search - Leads Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets. Send me: 1- Your strategy in finding those companies and collecting names and emails of relevant employees, 2- Total...