Vba com port excel jobs
I have financial data in an Excel spreadsheet that needs to be mail merged into a Word document. This document will then be converted into a PDF following a pre-defined template. Ideal Skills and Experience: - Proficient in Microsoft Excel and Word - Experience with mail merge - Able to convert documents to PDF - Attention to detail for template adherence This is a straightforward task for the right candidate. Please do not attempt to calculate or process the data prior to merging.
I'm in need of an Excel expert to create a dashboard that links information from 2-4 external workbooks. The external workbooks contain data related to tracking our key performance indicators (KPIs), specifically focusing on operational efficiency. Key Requirements: - Link 2-4 external workbooks to a central Excel dashboard - The external workbooks contain data on production output and employee productivity Ideal Skills: - Proficient in Excel, particularly in creating dashboards and linking workbooks - Experience with KPI tracking and understanding of operational efficiency metrics - Attention to detail to ensure accuracy in data representation and tracking This project will enable us to effectively monitor our operational efficiency, providing us with insights...
I am looking for a professional to assist with my bookkeeping tasks using Microsoft Excel. This will involve data entry and organization, managing accounts payable and receivable, and performing bank reconciliations. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience in bookkeeping and managing accounts - Attention to detail for data entry and bank reconciliation
I'm in need of a seasoned professional who can assist me in procuring low-cost multi-layer printed circuit boards based on an existing Gerber file and an Excel file bill of materials. Phase I: - Obtain a cost estimate for the PCBs and the components based on the provided files. Phase II: - Evaluate the delivered PCBs. - Proceed with the assembly of the components. My technician will handle the testing and reviewing of the assembled boards. Ideal Skills: - PCB sourcing - Cost estimation - Assembly - Multi-layer PCB expertise - Supplier negotiation
I'm looking for an expert in Excel who can help me build a comprehensive spreadsheet to track my business expenses from multiple sources including bank accounts, credit cards, and receipts. Key Features: - Daily updates: The spreadsheet should be designed to accommodate daily expense tracking. - Duplicate charge detection: The system should help identify duplicate charges automatically. - Note-taking: I need to be able to record notes directly in the spreadsheet. - Categorization: All expenses need to be categorized so I can sort and see total costs for different categories over different time periods (time periods should be customizable). Ideal Skills: - Proficiency in Excel: You should be extremely comfortable with Excel and be able to create complex formulas...
I'm looking for a...looking for a web scraping expert who can extract wine data from Tajan. The data to be scraped includes: - Bid prices: Picture 1 - Auction dates: Picture 1 - Wine details: Picture 2 See an example as an attachment Website: Needed data: all wine events from March 2020 until the end of 2024 Auction item: Wine The scraped data should be delivered in a Spreadsheet (Excel/CSV). A snippet of the data from 2013 is attached. This is a one-time project, so I do not require ongoing data collection. Ideal skills for this project include: - Proficiency in web scraping tools - Experience with data extraction - Ability to present data in a clear, organized manner Please provide examples of similar projects you've completed in your proposal. Thank you!
...should be incorporated within or around the circle. Symbolism: Digital Creativity: The logo should subtly represent digital creativity and innovation, possibly through abstract shapes or lines within the circle. Excellence and Leadership: The design should convey a sense of excellence and leadership, aligning with the brand's values. About Our Company: Mission: Rexo Studio aims to lead and excel in the digital world by providing reliable, expert, and optimized digital services that elevate our clients' online presence. Services: We specialize in graphic design, web design, and social media marketing. Our team combines creativity with technical skills to deliver innovative and effective solutions. Values: Our core values include reliability, expertise, excellence, an...
I'm seeking a skilled data processing programmer to help transform numerical data from CSV and Excel files. The primary focus of this task will be on data transformation. Ideal candidates should: - Have a strong proficiency in programming languages suitable for data processing such as Python or R. - Be experienced in working with CSV and Excel files. - Have a solid understanding of numerical data and data transformation techniques. Your expertise will help in converting raw data into a more useful format. Please bid if you have the necessary skills and experience.
Objective: Searching for reliable .com guest posting sites. Focus: High traffic platforms to boost visibility. Criteria: Strong domain authority and audience reach. Goal: Enhance engagement through impactful guest blogging opportunities. At list 10 to 15 sites
I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.
...comprehensive report summarizing findings, assumptions, and recommendations. Present financial models in an easily interpretable format for stakeholders. Key Deliverables: Financial feasibility model in Excel or equivalent software. Detailed investment and cash flow projections with supporting assumptions. Sensitivity and scenario analysis results. Executive summary with key insights and actionable recommendations. Qualifications: The ideal candidate should possess: Expertise in financial modelling for real estate projects. Strong knowledge of residential real estate market dynamics. Proficiency in Excel and financial analysis tools. Demonstrated experience in conducting feasibility studies for comparable projects. Engagement Timeline: The financial feasibility mode...
I am looking for an Excel expert to assist with data analysis tasks. I already have the data for analysis and need help in identifying trends and making predictions based on the data. The desired outcome is to gain insights from the data for decision-making purposes. Ideal skills and experience for this job include: - Strong proficiency in Excel and its formulas and functions - Experience in data analysis and visualization - Knowledge of statistical analysis techniques - Ability to interpret and communicate findings effectively
I am looking for a skilled developer to create a selection of popular Betfair casino games, specifically HI LOW, HOLD'EM, BACCARAT, Omaha Hi, and Black Jack. The main goal is to develop engaging and high-quality versions of these table games. Key Requirements: - Expertise in game development, particularly casino games. - Experience with...game development and can deliver a project that meets these specifications, I would love to hear from you. Requirements for dev tools/framework: - Blazor, for 3rd part UI components DevExpress is preffered - VS2022 (source code is required of course) - TFS or GitHub - Site will be published at Azure (it is just for information, if important) - UI theme should be compatible with fancy12.com (demo11/1122) - Should support layou...
Read current economic data and forecasts from and transfer them to an Excel table. See appendix for a list of indicators. Countries: USA, Europe, UK, Australia, New Zealand, Switzerland, Canada and Japan. Only the first page of the Excel sheet will be important to me. I would like to see the indicator(s) from the selected countries superimposed in a diagram using a checkbox. updating the data from the website should be possible at "the push of a button"
I'm in need of a skilled Data Entry Operator. The job involves working with text data from digital files, specifically Excel spreadsheets. You will be responsible for entering data into various computer databases and maintaining effective record keeping. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Strong organizational skills - Experience with data entry no
I need an expert in Excel to apply Color Scales conditional formatting on an Excel sheet containing number ranges. The color scale should span from Green to Red. Ideal Skills: - Proficiency in Microsoft Excel - Expertise in Conditional Formatting - Ability to work with number ranges Please ensure that you are able to deliver a well-formatted Excel sheet with the required conditional formatting.
I need an expert in Excel VBA to create a tool for me. Requirements: - Import specific row fields from a CSV file. I need to import Names and Addresses, Product IDs and Descriptions, Dates and Amounts, and other general things. - The import should be triggered by a menu option in the Excel toolbar. - There should be a print button to print the new sheet with the imported contents. Ideal Skills: - Proficiency in Excel VBA. - Experience with CSV file manipulation in Excel. - Ability to create custom toolbar options in Excel.
I need assistance with manual data entry. The data has to be extracted from video and organized into Excel spreadsheets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with manual data entry - Ability to accurately extract data from PDF files
Build a excel spreadsheet identical to the photo listed Must have the formulas to make the boxes work correctly I need to have these in there Daily sales Cost of goods Total cars Job averages Sales projection Monthly targets Daily targets cost of goods will be total cost minus daily sales total Total cars will need to be calculated off of total sales and divided which will bring the job averages Monthly target will make a daily target depending on days in the month and Daily sales will affect sales projection
I'm seeking an expert to track and compile a list of properties from for properties all around London only with date it was uploaded to Rightmove. The list needs to be in Excel format and should include the address of each property & identification when a property updates to sold or under offer. I have included a screenshot from Rightmove and arrows showing the data that needs to be captured. Ideal Skills and Experience: - Proficient in data collection and analysis - Familiarity with Excel - Knowledge of real estate data tracking Key Requirements: - Regularly updated list of properties with the date it was uploaded/reduced around London on Rightmove - Regularly updated list of properties that has changed its status to Sold or Under Review - Picture
Lead Generator for Instagram Influencers Are you skilled in finding Instagram influencers? Join us on a simple but rewarding project! Role: We need a Lead Generator to hunt do...Role: We need a Lead Generator to hunt down qualified Instagram influencers within a specific target market (we’ll provide details). Responsibilities: Find influencers based on our target market. Provide qualified leads in a Google spreadsheet. Compensation: $1 for every 10 leads. The first milestone is 100 leads. Plenty of similar projects are available for long-term collaboration if you excel at this task! What We’re Looking For: Someone efficient and detail-oriented. A good understanding of Instagram influencer niches. If this sounds like a good fit, let’s work together! Rea...
I'm seeking an Excel expert to create a comprehensive budgeting and forecasting tool. The tool will need to accommodate: - Expense & Revenue tracking - Expense & Revenue forecasting using drivers The data will be manually entered, so the interface needs to be user-friendly, with clear instructions for inputting data. The ideal candidate will have: - Extensive experience with Excel, particularly with creating complex spreadsheets for budgeting and forecasting - A strong understanding of budgeting and planning - Proficiency in creating and implementing Excel macros The end goal is a robust, easy-to-use Excel file that will help me keep track of my finances and forecast future expenses and revenues.
I need assistance with my Microsoft Excel spreadsheets to delete duplicate rows without moving any data. The duplicates are identical rows. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience with data cleaning and management - Attention to detail to ensure all duplicates are removed accurately and efficiently.
...in need of an Excel expert to transform a spreadsheet into a comprehensive inventory system. The system should be capable of receiving and logging orders, generating invoices, and providing a form for data entry. Additionally, there should be a way to attach drawings to the relevant items. Key Requirements: - Order tracking and logging - job scheduling - Invoice generation - Form for entering details - Capability to attach files as objects in Excel The system needs to accommodate more than 200 different types of inventory items. Ideal Skills: - Advanced Excel proficiency - Experience with inventory management systems - Familiarity with invoice generation in Excel - Ability to create user-friendly data entry forms Please bid only if you have extensive ex...
I need a skilled Python programmer to help me automa...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 if you can provide result with my budget, Not your Expectation Budget:Rs 1050 I will give good review, if you complete my budget, Dont expect more money If you have experiece in trade automation, You...
Attached file that need updating, this sheet will be used on a monthly basis to value works completed and invoiced, the user is not very good with spreadsheets and is unable to track changes etc. What I am looking for is an easy way in which each time they open the sheet they can simply enter the percent complete in column D and columns E,F and G are updated accordingly. Need some wise logic to track rolling-over of valuations with the additions of newer percentages. Also need a provision to save the file as PDF.
i am having an excel script which is used to send whatsapp messages , some bug is there through which its not letting through properly , full message is not going NEED AN EXPERT ONLY , lets not waste anyone's time please ***urgent Language : VISUAL BASIC in EXCEL
I'm seeking a skilled data analyst who can help with comparing Excel sheets, data cleansing, and performing descriptive statistical analysis on the data. Key tasks: - Identify differences between multiple Excel sheets - Cleanse and standardize data - this includes removing duplicates, handling missing values, and standardizing formats - Conduct descriptive statistics to provide insights from the data Ideal skills and experience: - Proficient in Excel with strong attention to detail - Experienced in data cleansing and comparison - Skilled in performing and interpreting descriptive statistics - Able to deliver clear and concise reports of findings
I'm in need of a meticulous and dedicated freelancer to assist with manual data entry from scanned documents into Excel spreadsheets. Key Requirements: - Strong attention to detail and accuracy - Proficient in using Excel - Able to handle manual data entry tasks - Comfortable working with scanned documents Ideal Skills: - Data Entry - Excel proficiency - Attention to detail - Ability to work independently and meet deadlines
I'm seeking a professional with extensive experience in MS Access to assist me in creating a robust database. Ideal Skills: - Proficiency in MS Access - Experience in database design and creation - Strong understanding with data analysis, query building This is an urgent task, please bid if you are available to support immediately. Communication in English is must.
Project Requirement: Line Recorder with Bluetooth Objective: Develop a compact Line Recorder device with Bluetooth connectivity that connects to a mobile app for controlling and managing call recordings. Key Features 1. 3.5mm Audio Connectivity: * Input Port (IN): Connects to the phone via a 3.5mm TRRS cable (e.g., Type-C to 3.5mm adapter). * Output Port (OUT): Connects to headphones with a microphone. * Ensure passthrough audio for both the microphone and headphone. 2. Bluetooth App Integration: * Establish a Bluetooth connection with a mobile app. * Mobile app controls: * Start/Stop Recording: Signal the device to begin or stop recording. * Download Recordings: Retrieve the recorded audio file via Bluetooth. * Clear Storage: Aut...
...skilled Python developer or Embedded Developer to create a solution for capturing data from Vector energy meters using the DLMS protocol via optical port and RS232. The meters in scope include brands like Secure, L&T, and Genus. The ideal candidate will have a strong understanding of communication protocols and experience with data extraction techniques. This is an exciting opportunity to work on a project that enhances energy data management. Please provide your relevant experience and examples of similar projects in your application. **Relevant Skills:** - Python Programming - DLMS Protocol - Data Capture Techniques - RS232 Communication - Optical Port Interface - Experience with Energy Meters Following Energy Meters Model present: SECURE:- E3M025, P3E, T4xxxxC5 L...
I'm looking for a skilled Excel professional to assist with merging data from various Excel sheets. Key Responsibilities: - Merging data from multiple Excel sheets into a cohesive, organized format - Ensuring specific columns or headers are accurately matched during the merging process Ideal Skills: - Advanced knowledge and experience with Excel - Strong attention to detail - Ability to follow specific instructions accurately Experience in working with amenity-based pricing data is a plus. Please provide examples of similar projects you've completed in your proposal.
I'm seeking a proficient app developer to create a comprehensive, interactive learning platform for nursing students. This app will be designed for both iOS and Android, featuring: - Interactive Course Modules: Covering crucial nursing topics like anatomy and pha...and pharmacology. - Quizzes and Practice Exams: To aid in preparation for professional certifications such as the NCLEX. - Interactive Flashcards: For quick revisions and reinforcing learning. - User Login: Ensuring personalized experience and progress tracking. The aim is to deliver a user-friendly, interactive, and education-focused app that simplifies nursing studies and empowers students to excel. If you have a knack for interactive app design and a specialization in education-oriented solutions, we would love ...
I have a well-developed Kaizen Tracker in Excel that needs some updates. Specifically, I would like to add or update some bar charts and pie charts, rearrange some data columns related to current performance metrics, and improve the presentation of existing graphics. **Do not reply just to reply. Read the skills first** Ideal Skills: - Proficiency in Excel - both programming and user interface - Experience with data visualization - Understanding of performance tracking - Knowledge of Kaizen methodology - Looking for someone to collaborate with together Please submit your bid if you have the necessary skills and experience.
I need assistance resolving two JavaScript bugs in an existing HTML/CSS/JS project designed for an Nginx localhost (Port-ID 44999). Key details are provided in a separate PDF file. The project should integrate seamlessly with WebStorm IDE and the existing setup. Scope of Work: Bug 1: Mousemove Event Listener Issue Context: The issue occurs in at line 330, where a mousemove event is not triggering as expected. Debugging attempts (e.g., added () statements) have failed to identify the cause. The relevant function (drawOverlay) is never executed. Goal: Resolve the issue to ensure the event listener works as intended. Bug 2: Misaligned Popup Window Context: Clicking on an orange overlay (triggered by mousemove) creates a draggable in-page popup. However,
I'm seeking help with adjusting column widths in Excel to fit text without wrapping. Ideal candidates should have strong Excel skills, particularly in formatting, and be able to deliver a clear and organized spreadsheet.
I need an Excel expert to help me lock an Excel file to restrict any one to bypass my macro password. - The task involves securing an entire workbook with a combination of a strong password and digital signatures. - Ideal candidates should have extensive experience with Excel's security features and macros. - Knowledge of creating and applying digital signatures is crucial. - The goal is to ensure that only authorized individuals can access the macro, while keeping the rest of the workbook secure. sample files attached
I'm looking for a skilled web developer to build a website that can convert various document types. Key Features: - Conversion from PDF to Word, Word to PDF, and Excel to PDF. - A user-friendly interface that allows seamless file uploads and downloads. Additional Skills: - Experience in building conversion tools is a plus. - Strong understanding of web security for user data protection. - Ability to create a responsive design that works on both desktop and mobile. Please note, this project does not require user authentication, progress tracking for conversions, or email notifications for completed conversions. I look forward to seeing your proposals.
I am using Windows 10 and Microsoft office 10 Pro. plus excel version 14.0.7268 32 bit I have one line in Excel that is occassionally repeated. When I execute the macro it should: put 20.25 in column B put 59.70 in column F put 6.95 in column G put 5.21 in column H put 4.31 in column K the numbers stay the same, but when I run the macro i created it always puts the numbers in the same row I created the macro in. I want to macro to run on the line the cursor is in. so if my cursor is at A17, and execute the macro, the numbers should go on row 17.
Need assistance checking my work, formulas, on this spreadsheet for accuracy. Mainly Row's 17 thru 20. This is a cost analysis comparison. I want to ensure the $12.50 + 1 basis point + 3 cents accurately equate to the total in row 20. These mention rows are the cost of doing business relative to the 'Card Volume' and 'Transactions' listed in Row's 5 and 6.
This is at the bottom of priority list I need this report summarized into 6 or so pages As always please recreate the charts and embed Once completed please upload backup excel files You know the drill
I'm seeking a professional who specializes in Excel and PowerPoint to link the content of my financial dashboard across two Excel tabs to my PowerPoint slides. This will ensure any updates are synced in real-time. Ideal Candidate: - Excel and PowerPoint expert - Financially savvy - Experienced in creating professional presentations Please note: This project does not require marketing or branding expertise. The focus is strictly on financial data and presentation.
I am in need of a freelancer who can install a new Zen Cart version for my existing online store, JayRacing,com, presently using: v1.5.4. The store is selling physical products and requires the following functionalities: - Multiple payment gateways (Paypal & Paypal PayFlow Pro) - Shipping and tracking integration (UPS & USPS) - Customer reviews section Additionally, I would like to keep my customized design/look for the Zen Cart store, backup the existing information, and delete any older version still on the server. Freelancers with a strong portfolio in Zen Cart installations and custom e-commerce designs are preferred. Please provide examples of your previous work with Zen Cart.
I need assistance with my Excel line chart. I've been trying to change the maximum bounds on the format axis, but I can't seem to do it. Ideal skills for this job: - Proficiency in Excel - Experience with creating and modifying line charts - Understanding of numerical data handling in Excel
I need an Excel macro developed that can extract digital signatures from multiple PDF files and record them in an Excel file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the signer’s name and the time and date of the signature - The data should be organized in Excel with one row per document, and all signatures from that document in separate columns. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Experience with PDF data extraction - Strong attention to detail to ensure accurate data capture
I need a skilled Python programmer to help me automat...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 if you can provide result with my budget, Not your Expectation Budget:Rs 1050 I will give good review, if you complete my budget, Dont expect for money If you have experiece in trade automation, You...