Vba code to open excel file jobs
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm looking for a skilled professional to assist with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Id...
I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.
I'm looking for a minimalist logo for my architect studio. The logo should incorporate the studio name or initials in a sleek, clean, and modern design. Ideal Skills: - Graphic Design - Logo Creation - Branding Expertise Experience: - Prior work with minimalist design - Portfolio featuring architectu...looking for a minimalist logo for my architect studio. The logo should incorporate the studio name or initials in a sleek, clean, and modern design. Ideal Skills: - Graphic Design - Logo Creation - Branding Expertise Experience: - Prior work with minimalist design - Portfolio featuring architectural or design-related logos. Please note, the color scheme is still open to suggestions. Black and white will definitely work but I'm open to earth tones...
...seeking a skilled blockchain developer to rebuild and set up a wallet scanner specifically for the Solana blockchain. The scanner’s primary purpose is to identify profitable wallets worth copying, based on reliable data metrics such as Profit and Loss (PnL), win rate, and performance over weekly/monthly timeframes. The current implementation is plagued by inaccurate or false data, resulting in wallets with near-zero balances being reported as highly profitable. Despite trying multiple APIs (Solana public API, GMGN API, and BirdEye API) and even scraping data from relevant websites, the results have been inconsistent and unreliable. This project requires a solution that not only filters out fake or non-credible wallets but also provides a robust mechanism to...
...Short-Form Real Estate Video Editor (Fast Turnaround Needed!) ✨Offering pay for every edit completed✨ Are you a skilled short-form video editor who knows how to turn real estate talking head content into engaging videos under 60 seconds? Do you excel at delivering scroll-stopping edits quickly while maintaining quality? We’re looking for someone who specializes in short-form content that captures attention and drives engagement! What We’re Looking For: Expertise in editing short-form real estate talking head videos (less than 60 seconds) Strong knowledge of platform-specific trends (Instagram Reels, TikTok, YouTube Shorts) Ability to create dynamic captions, transitions, and hooks that capture viewers' attention in the first 3 seconds Efficie...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
...you ready to bring your creativity, organization, and communication skills to the forefront? We’re looking for a dynamic Remote Real Estate Marketing, Outreach, & Transaction Coordinator to join our growing team. If you’re passionate about real estate, love connecting with people, and thrive on keeping deals moving smoothly, we want to hear from you! What You’ll Do As a vital part of our team, you’ll: Cold Call & Client Outreach Build genuine connections with property owners and motivated sellers through outbound calls. Use persuasive communication to uncover opportunities for real estate deals. Engage with past clients to collect testimonials and success stories that highlight our impact. Marketing Campaign Man...
I am seeking an experienced sales professional, specifically a senior-level candidate, to close sales for my consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience in consulting industry - Experience in recruitment - Exceptional communication and negotiation skills - Ability to understand and convey the value of our services - Committed to making a positive impact Required: - Be located in the Pacific Northwest - Be open to commission-based work Desired: - Mission-based (you want to make a difference)
I'm looking to build a website that facilitates file uploading and retrieval. The specific requirements are as follows: - The site should allow users to upload and retrieve various types of files, including documents, images, and videos. - Landing page with parallax scrolling. - Login functionality to help users to upload and retrieve files. - Website able to run photos/videos (built-in) - Robust security measures to protect users' files and personal information. - CMS access for admin to manage files, users & password in batch - Mobile responsiveness to cater to users on different devices. The ideal candidate for this project should have a strong background in web development from scratch (eg with/wo cpa...
...photoshoot. We are open to casual as well as traditional photos - whatever looks gorgeous. The shoot will take place in beautiful outdoor nature settings like parks, forests, or beaches. We live in Seattle area and wish to cover nearby locations that are popular for wedding/prewedding photoshoots. Key Requirements: - Experience in capturing natural and casual moments - Expertise in outdoor prewedding photography, particularly in nature settings - Ability to suggest suitable locations and times for optimal lighting and scenery - Proficiency in editing to enhance the natural beauty of the images This is an opportunity for a creative photographer to capture a love story in a serene and beautiful backdrop. Please include examples of similar work i...
...command, including managers and supervisors. 3. Allowing supervisors and managers to see their respective employees by ID and name. 4. Ensuring that supervisors and managers are also listed as employees under the top officer. 5. Developing a system where each employee can see who their immediate superior is. I am open to suggestions regarding the top office table's content, but ideally, it would include names, roles, and departments. Ideal skills for this project include: - Advanced proficiency in Tableau, - Experience with creating hierarchical structures in data visualization, - Understanding of organizational data and employee relationships. Please note, relevant data for the top office table will need to be inferred or created as you see fit, as...
I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail
I have a Xamarin code for iOS and Android apps, written in 2020. I have installed visual studio 2022 on my Mac. when i try to run the project, it is throwing errors as it is 2020 code. Need a developer who can fix the environment issues and generate iOS and Android app builds.
I am seeking a proficient freelancer with expertise in automating data entry tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minimal room for errors. Accuracy and speed are of the essence in...
I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give i...
I'm seeking a skilled professional to create a CNC file for my logo. The file will be used with a plastic CNC machine, specifically working with HDPE 2 ply material. The logo design needs to incorporate intricate patterns. Ideal Skills and Experience: - Proficiency in CNC file creation - Experience working with plastic CNC machines - Understanding of HDPE 2 ply material - Ability to design intricate patterns - Prior experience with logo design
Core Features: Range Monitoring: Two Adjustable Time Ranges: Monitor price within two user-defined time ranges (start and end times adjustable to the second for each range). Price Entry Monitoring: Instead of placing OCO orders immediately, monitor the price until it is within 5 points of the entry point for each time range. Order Placement: Submit a stop order when the price is within 5 points of the high or low of the range for either session. Cancellation Logic: If an order is placed near either the high or low but remains unfilled, and the price moves to the opposite side where another order is placed and filled, immediately cancel the unfilled order from the initial side. Trade Management: Stop-Loss Monitoring: For the reverse trade, monitor when the price
...developer to integrate a Telegram bot with Python code that will execute predefined terminal commands. The system should take messages which are broadcasted to the bot and execute the corresponding command. Key Requirements: - Python programming skills - Experience with Telegram bot development - Familiarity with terminal commands - Knowledge of MySQL for querying The primary goal of this project is to automate the execution of specific tasks via the Telegram bot. The user will interact with the system by sending MySQL queries, which the bot will interpret and respond to. The ideal freelancer for this project should be able to help me with the following: - Executing predefined commands - Using MySQL queries to trigger these commands - E...
...software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the outline and flow. Please DM me if this isn't clear - I would like each page to have the same attractive single-color background. The text colors described above are NOT the colors that I want to Question & Answer text. Those texts can be the same, but should look good with the background Additional Information...
I'm in need of a reliable professional who c...professional who can design and build an online lead generation form for me on (a platform similar to typeform). The form should be completed within 24 hours and then tested. Following this, I would like to see the form and any modifications made within the next 48 hours. Key Responsibilities: - Create a lead generation form on - Incorporate multiple choice and open-ended questions - Implement conditional logic for certain questions The ideal candidate for this project should have: - Prior experience with or similar platforms - Excellent understanding of lead generation strategies - Proficiency in creating and implementing conditional logic in online forms - Ability to deliver quality work under tight dead...
I'm looking for a quick Python script that can help me automate the reading and databasing of LAS file format headers using the LASIO library. The product tables should be exported in csv format. - Read a library of LAS files - Ingest and export CSV files The task is straightforward: there's no need for specific processing or data transformations on the files before exporting to CSV. The ideal freelancer for this job should have: - Proficiency in Python, particularly in file handling and CSV manipulation - Experience with automating tasks using Python scripts - Ability to deliver a simple and effective script in a short timeframe.
I'm in need of a modern, black and white DJ logo for 'DISCO DAVE'. The design should embody a contemporary style while being clean and easily recognizable. Ideal Skills: - Graphic Design - Logo Design - Illustrator Proficiency - Modern Design Aesthetics Please note that the design should solely utilize black and white, focusing on sharp contrasts and clean l...being clean and easily recognizable. Ideal Skills: - Graphic Design - Logo Design - Illustrator Proficiency - Modern Design Aesthetics Please note that the design should solely utilize black and white, focusing on sharp contrasts and clean lines, without incorporating any additional color palettes. The absence of specific elements in the design leaves room for creative interpretation, so I'm open t...
I'm looking for a skilled CAD designer who can convert my 2D JPEG/PNG drawings into high-detail STL files for 3D printing. These files will be used to assemble a scale model of a locomotive headlight. Ideal Skills: - Proficient in CAD software - Experienced in creating STL files for 3D printing - Detail-oriented and able to replicate intricate designs - Familiar with converting 2D drawings into 3D models Requirements: - Use the provided JPEG/PNG drawings to create high-detail STL files - Ensure the files are suitable for 3D printing - Deliver the completed files in a timely manner I already have the 2D drawings, and they are available in JPEG/PNG format. I require high-detail STL files that accurately represent the intricacies of the locomotive headlight. The i...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
I need an expert in Libre Office to assist in transferring files to PDF. Key Requirements: - Transfer of text documents from Libre Office to PDF - Dividing the master document into three separate files Ideal Skills: - Expertise in Libre Office - Proficient in creating and formatting PDFs - Attention to detail to ensure contents are accurately divided
I'm seeking an experienced professional who can integrate the Binance API into my React.js application. The exact details and functionalities required from the API can be discussed further, as I'm open to suggestions based on your expertise. the candidate should work on binance future trading api based on current ongoing project which has been done around 70 %. This project should be completed. if the freelancer dose not have the own binance account verified, don't bid. Thanks.
Project Description: We are seeking a skilled developer to create a freelance platform dedicated to all types of automotive services. The platform will allow businesses and individuals to list services like tire changes, car washes, repairs, detailing, and more, while giving customers an easy way to browse and book appointments. The initial version of the platform doesn’t need to be overly complex but should include: - A user-friendly design for service listing and booking. - A revenue system (e.g., commissions on bookings or fixed fees for service listings). Requirements: -Experience building service-oriented marketplaces or similar platforms. -Strong understanding of intuitive user interfaces and functional design. -Ability to scale th...
I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.
I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates
I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.
I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous work with travel-related...
I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
Custom PHP Script for Batch Code Update in MySQL Database I am looking for an experienced PHP developer to create a simple and effective script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warnin...
...native Italian person with excellent command of English to work in small ongoing projects. For now we have small updates from time to time, to some of our clients, that they need to be translated from English into Italian. This is though a good opportunity for someone who can do punctual work from time to time as well as for bigger projects when our clients require to translate full websites. Most of our content is gambling (casino) related, so if you have previous experience or knowledge in the theme it would be a plus, if not, you should do a research on terminology, although content is not very technical. Our rate is based per word and it is 0.02 usd/word. We can either open a contract and pay everything through there or open...
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
I'm seeking a professional with expertise in LiDAR technology for a security project. The primary focus is on the detection of flying objects in outdoor open spaces. Key Requirements: - Design and implement a Live LiDAR sensor system capable of identifying flying objects. - Utilize point cloud object detection techniques to enhance surveillance capabilities. Ideal Skills: - Proficiency in LiDAR sensor technology and point cloud processing. - Experience in developing systems for security and surveillance. - Knowledge in detecting specific objects, particularly aerial entities. We use Velodyne lidar as the main source of point cloud (velodyne .py driver is available with ROS2)
...facilitating social interactions. App name will be Canary. Language Selection As a user, I can sign in and select the language I want to learn (e.g., French), so the app can tailor content to my language learning goals. Song of the Week As a user, I can discover a "Song of the Week" that is trending in my selected language, so I can engage with culturally relevant content. As a user, I can click on the Song of the Week, and it will open a TikTok/Reel-style video with a generic background, bilingual lyrics, and translations displayed in real-time, so I can learn while watching. As a user, I can click on individual words in the lyrics to see their translations and save them to a vocabulary list for review. As a user, I will be quizzed at th...
I need my Excel data modified for better visual appeal and branded to match my website. Requirements: - Apply custom themes and colors to the Excel file. - Incorporate my website's color scheme and font style. - Add my contact number to the header of the Excel file. There's no need to change any of the data, as everything has already been filled.
I have an Excel sheet with text data in various columns that needs to be sorted according to a specific sequence. The task involves: - Identifying the text data in the columns - Sorting this data following a predetermined custom sequence Ideal candidates for this project should have: - Proficient Excel skills - Experience in sorting data according to custom criteria - Attention to detail to ensure all data is sorted accurately according to the specific sequence
...experienced architect or interior designer to design the layout for my two-story building. Each floor is approximately 600 square meters, and the staircase to the upper floor is already located and fixed. The project includes: Upper Floor (Medical Clinics): The upper floor will be dedicated to medical clinics. The goal is to maximize the number of clinics while maintaining usability and comfort. Each clinic should include: • A doctor’s room • A small bathroom • A front desk for the assistant with seating for 2-3 people in the waiting area Requirements: • Efficient space utilization • Comfortable, professional environment • Adherence to building and safety codes Deliverables for Upper Floor: • Floor pl...
I need someone to create a excel spread sheet to show and auto populate the following cost and expenses Labor Costs: Track employee hours worked in each service category using timesheets or a time tracking system. Record the hourly wage for each employee. Calculate daily labor cost: (Number of employees) x (Hourly wage) x (Hours worked). Supply Costs: Maintain a daily log of all supplies used in each service category. Record the quantity and unit cost of each supply item. Calculate daily supply cost: (Quantity used) x (Unit cost) for each item, then sum up all item costs. Vehicle Mileage: Record the starting and ending mileage for each company vehicle used daily. Calculate the total mileage driven for each vehicle. Fuel Consumption: Collect and retain all gas card rece...
I need an Excel spreadsheet designed for daily expense tracking and financial calculations. The ideal freelancer for this project would be someone with strong Excel skills, particularly in creating formulas and functions for financial analysis. Key Requirements: - Create an Excel spreadsheet for daily expense tracking - Implement financial calculations within the spreadsheet - Ensure the spreadsheet is user-friendly and easy to update Skills & Experience: - Strong proficiency in Excel - Experience with financial spreadsheets - Excellent attention to detail
Project Description: We are seeking a freelancer specialized in web design and development to optimize our website dedicated to chronic pain, health, and wellness. The primary goal is to improve the site's aesthetics and functionality while also implementing secure monetization options, a consultation booking system, and a patient data protection system to ensure compliance with privacy regulations. Project Objectives: 1. Website Design: o Improve the website’s appearance and functionality to make it attractive, professional, and user-friendly. o Create a clean, modern design focused on an optimal user experience. o Ensure the design is fully responsive and optimized for mobile devices. 2. Monetization: o Integrate secure payment options for he...
I'm seeking a developer to create a straightforward Android APK for route sales. This app should facilitate ticket issuance via portable thermal printers, overseeing stock in delivery trucks, and locating customers on a map. Key features should include: - Stock Management: The app must effectively manage inventory on delivery trucks. - Customer Location: It should assist in pinpointing customer locations on a map. The app needs to function offline with both automatic and manual data synchronization when internet access is available. The dashboard, meant for advanced analytics, should track: - Top Customers - Best-Selling Products - Delivery Staff Performance This dashboard will have role-based access to limit sensitive information. Additionally, the app sh...
