Vba exel project jobs
I'm in need of a seasoned VB expert, particularly skilled in Visual Basic for Applications (VBA). The primary task involves helping me automate repetitive tasks in Excel. Ideal Skills and Experience: - Advanced expertise in VBA - Proficiency in Excel - Prior experience in task automation - Strong problem-solving skills - Attention to detail
I need help with using Python or VBA to split my sales data in Excel into multiple sheets. The specific categorization is yet to be decided, so flexibility and input on your part would be appreciated. Key Requirements: - Proficient in Python and VBA - Extensive experience with Excel - Able to provide input on data categorization - Understands how to automate data handling While I haven't specified tasks for each sheet yet, I foresee needing assistance with data analysis, data visualization, and generating reports. Previous experience with these tasks will be beneficial. Budget $30
I'm in need of a VBA program that computes the Ascendant degrees based on coordinates from Mumbai, India. Key Requirements: - The program should be able to run on its own - Manual entry will be the sole input method for the coordinates. - Users will need to manually input the Date and Time of Birth; the program will calculate the Ascendant degrees based on this information. Ideal Skills: - Proficient in VBA coding. - Experience with developing Excel-based applications. - Understanding of astrology concepts, particularly Ascendant degrees. The goal is to have an easy-to-use program that will assist in astrological calculations.
I need an experienced Excel VBA programmer to write a macro for me. - Data Extraction: The macro should be able to extract order details from an Excel spreadsheet and format them into mailing labels. - The macro will need to pickup orders with specific SKU - Label Formatting: The labels need to be formatted for a single column continuous layout. Ideal skills for this project include a deep understanding of Excel and VBA programming, experience with data extraction and label formatting, and a keen eye for detail to ensure the accuracy of the labels. Please provide previous examples of similar projects in your bid.
I have two quite complex Word questionnaires distributed to over 100 respondents. Responses come back over email in .docx format. I need assistance in compiling these responses into a single Excel...respondents. Responses come back over email in .docx format. I need assistance in compiling these responses into a single Excel file, ideally through an automated (non-manual) process, with each respondent in a separate row and each question in a separate column. Ideal Skills and Experience: - Proficiency in Microsoft Excel and VBA - Experience in data compilation and analysis - Attention to detail - Strong understanding of .docx and Excel/VBA compatibility Please note: The project involves working with a potentially high volume of data, and requires a quick turnaround ti...
I'm looking for a professional who can create a complex dynamic block for me, incorporating elements of data manipulation, user interface enhancements, and automated calculations. This dynamic block will need to be updated by a table, and be fully functional with Lisp. Key requirements: - Proficiency in Lisp, C#, and VBA is essential. - Experience with creating intricate dynamic blocks. - Ability to enhance user interface and automate complex calculations. This project is primarily focused on architectural design, so familiarity with this field is a plus. Please provide examples of similar past projects in your proposal.
VBA Code for Excel Create a new sheet next to the current sheet named on the value in sheet “Quote” cell H5 Copy the entire sheet “Quote” to the newly create sheet, paste as values (not formula) Copy the format from Quotes to the new sheet. From sheet called “Quote #” delete row 1 and move all values in column A up so that the value previously in A2 is now in A1 Return to “Quote” sheet cell C6
I'm in need of a VBA expert who can write a code for me. The code should allow me to save embedded PDF file from my Excel workbook to my disk. Ideal skills and experience: - Proficient in VBA programming, specifically for Excel - Familiarity with handling embedded files in Excel.
Hi there! I'm looking for a skilled Excel professional with expertise in Macros, Scraping and VBA. I will share you more details in via chat box. Thanks
I have an excel workbook that I use to collect product data. I have set up filters with predefined answers to questions, and I would like to be able to add more than one answer from the list in the same cell. Screenshot1 show my list of predefined answers and in screenshot2 I have highlighted 8 columns which contain fields that can have more than one answer in the same cell. So for...Screenshot1 show my list of predefined answers and in screenshot2 I have highlighted 8 columns which contain fields that can have more than one answer in the same cell. So for example Product A has ethical filter choices of: Vegan, Certified Organic, Plastic-Free. I need a simple way to select all these answers from the drop down list and populate them in cell C2. Ideal Skills: - Proficient in Excel ...
I'm in need of an Excel-based dashboard to streamline the m...Features: - Comprehensive Patient Info: The dashboard should accommodate patient contact details, insurance information, billing codes, eyeglass order info, and invoices. - PDF Management: There should be a functionality for uploading and managing PDFs related to each patient. - Billing Integration: A crucial aspect of this project is the integration of insurance claims management into the billing and accounting page. Ideal Skills: - Proficiency in Excel (advanced functions, VBA, etc.) - Experience in developing dashboards or management systems - Understanding of patient management and billing processes in healthcare I've attached a loose template I found that isnt exactly what i want, but close I look...
...an Add-In using VBA which may be installed by any user and on any workbook. The workbooks CANNOT be saved as XLSM format, so we are not loooking for Macros, but an Add-In. - The Excel Add-In should have a button to START the sync and a button to STOP the sync. - The Excel Add-In should work only within the Excel Workbook in which the user has clicked START. - The Excel Add-In should be allowed to run on multiple Workbooks (with same structure). - The Excel Add-In should be backward compatible with older versions of Excel. - The Excel Add-In should be efficient and light-weight and not slow down the excel instance in any circumstance. We have attached the two excel spreadsheets in which this Add-In would be used. The developer will need to have excellent skills in Excel VBA...
I am a beginner in the field of writing research and review papers, particularly in the Mechanical and Medical fields. I am looking for an expert who can provide me with a personalized training program and hands-on practice to enhance my skills. my skills : Knowledge in word, excel vba, python. I did masters in Mechanical currently working as lecturer. Key Requirements: - Python, numpy etc knowledge is must and paper should be based on these tools. - He should train me in live with practice (Have to chose one topic and how to write, use different tools, how to search, etc) - Training should be till the completion of the paper.(as many days it may take). - The training should be tailored towards the Mechanical and Medical fields. - Specific focus on Medical devices, Microfluidic dev...
I'm in need of site plans for a large metal shed build. These plans must be signed and approved for use in Victoria, Australia by a VBA registered architect or draftsperson. Key Requirements: - The shed dimensions exceed 25 sqm. - Plans must be compliant with local building regulations. - Plans must be signed by a VBA registered professional. Ideal Skills: - Architecture or Drafting - Familiarity with Victorian building codes - Experience with large metal structures The structure is a pre engineered steel building and all elevations will be provided.
Requirement Document 1. To do the automation – preferably using only power automate and/or power query. Don’t have premium version of power automate. VBA also discouraged but can be used if absolutely necessary. Not python. 2. The objective of the project is more for me to learn rather than the project itself. At least to the point where I can modify the code parametes to suit my purpose. Important to have a virtual session where you teach me and I replicate the process on shared screen. This needs to happen on either 24th or 25th of Aug. Need of process: To send out part of master table to different people. These people add data in a blank column. This input is added to master table. Detail Process Steps: 1. I have a master table. It has vendor name to ...
Brief Description Program Software: Visual Basic for Application (VBA) • Fully automated and dynamic Form • Printable Employee Violation Form • 4 Editable Boxes: 1. Employee ID 2. Violation Category (A, B, C) & Type (VA#, VB#, VC#) 3. Repetition (Repeated Offense) 4. Validity of Violation 6 Months • Design with one interface and Login for 2 Users only 1. Super User (Fill, View & Print) 2. Manager (Open Data) How long does it take to complete this project? Prize range: $70 to $120 Attached Full Description
We need a bunch of updates to consolidate files on sharepoint based on set logic. Also need to update dropdowns to source from an external VLOOKUP file. Also need to add new columns to files but not all files, but the logic need to work consistently.
I'm working with Excel 2019 and need a macro code developed to enhance the security around my data. The main idea is to generate a one...Requirements: - Develop a macro code that can generate dynamic OTPs - Integrate this code with the Excel 2019 program - Implement the OTP delivery via SMS - Ensure the OTP is the only way to access the data Ideal Skills: - Proficiency in Excel VBA coding - Experience in integrating external services with Excel (in this case, SMS) - Understanding of data security and access controls - Ability to create a seamless user experience with the OTP system The project is centered around data security and automation; I'm looking for a skilled freelancer who can bring this project to life. Please include any relevant experience or ...
I need a task completion tracking checklist created in both Word and Excel. The checklist should have multi-option checkboxes and include a weighted average for each question. The final output should indicate whether "more engagement is needed" or not. Ke...Each response, respondant will have to click a check box than have an excel sheet sort of drop down 4. Each qs will have a weighted grade 5. Once all questions are answered and graded, respondant and everyone will see if further evaluation is needed or engagement with other group. I will give those average. Need someone good in creating templatea checklist, macros, excel sheet formulization and VBA Your proposal should clearly demonstrate your relevant skills and experience. Please include examples of similar projec...
I'm looking for a skilled developer to create a Word document linked to populated Access tables. The project involves inserting data via bookmarks and VBA into a fresh output Word document. This output document should have no remnants of bookmarks or VBA and must maintain the required table and text formatting. Key Requirements: - Working with Mixed Data: The Access tables contain a mix of text and numerical data. - Advanced Formatting: The output Word document needs to be formatted with custom styles and complex tables. - Internal Report Creation: The primary purpose of the output Word document is to serve as a report for internal use. Ideal Skills and Experience: - Proficient in VBA programming - Experienced in linking Access tables to Word documents -...
I need an experienced Excel and VBA professional to create an Excel Addin named 'Design Blank Menu'. This Addin should enhance the user interface of Excel by adding Design Sheets to the Excel Menu Bar. Key Requirements: - Expertise in Excel and VBA - Experience in developing Excel Addins - Ability to improve user interface of Excel The Addin should also automate tasks by integrating design sheets into the menu, making it easier for users to access these tools. Ideal Skills and Experience: - Strong knowledge of Excel functionalities - Proficient in VBA programming - Previous experience in Excel Addin development - Excellent understanding of user interface design principles.
I need an experienced VBA developer to create a script that can store and retrieve username and password from Windows Credential Manager within Excel. Key Points: - The script should be written in VBA as 2 functions The code is freely found in chat gbt but i lacked knowledge in declarations to resolve syntax errors. It will be 1-2 hours for a good vba used to working with dlls
I need a Microsoft Excel expert with advanced VBA/Macro skills. The primary goal of this project is to automate complex data manipulation and analysis tasks within the Excel platform. Key requirements include: - Experience in creating macros to automate repetitive tasks in Excel. - Proficiency in handling complex data sets and manipulating them effectively. - Expertise in data analysis and interpretation within Excel. I'm looking for a professional who can streamline and optimize these processes through VBA/Macro development. Experience in creating efficient and reliable solutions for complex Excel tasks is crucial.
I need an Excel macro vba created to calculate stock trade stamp. The calculated results should be displayed in an existing sheet within specific cells. sorting, data structure, such as dictionary knowledge is required
...direct access to SAP on our mining maintenance site. Our current process involves paper notifications, which are manually uploaded to SAP by another party. This project aims to automate and simplify this process. **Core Requirements:** - The Excel template must allow for the entry of specific data fields necessary for defect notifications in SAP PM. - Notification long text - Functional location - Planner group - Main work center **Key Deliverables:** - A user-friendly Excel template. - A system or method within the template that will automatically upload entered data to SAP. **Skills and Expertise:** - Proficiency in Excel and VBA for automation. - Experience with SAP PM and understanding of its data structure. - Knowledge of how to integrate Excel with SAP sys...
I'm looking for a proficient data analyst and Excel expert who can help me track real-time data from various markets into an Excel sheet. Key Requirements: - Data should include prices, volumes, and timestamps of each highs and lows. - Markets of interest: Stock market, Commodities market, and Forex market. - Specific stock...Features: - Excel sheet should update in the background as the market session progresses, even if the Excel file is closed. Ideal Skills: - Proficient in Excel with advanced data tracking skills. - Experience in financial market data analysis. - Knowledge of NSE and MCX operations. - Ability to set up background updates in Excel. - VBA, Python programming skills, API Integration, cloud interfacing skills needed Please let me know if you can assist wit...
I am searching for an experienced VBA coder to help in automating the task of assigning shifts in our duty roster, which we manage on Microsoft Excel. I have tried formulating the code with the assistance of ChatGPT but encountered some errors. It is not complicated work and people experienced in VBA code should be able to finish in a few hours. The VBA code should facilitate the following duties: 1. Assignment of Staff to Shifts: The main functionality will be to automate the appointment of workers to their respective shifts. 2. Constraints for Shift Assignment: There are some specific conditions to consider when assigning personnel to shifts. These include: - Ensuring there's a minimum rest period between shifts. - Avoiding scheduling a worker for t...
Need a person help me to create the report on excel (Macros and VBA)
I'm looking for someone who can create a small Microsoft Excel pivot table for me. The main goal of the pivot table is to summarize my financial data. It would be great if you could help me fix any issues with the data too. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience with vba and Micros - Ability to troubleshoot and fix issues.
I require an experienced Excel VBA and macros developer to improve our existing feedback interface. I need to expand its functionality in collecting, displaying, and analyzing feedback. Key Requirements: - Enhance the feedback collection process. Implement a user-friendly data entry form to simplify the input process. - Automate the feedback input. This should be done in a way that is efficient, accurate, and user-friendly. - Implement improved feedback display. The interface should present data in a clear and accessible manner using a combination of table format and graphs/charts. - Customizable templates. The interface should allow for some customization options. Ideal Skills: - Extensive experience with Excel VBA and macros. - Proficiency in creating user-friendly dat...
I'm in need of an Excel VBA expert who can help accurately calculate the annual interest and face value payments of my bond portfolio, which comprises only plain vanilla fixed rate bonds, with coupon freuquency either 1 or 2 (annual / semiannual). I need to be able to perform thos cashflow rollout regularly in case my portfolio composition changes. Ideally there is a button to click and Excel will start the rollout. Key tasks include: - Calculating the correct cash flow dates based on maturity date with VBA. This is the most difficult piece. I would like to have all cash flow dates of all bonds in the portfolio in one top row and the relevant cashflows below ( i.e. if there are 20 bonds in the pf, there should be one date row and 20 interest/ maturity cf rows. - Deter...
I need a skilled professional who can unlock a VBA in an xlam file. This project is crucial for me as I need to modify existing code and potentially add new features to improve the overall functionality and performance of my tool. Key Requirements: - Expert in VBA and Excel - Experience in unlocking Excel's built-in protection - Ability to modify code, add features and improve performance - Problem-solving skills to fix bugs and recover lost functionality Please note, the aim of this project is solely to unlock the VBA and make necessary modifications. The xlam file is locked using Excel's built-in protection, and a thorough understanding of this and VBA coding is crucial to the success of this project.
I'm looking for a professional to help me automate process follow my instruction Key Requirements: - Expert in VBA, Macro and data analysis Details will be share selected freelancer.
We are looking for an experienced Excel freelancer to develop a comprehensive and automated spreadsheet for our order management process. The ideal candidate will have a strong background in creating user-friendly, flexible, and professional spreadsheets that can generate reports and metrics efficiently. Project Requirements: 1. Masterfile Creation: • Develop a central masterfile for order management. • The masterfile should be easy to update with new data. 2. Automated Reporting: • Generate automated delivery reports. • Create financial metrics, OTIF (On-Time, In-Full) metrics, and summary reports. • Ensure all reports are linked to the masterfile for real-time data reflection. 3. User-Friendly Design: • The spreadsheet must be easy to navig...
I need an Excel macro that can count specific data from my Excel sheet and then paste it into the body of an email. The macro should be able to send these emails to both a list of specific recipients as well as a mailing list. Requirements: - Develop an Excel macr...able to send these emails to both a list of specific recipients as well as a mailing list. Requirements: - Develop an Excel macro capable of counting specific data from an Excel sheet. - The macro should be able to insert this data count in the body of an email. - The macro should have the ability to send emails to both specific recipients and to a mailing list. Ideal Skills: - Proficiency in VBA programming for Excel. - Experience in developing Excel macros for data manipulation. - Familiarity with email automation f...
I need an Excel macro that can count specific data from my Excel sheet and then paste it into the body of an email. The macro should be able to send these emails to both a list of specific recipients as well as a mailing list. Requirements: - Develop an Excel macr...able to send these emails to both a list of specific recipients as well as a mailing list. Requirements: - Develop an Excel macro capable of counting specific data from an Excel sheet. - The macro should be able to insert this data count in the body of an email. - The macro should have the ability to send emails to both specific recipients and to a mailing list. Ideal Skills: - Proficiency in VBA programming for Excel. - Experience in developing Excel macros for data manipulation. - Familiarity with email automation f...
I'm seeking a skilled VBA developer with SolidWorks API experience to create an application that automatically designs a simplified boat hull based on parameters from an Excel file. Key requirements: - The application will take length, width, and height parameters from a single sheet Excel file. Ideal candidates will have: - Proven experience in creating SolidWorks applications. - Expertise in VBA programming. - Ability to design user-friendly applications.
I need an Excel macro that can count specific data from my Excel sheet and then paste it into the body of an email. The macro should be able to send these emails to both a list of specific recipients as well as a mailing list. Requirements: - Develop an Excel macr...able to send these emails to both a list of specific recipients as well as a mailing list. Requirements: - Develop an Excel macro capable of counting specific data from an Excel sheet. - The macro should be able to insert this data count in the body of an email. - The macro should have the ability to send emails to both specific recipients and to a mailing list. Ideal Skills: - Proficiency in VBA programming for Excel. - Experience in developing Excel macros for data manipulation. - Familiarity with email automation f...
I'm looking for an Excel expert who can create a function for me. I need this function to take an Amazon ASIN from column A and return the corresponding product category in column B. - The function should be compat...I need this function to take an Amazon ASIN from column A and return the corresponding product category in column B. - The function should be compatible with Excel 2019 or later. - I will be processing less than 100 ASINs at a time. - Please note, I do not have access to Amazon's Product Advertising API, so the function should not rely on it. Ideal skills for this project include advanced knowledge of Excel functions and VBA programming, as well as a good understanding of Amazon ASINs and product categorization. Previous experience in creating simila...
I need a proficient VBA or similar local programming developer with vast experience in creating Macros. Specifically, your task will be to write a Macro for a Microsoft Word document that will allow us to save each of its 7 sections as separate document files. To clarify: - The sections are clearly marked in the headers, labelled 'Section 1' to 'Section 7'. - The segmented files must retain their original headers. Strong skills and extensive background in Microsoft Word Macros, Microsoft Visual Basic for Applications (VBA), or similarblocal programming languages are needed to perform the job efficiently and effectively. Please bid only if you're confident in handling this requirement.
I'm in need of a skilled developer to expand my Excel-based accounting application in...financial matters. Skills that would be needed: ---Data Analysis and Automation---- - VBA/Macro & Apps Script for any Office App Automation - Advanced Excel, Access, PowerPoint, Word - VBScript, PowerShell, CMD Script - SharePoint, Power Platform (Power Automate, Power Apps, etc) - Web Scraping - Office Add-Ins and CustomUI - Power Query, PowerPivot (DAX) - Interactive Report with Dynamic Chart, Pivot, etc in Excel and Power BI - SQL Database The ideal candidate for this project should have extensive experience in web development, particularly in creating interactive applications. Knowledge of accounting principles is a plus. Please note, integration with banking systems is not ...
I'm in need of a proficient VBA programmer to create an interactive Excel for me. The Excel will serve as a tool for users to query a protected dataset. This dataset contains information about various hospitals across the UK. Key Features: - Users will be able to filter the data based on: - Hospital type - Geographical region - Specialty services - The data will be visualized on a Heatmap within the Excel. - Users should have the ability to save their query results as a PDF. Ideal Skills: - Strong proficiency in VBA programming - Extensive experience with Excel - Familiarity with creating interactive tools in Excel - Prior experience with data visualization, particularly using Heatmaps - Understanding of creating protected datasets in Excel This project...
I need a skilled Excel VBA programmer to create a macro that can automatically delete specific rows in my Excel worksheet based on a specified cell value. Key Requirements: - The macro should automatically run each time a new entry is added to the Excel sheet. - It should be designed to delete rows that meet a certain criteria based on a cell value. Ideal Skills: - Proficiency in Excel VBA and automation. - Experience in creating macros for Excel that execute based on certain conditions. - Strong understanding of Excel functions and capabilities.
I...am looking for an experienced VBA programmer with strong expertise in MS-Visio to help format the shadows of role shapes in my Visio file. The task involves applying different shadow colors based on the Work location value for each shape. Specific Requirements: Format each shape’s shadow color according to its Work location value as specified below: UB/OT: #FF4A4A KB/OT: #FF4A4A OT: #00749B UB: No shadow DZ: #F47721 KB: #70A489 BNE: #AB9AC0 PEK: #AB9AC0 PER: #AB9AC0 General Shadow Setup: Transparency: 0% Size: 105% Blur: 0pt Angle: 50° Distance: 5pt Ideal Skills and Experience: Proficiency in VBA programming Extensive experience with MS-Visio Ability to implement predefined color schemes effectively If you meet these criteria and are interested in this pr...
I'm in need of a Typescript expert who can convert an Excel file with existing Macros and VBA code into a format that can be opened and used with Microsoft 365 App. Key Responsibilities Include: - Retaining all the Macros from the original Excel file Please note that the client didn't specify the intended use of the converted file or any specific formatting requirements. The ideal candidate for this job should possess the following skills and experience: - Proficiency in Typescript - Experience with Excel Macros - Experience with Microsoft 365 App and its compatibility requirements
We are seeking highly skilled and experienced freelancers with expertise in one or more of the following areas for a series of development, automation, and web projects. The ideal candidates should have proven track records in their respective fields and the ability to deliver high-quality results within deadlines. Required Skills: VBA Excel (Automation): Expertise in automating Excel tasks using VBA. Strong knowledge of Excel functions, data manipulation, and custom macro development. Ability to create complex automated workflows and reporting tools. Python Expert: Proficient in Python with experience in developing automation scripts, data analysis, web scraping, and API integration. Familiarity with libraries such as Pandas, NumPy, Selenium, and Flask/Django. Ability to ...
Hi, I will do your fixed data automation project. Thank you
