Excel vba access sheet data jobs

...approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google Mapping - Knowledge with AWS and setting up Linux servers and MySql databases Your team will be replicating our current site, which includes the following centers: - Customer Management - End user management - Routing and Scheduling - Billing and Invoicing - Video management - PDF creation and editing You will use the fol...

...involves creating daily orders from templates, designing new product images, and assisting with branding efforts. Responsibilities: Utilize Adobe Illustrator to create and modify designs based on provided templates. Generate new product images for our online listings on platforms like Amazon and eBay. Assist in branding projects to enhance our company's visual identity. Work with provided files and access resources to fulfill daily orders. Input information from spreadsheets into AI templates, adjust text, and save the files as needed. Requirements: Proficient in Adobe Illustrator with a strong understanding of the software. Experience in creating product images and listings for Amazon and eBay marketplaces. Excellent attention to detail and ability to follow instructions...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

... (ns-2 not yet added in the .net zone). Server locations are AWS Oregon, Germany, and Germany, respectively, all on different AS. DNS services run on TCP and UDP ports of IPv4 and IPv6. The name servers are their own authoritative servers, so there are glue records in the .net zone, see attachment. I can send you the bind configuration files. Unfortunately, I cannot give you SSH access to the servers. If you need to add records to the servers for debugging purposes, I'm happy to do that. Can you help me?...

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient ...with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me res...

I need to scrape data from a website. I'm stuck with an error. I used improtxml to scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it wil...

I'm currently facing an issue where my neighbour has erected fences, shed, and posts outside their curtilage which impede access to my property. Despite my previous attempts to address this issue with Cheshire West and Chester's planning department, they acknowledged the breach, but opted for nonintervention. I am seeking professional legal assistance from a freelancer with a strong background in property law and proven track record in handling similar cases. Key Responsibilities: - Understand the case circumstances - Develop and execute an effective legal strategy - Communicate with the neighbour and relevant authorities Ideal Qualification: - Law degree with specialisation in property law - Demonstrated experience in dispute resolution - Excellent interpersonal ...

...a personal E-commerce data analysis project. I have access to a range of data sources including E-commerce platform data, sales data, and payment data. The primary goal is to create a comprehensive report that delves into the sales and payment analysis of my E-commerce business. Key objectives for this project: - Identify sales trends: I'm looking to understand the various sales trends that have emerged from the data over the period of time it covers. - Analyze payment methods: I want to categorically understand how my customers are paying for their purchases, and if the payment methods are changing over time. - Discover customer preferences: The project also aims to uncover key customer preferences and behaviors. Your role will in...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data m...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the ...

I'm looking for a skilled individual to assist me in adding unlimited plays to a magnetic swipe arcade game card. Key Requirements: - The card used is a magnetic swipe card, so prior experience with this type of card technology is essential. - I don't have access to the card's management system, so the solution needs to be standalone. - The primary purpose for this task is for research and testing purposes. The task itself is relatively straightforward - I need you to bypass any limitations set on the card to allow for unlimited plays. This project is time-sensitive, so I'm looking for someone who can deliver efficiently and communicate effectively throughout the process.

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

...need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong unde...

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. - Manually need to collect data from various source 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 in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis...

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...

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.

...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(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create ...

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...

We're seeking a detail-oriented and web-savvy freelancer/contract...resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. • Ability to work independently and manage time effectively. • Famil...

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...