Access vba manipulate excel spreadsheet jobs
I have a 10 page annual report that i need populating from excel. The task is very simple max 1 hr. I will send you a word document that requires you to put in 2024 numbers from excel. and check the notes are corresponding to Balance Sheet, P&L and etc. general check for casting and cross casting. These accounts are not audited and they are fairly simple.
I need an experienced developer to set up a comprehensive, secure sign up and login system for my CRM. The system should include: - Authentication through email and password, social media logins (Google, Facebook, LinkedIn) and Two-Factor Authentication for heightened security. - A user role management system with different roles and permissions, enhancing access control and data security. Ideal candidates for this project should have extensive experience with CRM systems, user authentication, and role management. Proficiency in integrating third-party services is crucial, as well as a deep understanding of security protocols to implement Two-Factor Authentication effectively. This project is not just about setting up a login system; it’s about creating a robust, secure, a...
My vending machine business in Newcastle NSW Australia needs an expansion. Currently, I have 2 machines in industrial buildings with around 30 employees in Thornton. I'm looking for more similar sites, ideally within a 20 km radius of my existing machines. Criteria for new locations: - Open 24 hours or at least until 9-10pm - Housing 30+ employees - Relatively easy access to the site - Primarily manufacturing facilities Key Features: - High foot traffic - Extended operating hours Ideal Skills: - Location scouting - Understanding of vending machine business - Knowledge of local industrial areas Experience: Previous work in site scouting for vending machines or similar businesses would be highly advantageous. Please only apply if you have a good understanding of the criter...
I require an expert in Ping Federate and ping access with in depth experience in SAML to assist with its initial setup of a few inbound SSO connections where ping will be the service provider. Please provide examples of previous similar projects you have successfully completed.
...manage hundreds of Linux servers in a load-balanced, high-availability cluster. Install, configure, and customize Moodle, including plugins and themes. Optimize the MySQL database backend for performance and scalability. Implement and manage caching solutions (e.g., Redis, Memcached) to improve response times. Integrate authentication and authorization systems (e.g., LDAP, SAML) for secure user access. Implement security best practices to protect the platform from vulnerabilities and attacks. Automate system administration tasks using scripting (e.g., Bash, Python). Performance Tuning & Optimization: Setup monitoring system for performance and identify bottlenecks. Optimize server configurations, database queries, and Moodle settings to maximize performance and scalability. C...
I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.
...needed. 8. What I Will Provide The firmware code for the main controller (and sidekick if needed), which shows: The text-based commands, the wizard steps, and all possible responses. Key functionalities: - The app should facilitate diagnostics and troubleshooting processes. - It should assist in the calibration, setup, and control of the boat lift. - The app must allow for firmware updates. User Access: - The app should be accessible to both dealers/installers and end-users/customers. Ideal Skills and Experience: - Proficiency in Android app development is essential. - Previous experience with USB OTG connectivity is a plus. - Knowledge in developing diagnostic tools and firmware update interfaces would be highly beneficial....
I need a video edited to remove a paper clip from my suit. The editing style should be natural and seamless. The video is less than 1 minute long and I have access to the original file. Ideal skills for this project would include: - Proficiency in video editing software - Attention to detail - Ability to create seamless edits - Experience with natural editing styles
I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.
...communication with traders regarding job details, access arrangements, and updates. Job Tracking: Monitor the progress of each job in real-time, from acceptance to completion. Automated Reporting & Invoicing: Upon job completion, receive a comprehensive report (with trader's photos and comments) and an automatically generated invoice. Document Management: Download or print job details, quotes, reports, and invoices in PDF format. Offline Access: View existing job details, contact information, and previously downloaded documents offline. Draft new jobs offline; they'll sync when connectivity is restored. Membership Levels: Basic (Free): Limited job postings per month, access to a smaller pool of traders, basic reporting. Premium (Paid): Unlimited job po...
...screen layouts and symbols (training will be provided). Strong organizational skills for managing large volumes of image files. Preferred Skills Experience with visual data or image organization. Knowledge of file naming conventions and folder structuring. Work Conditions Task-focused role: The position involves repetitive, detail-oriented tasks. Remote role: Work from your own location, requiring access to a computer with screenshot capabilities. Video variations: The role may involve capturing data from multiple machine screen variations. Key Deliverables High-quality screenshots of machine reels captured in an idle state. Organized folders containing images labeled with corresponding video IDs and channel names. This position is ideal for individuals who thrive in structured, ...
I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Strong attention to detai...
...**5. F&B Experiences** | eCommerce, Appointments, Knowledge | Meal kit sales, virtual cooking class bookings. | #### **Additional Requirements** - **Mobile Front-End**: Responsive design (iOS/Android) using Odoo’s web framework or Flutter. - **APIs**: Integration with Ak existing CRM, ERP SAP, and property management systems. - **Security**: GDPR compliance, data encryption, role-based access control (RBAC). - **Localization**: Arabic/English bilingual support, prayer time reminders. --- ### **3. Deliverables** - **Phase 1**: Odoo backend configuration (modules setup, loyalty rules, IoT alerts). - **Phase 2**: Mobile app development (UI/UX design, API integration). - **Phase 3**: Testing (UAT, performance, security audits). - **Final Deliverables*...
I'm looking for a Python developer to create a script that ...Messages) - Enter the OTP and finalize the order - Include error handling for failed transactions and retry logic. - Browser cookies require to be cleared in between each order placed or it will fail to process When the script starts, it should take input of coupon codes, when it is finished, it should show output of order ID numbers now that the codes were used. The script should utilize an API to access my Google Messages for OTP retrieval. The ideal candidate for this project should have: - Proven experience in Python programming - Familiarity with IBM WebSphere - Prior work with e-commerce automation - Experience working with APIs, particularly for SMS retrieval - Ability to write clean, efficient, and well-d...
The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully completed the aforementioned steps. 1. The...
...not-for-profit organisations. These not-for-profit organisations submit an application to seek a capital grant. Within the application, the not-for-profit provides financial information in two parts. An Excel spreadsheet and audited financial statements. This information is used to assess what level of financial contribution the not-for-profit can make from its own resources to fund its capital project. The Excel spreadsheet contains formulas to produce a range of financial ratios from data contained in the spreadsheet. A staff member currently reviews the data integrity in the spreadsheet, financial ratios, and audited financial statements. This process is time-consuming. Whilst there is every attempt to ensure the review process is ...
I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.
Set up to run 300 emails a day Create 14 emails Set up 14 day auto responder Provide and create campaign from ideal client worksheet Setup Google Analytics based on having access to being able to update the website with google information Provide reporting Predicated on fact finding worksheet data 2 hour consultation via phone Provide emails and contact list of leads based on ideal client worksheet Make sure campaign is running and sending Monitor with reporting and consult times
I'm seeking a professional for comprehensive installation and configuration of our Ubiquiti devices. Key Tasks: - Installation of Dream Machine Pro, Cameras, and Access Points - Configuration of the Dream Machine Pro - Setting up online backups for our business and commercial customers - Implement robust network security measures and firewall configurations. - Perform firmware upgrades for all Ubiquiti devices to ensure they are up-to-date. - Set up and configure VPN access for remote workers. - Configure VLANs for network segmentation and enhanced security. - Set up and configure a guest network with appropriate policies. - Set up automated alerts for network issues and performance metrics. - Provide training to staff on the use and maintenance of network systems. Ide...
My iPhone appears to be compromised. I need a professional to conduct a thorough check and restore my phone to its original state. Issues I'm Experiencing: - Unusual battery drain - Strange pop-ups or ads - Unauthorized access to accounts - Pictures being shared without proof Steps I've Already Taken: - Device reset - Anti-malware scan - Updated to the latest iOS Freelancers with experience in cybersecurity, particularly with iPhones, would be ideal for this project. Please include in your bid details of your experience with similar projects, and any strategies you would employ to resolve my issue. Thank you.
I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.
...project proposals in the photography industry. This role focuses primarily on crafting compelling and persuasive proposals to secure new projects and clients. Our proposal templates need to be completed and altered per client using CHAT GPT and midjourney/pinterest to help complete the design. No lead gen required, we have that sorted for you. You will have access to our generic email inbox to create the draft emails for us to approve, also access to our canva and midjourney log ins. This will be ongoing work and looking to start with 5 hours per week. Key Responsibilities: - Writing project proposals tailored to the photography industry. Ideal Skills and Experience: - Exceptional writing and communication skills in English - Previous experience in proposal writing, part...
Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based on plant...
As a small manufacturer, we're in need of a proficient Microsoft Access expert to design an inventory database for us. The primary purpose of this database is to track our inventory levels, taking into account incoming and outgoing shipments. This data will be updated daily. Key Database Features: - Tracking of item names and quantities - Management of supplier information - Monitoring of shipping details Ideal candidates should have prior experience in developing inventory databases, particularly with Microsoft Access. They should possess strong skills in database management, data analysis, and software development. Familiarity with manufacturing processes and supply chain logistics would be an added advantage.
I'm looking for a SharePoint specialist to review architecture for the design of an Intranet portal for my organization. This portal will primarily host project-related content. Ideal Skills: - Extensive experience with SharePoint architecture. - Strong understanding of intranet portal development. - Proven ability to set up complex permission and access control systems.
I need assistance exporting quotes from an Excel price list into a Word document. The quotes should be organized by product category. The exported quotes should include the following details: - Product name and price - Vendor information - Quote expiration date Ideal skills for the job include: - Proficiency in Excel and Word - Attention to detail - Organizational skills
Please Sign Up or Login to see details.
I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc. Key Requirements: - Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence). - Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on. - Allow me to constantly update the list of 1000 numbers. - I will be copying and pasting the numbers into the file. Outputs/Reports Needed: - A summary table that presents the movements in a clear and comprehensible manner. - Please use standard formatt...
I am looking for an expert in web penetration testing. The main goal is to get admin access of my brother's website so that we can see how our website is doing. I am ready to pay hefty amount for it Your task will include: getting admin access of my website The ideal candidate has: - Proven experience in web penetration testing - Strong understanding of security protocols - Excellent problem-solving skills
I'm seeking a detailed contact list of roofing, restoration, and mitigation companies located in California & Florida. The list should be compiled into an Excel sheet and include: Construction Companies: 1. Mitigation 2. Restoration 3. Reconstruction 4. Roofing 5. Water, Fire, Hail Damage. - Company name and address - Phone number and email - Key contact person's name and role - Specific roles such as Owner, Sales Managers, and HR Ideal skill set for the job includes proficiency in data collection and Excel, and ideally, some experience or understanding of the insurance roofing and restoration industry.
...VLANs for logical isolation of devices if needed for scalability. ✅ Laptop Configuration (10 Devices): Pre-configure 10 Dell Latitude 5420 laptops with Windows 10 Pro (or Windows 11 Pro). Assign static IPs to each laptop and confirm connectivity. Install and configure Multilogin, BleachBit, and Technitium MAC Address Changer for security and privacy. Set up automated session timers, restricted access, and Group Policies to prevent unauthorized modifications. ✅ Security & Performance Optimization: Implement bandwidth controls and traffic monitoring to simulate realistic usage patterns. Enable Deep Packet Inspection (DPI) on the EdgeRouter to detect and manage unusual network activity. Ensure MAC address randomization and automated data wiping protocols are properly configured ...
I'm seeking an experienced voice-over artist to narrate my Christian book (approx. 100,000 words / 400 pages) into a captivating audiobook. The voice should be calm and soothing, suitable for faith-based content. Requirements: - Proven experience in audiobook narration, preferably within Christian or non-fiction genres - Access to a high-quality recording setup to ensure studio-quality audio - Clear and articulate pronunciation - Ability to provide the final product in MP3 or WAV format, ready for distribution Deliverables: - A fully edited and mastered audiobook, handled entirely by the narrator - Audio divided into chapters, with appropriate pacing and clarity - Willingness to revise if needed for accuracy Please include samples of your previous work in your proposal. I l...
I need to deploy two custom PHP applications on my Hostinger hosting. Both of these applications require a database setup. Key Requirements: - Experience in deploying PHP websites - Proficiency in database setup and management - Familiarity with Hostinger hosting services - Familiarity with using SSH access for efficient deployment on Hostinger - Knowledge of implementing security best practices during deployment Please ensure you can handle both the deployment and the necessary database setups before bidding.
Project Description: Logo Design for a Restaurant We are looking for a talented graphic designer to create the logo for our restaurant : « Chez Mamadou » Artistic Direction: • A classy, memorable, and timeless design • Elegant style, easy to recognize • Clean and readable typography • A subtle graphic element that evok...subtle graphic element that evokes the restaurant industry • Maybe a refined color palette (avoid overly bright colors) Avoid: • Excessively complex details • Overused visuals (crossed forks, basic serving cloche, etc.) The logo should be versatile and adaptable for different uses (signage, business cards, packaging, social media, etc.). We would like to receive multiple proposals and have access ...
I need help analyzing a list of companies in Excel and identifying duplicates based on specific criteria. Your task will also involve assigning MTAuIDs to these companies according to a set of rules. Key Requirements: - Identify duplicate companies based on their Business Name - Assign different MTAuIDs to Joint Ventures - Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business. Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of business structures.
...communication and file-sharing features, enabling seamless team collaboration. Time Tracking and Analysis: Tools to monitor task duration, assess productivity, and generate detailed reports. Cross-Platform Integration: Compatibility with major productivity platforms like Google Workspace, Microsoft 365, and third-party APIs. Offline Capability: Allows core functionalities even without internet access, syncing updates automatically when reconnected. User-Centric Customization: Personalizable dashboards, notifications, and workflows tailored to individual or team preferences. Detailed Description of the Invention: System Architecture: The software consists of a modular design enabling scalability and easy updates. Backend servers powered by cloud computing handle synchronizat...
I'm looking for a freelancer to assist with a copy paste and data entry project. The data is mixed - both numeric and textual - and is currently stored in various online sources. Ideal Skills: - Proficiency in Excel - Experience with Tally ERP software - Strong attention to detail - Ability to work with mixed data types - Prior experience with online data sourcing The final output needs to be in an Excel spreadsheet. Please ensure you can access and work with online data sources before bidding.
I'm looking to develop a dynamic and colorful mobile application for both Android and iOS, centering around live streaming and user interaction. Key Features: - Comprehensive backend and frontend admin panel - Live chart integration - 9-slot video and audio rooms - VIP access capabilities - Animated gifts feature - Interactive games like Teen Patti and Ferry Wheel - An agency panel and coin seller interface - PK battles and themed rooms - Entry animations and recognition for top contributors - User profile editing, follower management, and blocking options - Invite/share functionality and user activity history tracking - Coin recharge system with agent contact info - Manual withdrawal submission via specified methods - Inbox messaging system tied to coin usage - User-generated...
I'm seeking a data entry expert to assist with entering menu information. Specifics about the menu type, the data format, and the manner in which it will be provided are yet to be determined, but the need is immediate. Ideal Skills and Experience: - Proficient in data entry - Excellent attention to detail - Able to work under time pressure - Familiarity with common data entry software (Excel, Word, etc.)
I need a VPN solution, preferably Wireguard, implemented on our custom embedded 32-bit system running Ubuntu 10.04. This system is crucial for our application and has multiple low-level drivers that are difficult to migrate. The primary goal of this implementation is to secure both remote access and data transmission. Key points: - The VPN client must run on the embedded system. - Performance impact should be minimal; the system is already optimized for our application. - Ease of configuration and maintenance is important, as we need to manage this system remotely. - If Wireguard cannot be installed, I need a reliable alternative VPN that utilizes pre-shared symmetric keys, without dependence on PKI certificates. - Note: we have full control over both the client and server. So, w...
I'm looking for an experienced data scraper who can gather information from various social media platforms. Ideal Skills: - Proficient in web scraping techniques - Familiarity with social media platforms - Excel data management skills The scraped data needs to be compiled in an Excel format. The specifics of the data to be scraped will be discussed in further detail with the chosen freelancer. Please include relevant experience in your proposal.
...Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) VILLAGE, PAOODONCHAI MUANG, CHIANG RAI, 57000, THAILAND • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to assemble a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us ti...
I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.
...analytical skills and the ability to interpret quantitative and qualitative data. •Knowledge in validating information sources and critically analyzing data. •High level of English proficiency (C1 or higher) with advanced writing and editing skills in English. •Experience working with business intelligence reports, impact metrics, or financial analysis (preferred). •Familiarity with data analysis tools (Excel, Power BI, Tableau, etc.) is a plus. •Attention to detail and ability to manage multiple reports simultaneously. Key competencies: •Critical thinking and ability to detect inconsistencies. •Accuracy and attention to detail. •Ability to synthesize and communicate clearly. •Autonomy and proactivity in problem-solving. •Adaptab...
I need my Excel worksheet polished for print. The project involves enhancing the current layout of the worksheet, specifically to optimize it for printing. Key Requirements: - Adjusting the page layout and margins to ensure the worksheet is print-friendly. - Creating a green color scheme that is suitable for printing. Ideal candidate should have: - Proficient Excel skills especially in layout enhancement. - Experience in creating print-friendly documents.
...(both template and non-template), managing WhatsApp numbers, and providing API access to third-party applications. Security is paramount, and all development must adhere to best practices. This project will utilize Azure DevOps for project management, version control, and CI/CD. Key Features: * WhatsApp Meta API Integration: * Seamless integration with the WhatsApp Meta API for sending text messages via templates and free-form text. * Ability to send documents from the user's system through WhatsApp. * Third-Party API: * Develop a well-documented API that allows third-party applications to utilize the WhatsApp messaging functionality. * Secure authentication and authorization mechanisms for API access. * Tracking of API calls made by each third-part...
...software developer with extensive experience in MS Access to create a mini ERP application tailored for my business. The application should encompass the following modules: - Sales: This module should facilitate customer management, order processing, and sales reporting. - HR: This component needs to handle employee records and payroll processing. - Procurement: The specifics for this module will be discussed later, but it will be equally important. - Accounting: Comprehensive accounting features are required. - Reports: The application should generate reports that can be easily exported to Excel or sent via email. An ideal candidate for this project would be someone with a strong background in software development, particularly with MS Access. Experience in creat...
