Useful vba codes for excel işler
...launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some l...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
...structures for residential, commercial, and bridge projects. - Collaborate with architects and engineers to ensure designs meet standards and client requirements. - Prepare technical drawings, specifications, and reports using AutoCAD for steel structures, trusses, and Pre-Engineered Buildings (PEB). - Provide support to construction teams during implementation, ensuring structural integrity and safety. - Stay updated on industry trends, codes, and regulations related to residential, commercial, and bridge design, as well as steel structures, trusses, and PEB. *Qualifications:* - Bachelor's/Master's degree in Civil Engineering or related field. - 1-2 years of experience in structural design, with a focus on residential, commercial, and bridge projects. - P...
...structures for residential, commercial, and bridge projects. - Collaborate with architects and engineers to ensure designs meet standards and client requirements. - Prepare technical drawings, specifications, and reports using AutoCAD for steel structures, trusses, and Pre-Engineered Buildings (PEB). - Provide support to construction teams during implementation, ensuring structural integrity and safety. - Stay updated on industry trends, codes, and regulations related to residential, commercial, and bridge design, as well as steel structures, trusses, and PEB. *Qualifications:* - Bachelor's/Master's degree in Civil Engineering or related field. - 1-2 years of experience in structural design, with a focus on residential, commercial, and bridge projects. - P...
I'm in need of a skilled AI developer to assist with analysis of patient data in the healthcare industry. You'll be addressing the conversion of ICD 10 to CPT codes, developing a system that will make this process more efficient and accurate. Key tasks will involve: - Building a diagnosis prediction model - Implementing billing code translation - Analyzing patient data Necessary Skills: - Proficiency in Python - Extensive experience in AI development, particularly in data analysis - Experience with Google AI framework Experience in healthcare IT would be a bonus, particularly knowledge of ICD 10 and CPT codes. If this sounds like a project where you could make a significant impact, please submit your bid.
I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments
Objectives: To develop a model that predicts housing prices based on various features such as location, size, amenities, etc. Data Set Link: Kaggle: House Prices - Advanced Regression Techniques () Analysis Tools/Programming Language: Python, Pandas, Scikit-learn Final Outcome...accurately estimates housing prices. follow a step-by-step process to create ML models predicting housing prices, create heatmaps of different features to find the most correlated feature and apply several ML models on the dataset, make an evaluation metric comparing the different models based on precision, accuracy, R2 score, etc. and present the result in easy to understand ways. send me all the codes so that it can be replicated on my device
Looking for an experienced Excel professional who can help debug my university project. I'm currently grappling with project-related issues and need rapid assistance. Expectations include: - Rectifying the project - Delicate understanding of Excel debugging - Fast turnaround time - as soon as possible Ideal candidate should have prior experience with Excel debugging, problem-solving ability, and methodology to correct projects. Knowledge about appropriate data structures will be appreciated. Being a student's project, confidentiality will be highly appreciated.
I'm in ...quantity, and pricing. - **Customer Management:** The system should enable me to manage my customer base. This includes keeping records of customer orders, contact information, and any other useful data. - **Profit and Loss:** The application should provide insights into my business performance by calculating profits and losses based on inventory, sales, and other financial data. - **Accounts:** I expect it to have the capability to create, manage and generate various financial reports related to the transactions and accounts. Ideally, the system should be well structured, user-friendly, and secure. I'm looking for a freelancer with experience in Core PHP development, particularly in e-commerce and inventory management systems. Prior experience with simil...
...looking for a skilled Python developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to data consolidation if possible. ...
...to understand for the reader. There are a total of X photos that would need to be converted. - **Translation**: I also require the document to be translated into Russian. The translation should be done at an intermediate level of detail. This means that the translation should accurately capture the content and tone of the original document. - **Formatting**: The document should be formatted in a standard business format. This means that the layout, fonts, and styles should be consistent and professional throughout the document. I am looking for a freelancer who has: - Proficiency in Word and Excel - Translation experience, preferable with a business background - Strong attention to detail - Excellent communication skills Please provide a quote and an estimated...
...streamline our insurance quoting processes as our current method is manual. Key Features: - Quote Comparison: An element that allows for easy comparison of different quotes for the customer's selected coverage. Access: I am open to ideas for the program's accessibility. It could be a web-based platform, a desktop application, or even an Excel program. The primary goal is to transition from manual quoting to a more efficient, digital process. Ideal Freelancer: - Experience: A strong background in insurance software development and a proven track record in creating similar programs. - Innovative: Capable of suggesting and implementing creative solutions for an optimal quoting experience. - Detail-Oriented: Attentive to accuracy and thoroug...
I am in need of a licensed Georgia engineer to provide a structural engineering letter. The objective of this letter is to help me obtain a building permit. Key Information Needed: - Compliance with Local Building Codes: The engineer needs to confirm that my mobile home meets all the necessary local building codes. Existing Documentation: I have some documentation available for the mobile home, however, it is partial and somewhat outdated. It would be great if the engineer could work with this documentation, filling in any gaps and updating it as necessary. I would like to work with a professional who has experience in Georgia's building regulations and who can provide this letter in a timely manner.
Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I have a very simple web page that has a scrollable table with data. I can't copy and paste the data as a whole into excel, it's requiring that I copy each entry one by one. I'm looking for someone that can help design a simple program to automatically save all data as a csv file. Thanks
...comprehensive fire risk assessment for my residential property. Key Requirements: - The property is within the size range of 1-50 units, so the assessment should be tailored to this scale. - I'm primarily concerned with the efficiency and reliability of the current fire detection and alarm systems in place. - In addition, I would also like a thorough evaluation of the emergency exit routes, aiming to ensure they are clear and easily accessible in the event of an emergency. Ideal Skills: - Prior experience in conducting fire risk assessments, particularly within residential settings. - Familiarity with building codes and safety regulations, especially those related to fire safety. - Strong attention to detail and the ability to provide clear, actionable recommendati...
I need a data entry operator proficient with spreadsheet data entry. The work involves keying in data from scanned PDF documents into a spreadsheet. Key Requirements: - Proficiency in spreadsheet data entry - Comfortable working with PDF documents Ideal Skills: - Experience in data ent...with spreadsheet data entry. The work involves keying in data from scanned PDF documents into a spreadsheet. Key Requirements: - Proficiency in spreadsheet data entry - Comfortable working with PDF documents Ideal Skills: - Experience in data entry - Proficiency in spreadsheet software, particularly Excel The scanned documents will be provided to you in PDF format. I will provide clear guidelines on formatting and data entry requirements. The accuracy and efficiency in data entry is crucial ...
...have an SMS Gateway developed for delivering OTP messages through a web interface. Short codes will need to be delivered through web panel to customers. Text message delivery for multiple services used in accounts creation like facebook, instagram, gmail, whatsapp and other services.. This means we will be using physical sim cards, NOT virtual numbers. Web backend will need to communicate with physical hardware: (Moden huawei e303, 3131 FOR EXAMPLE) The system has to be the same as sms-activate, sms hub, sms pva, please if you have this experience I am searching for coders experienced is USSD/AT commands. Heavy experience with GSM/CDMA cellular networks and sms gateway integration. Look at the websites I've posted above, put together a compatib...
...graphic designer to create a dynamic and visually engaging financial tracking template for personal use. The template should be modern, user-friendly, and adaptable to digital formats. It must also be vibrant and colorful, reflecting a lively and motivating approach to managing finances. Requirements: Expense Tracking: The template should allow for detailed tracking of expenses, with sub-categories under main expense headings to ensure thorough documentation. Income Tracking: As my income comes from various streams, the income tracking component should be equally detailed, allowing for precise monitoring and categorization of multiple income sources. Financial Goal Setting: There should be a dedicated section for setting and monitoring financial goals, whi...
A partir del listado de empresas adjunto, necesito encontrarlas en el buscador de empresas Empresite () e incorporar a una tabla el propio enlace de Empresite y los datos que ofrece de (1) tipo de actividad, (2) rango de volumen de facturacion, (3) numero de empleados, y (4) pagina web.
Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.
I'm looking for an experienced individual who can perform research and registrations for my Company in various state procurement sites across the USA such as Alabama, California, Florida, and more. Your tasks include: - Understanding and following written instructions accurately - Executing company registrations as a vendor or supplier - Managing all necessary paperwork and forms during the registration process - Someone who can apply logic, and research NAICS or commodity codes that represent what Our company has to offer. As we are in the Debt/Recovery Data Services sector. Attention to detail, organisational skills, and the ability to diligence navigate state-specific procurement processes are vital. I'm eager to partner with someone who can remov...
I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity w...
...aren't limited to: - Recruitment: Utilizing job portals, social media, and recruitment agencies to attract quality talent. - Employee Onboarding: Orchestrating a smooth transition for new hires into our organization, ensuring all formalities are completed and they're effectively integrated into their teams. - Performance Evaluations: Must be capable of conducting fair and thorough assessments of employee performance, ensuring that all evaluations are both accurate and constructive. Given that we are an organization composed of 50-100 employees, experience handling HR needs of similar scale is most appreciated. To excel in this project, considerable knowledge and experience in recruitment, employee onboarding, and performance evaluations is paramount. Practica...
I need a skilled data analyst to work on a large dataset in Excel. Key Responsibilities: - Sorting and filtering data: The dataset contains over 10,000 rows, so the analyst must be adept at handling large data sets. - Creating pivot tables: Organizing data is a key step in our data cleaning process. - Performing Statistical Analysis: Appropriate statistical analysis will be crucial for accurate data cleaning and preparation. Ideal Skillset: - Proficiency in Excel: The freelancer must have extensive experience working with advanced Excel features and handling large datasets. - Data Analysis Skills: The individual should be well-versed in data analysis techniques, including statistical analysis and data preparation. - Attention to Detail: As the primary goal is...
I'm in urgent need of a skilled Excel expert to unmerge text cells in my spreadsheet. Here's what I need: - Unmerge text cells - Format the data as requested - Complete the task ASAP The ideal freelancer for this job should have: - Proven experience in Excel - Strong attention to detail - Ability to work quickly and efficiently Please submit your proposal if you can get this done right away.
Hi Ahmed I can pay you here for that work on the 2 small excel projects
I'm in need of a detailed set of house plans for a large, two-story property. The plans should include: - Floor Plans: The layout of the property, showing all rooms, dimensions, and features. - Elevation Drawings: A visual representation of the property from all sides, illustrating the exterior design and materials. - Construction Details: Technical drawings that show how the property should be constructed, including materials, structural elements, and any necessary details for contractors. The ideal candidate for this project should have experience in: - Architecture and house plan design - Proficiency in CAD software or similar - Understanding of construction principles and building codes Please provide examples of previous work in a simil...
I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong ...
...document to be converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understan...
I need a PHP script to generate QR codes ASAP. The script should be able to customize the QR codes with colors and logos, and further, with rounded eyes and data. A sample will be provided. Preferred solution using chillerlan/qr-code ... but other solutions might be used as well. Key Features: - The primary function of the script is to generate QR codes. - I need the option to customize the QR codes with colors and logos. - Additionally, I require the ability to customize the QR codes with rounded eyes and data. File Formats: - The generated QR codes should be exportable in PNG and SVG file formats. Timeframe: - This should just take a few hours. Ideal Skills and Experience: - Expertise in PHP and QR code generation.
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm
I am seeking a proficient CBP Entry Data Specialist for a part-time position of approximately 10-20 hours per week. The suitable candidate should efficiently perform tasks including: - Accurate Data Entry - Rigorous Record Keeping - Document Verification The role will require expertise in using tools such as Microsoft Excel and specialized Data Entry Software for smoother execution. Prior familiarity with the Customs and Border Protection database will be a significant advantage, although it's not a mandatory requirement. Excellent attention to detail, accuracy, and organizational skills would make you an ideal candidate for this role.
I'm looking for a meticulous freelancer to help with entering text data into an Excel sheet. My project entails copying texts verbatim from multiple online sources, there's no need for any sort of editing. Here's what you should bring to the project: - Proven experience in data entry - Proficiency in Excel - Ability to handle large volumes of text data - Strong attention to detail to ensure accuracy - Ability to work independently and adhere to deadlines Prior experience with copying data from online sources will be a major plus. Let's put your data entry skills to work in this project!
...the largest media about affiliate marketing and online moneymaking in the CIS. Our audience earns money online from affiliate marketing, website creation, YouTube, and other sources. We are looking for a Twitter content author who can rewrite our articles from the website into threads that will be useful to our audience. So, you just need to take the article from our website and rewrite it in a thread. In the beginning, we need to create 15 threads per month. Then, the number of threads will increase. The payment is set by ONE thread. Responsibilities: - Find articles on our website for threads; - Take the article from our website and create a thread according to this article. Requirements: - Strong logical thinking and creativity; - Understanding of...
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactiv...
I'm looking for a seasoned Project Designer with a strong understanding of options to conduct an intensive research. Expertise working on softwares, call center, robocaller and conversational AI outbound calls for call center. The ideal candidate should have a proven track record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready ...
I'm looking for skilled developers to create an innovative app straight from the ground up. The application would ideally be functional on iOS, Android, and PC platforms. It must be able to perform key operational tasks including: - Printing documents - Processing card payments - Scanning QR codes Though the brands or models for the printer and card payment terminal that the app will connect with are not yet defined, the application should have the capacity to configure with a wide range of devices. I would prefer if you have past experience in developing apps that perform similar functionalities. Knowledge in payment gateway integration and QR code technology will be a big plus. This project requires a technically proficient, dedicated, and innovative individua...
In need of a meticulous freelancer to undertake a copy-pasting project. Your primary task will be to copy-paste text content into an Excel spreadsheet. Key Responsibilities: - Accurately copy text content. - Efficiently paste the content into a structured Excel database. Ideal Skills: - Proficiency in working with Excel. - Strong attention to detail for error-free work. - Ability to maintain structured and organized data. - Prior experience with copy-pasting tasks a plus. Your effort will be critical in maintaining an accurate and reliable database. I am looking forward to seeing your applications and working with you on this project.
I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipu...
I'm seeking a developer to set up a finance API on my Wo...developer to set up a finance API on my WordPress checkout page. I have the authentication info, 2 GET and 2 POST codes for you to copy and implement This is aimed at providing real-time financial information to my customers from a companies API. I have the API Documentation provided by them for you to work from. The ideal candidate for this project should have: - Extensive experience in WordPress development - A deep understanding and practical knowledge of finance APIs - A keen eye for detail to ensure accurate information display - Excellent problem-solving skills to troubleshoot any potential issues This project's key objective is for my customers to view and see the op...
I need an expert in web scraping, specifically in Python, to extract text data from a particular website. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
I'm looking for a skilled designer with experience in creating Material Design styled icons consistent with those at This project focuses on the development of distinctive representations of geological tools. Key deliverables: - Icons representing various geological tools, specifically: - Wind Rose Diagram - Bore Log - Water Strike - Groundwater Level - Lithology - Field Data Collection - Data Import - Data Export - Data Exchange - Modifications of existing logos to icons to use to indicate integration within the App. Excel (for an Excel export) GWSDat ProUCL AGS
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I NEED THIS ANALYSIS TO BE MADE IN MAXIMUM 4 HOURS. IT NEEDS TO FOLLOW THE SAME ( OR VERY SIMILAR) STYLE OF THE LINK BELOW... : - Generate a report based on selected financial ratios; specifically, liquidity, profitability, and solvency ratios. - Assess and include the following liquidity ratios in the report: current ratio, quick ratio, and cash ratio. - Evaluate and incorporate these profitability ratios: gross profit margin, net profit margin and return on assets. Ideal candidate: - A proficient user of Excel. - Strong mathematical and analytical reasoning abilities. - A deep understanding of financial statements and financial ratios. - Ability to deliver under a tight schedule. Looking forward to your prompt bids. Thanks!
I'm looking for someone to build a basic Shopify app that will eventually be integrated with an API that we're developing (may need hep on this, but it's a separate project). We'll need the freelancers to ultimately sign an NDA and IP agreement. There are several important elements we need built, though we are not yet fixed on a development stack. Basically we need functionality such as shopping cart management, order modifications, returns and exchanges, product information, FAQs, store policies, discounts, and upselling/cross-selling capabilities. Probably most or all is in some github repository, which we are fine with using as well as GPT-4, which, if you don't have an account, we'll get you one. It is important to only use MIT or similarly license...
