Confluence macroJobb

excel vba programming convert excel sheet function into VBA

We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.

The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

We required to develop some requirements to be done on Excel macro using office 365.

I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and reliable web app...

...quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Excel sheet. Very Important: Excel Formula/Script/Code/Macro/VBA Function or whatever you can call which is embedded in and compatible with excel. (You have to open the attachment to run a script on it). When the available quantity of a spare part reaches a certain value ( Minimum Stock Value or Less ), An automatic Notification Message including the data of I.N , S.P.D , and A.Q, Will be instantly sent into my what's app Number So I ...

I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.

I need an experienced Node.js developer to help me tackle some critical issues in my medium-scale application. Key Responsibilities: - Debug and fix application crashes - Resolve unexpected error messages - Optimize performance to enhance user experience Additional Notes: - The project's current documentation is maintained externally, using tools like Google Docs or Confluence. You may need to familiarize yourself with this documentation to understand the application's structure and flow. Ideal Skills and Qualifications: - Previous experience in debugging and resolving Node.js application crashes - Proficiency in error handling and resolution - A keen eye for performance optimization - Strong communication and problem-solving skills - Ability to work with external docu...

...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 line items, on 3 fields. The macro allows to: • Generate the Output in a separate spreadsheet (which captures only the required fiel...

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 with Employee Training...

...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 or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custom setup...

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 require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...

I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...

I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.

I'm seeking a highly competent freelancer with proficiency in Excel to create a comprehensive system to track my restaurant's weekly expenses. Key Job Responsibilities: - Develop a basic expense tracking Excel sheet. Macro auto update - Structure the sheet to track various types of expenses including but not limited to food costs, employee wages, and utility bills - Design the sheet for weekly data updates The ideal candidate should have: - Proficiency in Excel - Understanding of restaurant operations - Experience in creating expense tracking systems or similar projects. I'm not looking for sophisticated features such as budget comparisons or data analysis at this moment, just a simple, clean, and easy-to-use design. However, the sheet should be crafted in a way ...

Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:

Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already established. Looki...

I am currently encountering an issue with a Python macro that is not performing as expected. I'm uncertain of the actual problem, but I believe it's a simple one. Despite no recent alterations made to the macro, it is not running properly and it's impacting the overall function of my program. - The Task: The primary task is to diagnose the specific issue troubling the proper functioning of this Python macro, and subsequently implement the necessary corrections. - Macro Function: Though I am uncertain of the exact problem, the macro's primary function is to perform data manipulation operations, which aren't being successfully executed now. Ideal Skills: - Proficiency in Python - Prior experience in diagnosing and fixing issues relate...

I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find

...time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to understand and allow me to add new tables in the future. 2. Create a macro that will extract the table from each of the links and into Excel. Because the table statistics change every day, currently, I copy and paste manually, so I want to automate it. 3. The details start from the R - Team row. 4. Compulsory for basketball to extract data in Columns B to J, and for Soccer Columns B to I 5. Only programmers with successful scraping demos will be consi...

Develop macro to generate Word docs

I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.

...what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or errors - A background in data extraction would be highly advantageous If you think you can handle this kind of task, I would be interested to hear from you. The macro does not...

I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward for someone who...

...multiple Confluence pages into a single new page. This project involves interacting with Confluence's API, data manipulation, and automated content creation within Confluence's platform. ### Project Objectives: 1. **Data Extraction**: Write a script in JavaScript or Python to fetch content in JSON format from multiple Confluence pages. 2. **Data Parsing**: Parse tables from the fetched pages, extracting key-value pairs where the row name serves as the key, and the cell content as the value. 3. **Data Aggregation**: Aggregate all key-value pairs into a map, and then store these maps in an array to handle data from multiple pages. 4. **Data Integration**: Iterate over the aggregated data to create a single, consolidated table. Use this table to crea...

Develop macro to exclude strategies

As an MBA student, I need someone to help with my research paper focused on evaluating the cost-effectiveness and ROI of using micro-influencers versus macro-influencers in marketing campaigns. Key Objectives: - Analyze the comparative ROI of micro-influencers over macro-influencers - Use case studies of influencer campaigns to back findings Ideal Candidate Skills: - Proficient in business writing, specifically in academic context - Strong background in marketing and financial analysis - Familiarity with influencer marketing - Ability to analyze case studies effectively I look forward to working with someone diversely skilled in business research to bring this project to fruition.

Develop macro to merge data from workbooks

The project is about Excel VBA and macro.

I am in need of an expert Word VBA programmer to: ...documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the website (PDF to WORD Converter) or free API (similar like quality). The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids. Please look attachment.

Looking to bring on board a talented graphic designer to create two distinct logos for ...possess: • Extensive experience in crafting minimalistic designs • Creative prowess to combine marine, computer, and space themes Logo Requirements: Hydrasub Logo: • Exploring a fusion of marine life and aqua-tech is desired • Preferred color scheme involves cool colors, especially shades of blue, green, or purple. Cybersub Logo: • As we are a cyber sub with a futuristic vision, a confluence of cyber and space elements for the logo is sought after. • To maintain continuity, the color scheme should fall within the specks of cool colors. Your creativity is your only limit in this project; combine the above guidelines with your own ideas and produce so...

I'm looking to improve how my small team (1-10 member...to improve how my small team (1-10 members) manages projects using Confluence. My ideal freelancer should be able to: - Implement advanced task tracking capabilities, resulting in clear accountability and a tangible record of progress. - Integrate strong team collaboration tools, encouraging more effective communication and idea sharing within the framework of Confluence. - Set up comprehensive reporting and analytics functionalities, allowing us to get a bird’s eye view of the project’s performance. Experience with Confluence and a demonstrated ability to enhance project management systems will be essential for this role. Understanding of task tracking, team collaboration tools, reporting and a...

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet....re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be shared during our one-on-one project d...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

Need to upgrade my existing excel macro, very simple project

Need assistance in Jira and Confluence environment set up

I am need of a seasoned Jira Software administrator who can assist in setting up Jira and confluence environments

macro based excel project with auto copy data and paste in chrome through selinium

I need a Microsoft Excel wizard who is skilled in Visual Basic for Applications (VBA). Your primary tasks will include: - Leveraging VBA within microsoft excel to perform find and replace tasks on external files (.html files) - An excel spreadsheet placed in a folder will be able to... Macro 1 Will list all the files in the current directly in column A Macro 2 Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found) Macro 3 Will open and find the string listed in column A and replace it with the new string listed in Column D Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating macros, utilizing VBA for...

I am in need of an expert Word VBA programmer to: - Develop custom macros ...programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the (PDF to WORD Converter) website. The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids.

We are seeking a skilled web designer to revamp the front end of our company website, IDIGITALPRENEUR, to align with our global expansion initiatives. The redesigned website should exude professionalism and incorporate modern design elements, including micro and macro animations, to enhance user engagement. Current Website - Key Requirements: - Redesign IDIGITALPRENEUR website to reflect a modern, global brand image. - Incorporate micro and macro animations to elevate user experience. - Maintain a professional aesthetic with a preference for a dark color theme, though light colors can be utilized as needed.

Primero, recibo los pedidos a través de WhatsApp. Luego, transcribo los nombres de los pedidos en un documento de Excel. Utilizo una macro VBA en Excel para generar archivos individuales para cada nombre listado en el documento. Estos archivos se crean a partir de una plantilla base llamada "libro ". Una vez generados los archivos, los protejo manualmente uno por uno utilizando un programa externo. Finalmente, adjunto cada libro de Excel protegido a los respectivos contactos de WhatsApp. Estoy interesado en automatizar este proceso y me gustaría explorar diferentes propuestas para lograrlo. Próximamente, compartiré un video detallando el proceso actual a través de un mensaje directo. puede ser web, que funcione tambien con el celular. ...

The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the open-source version of (free!). Screenshot attached. We need this macro within a week. So please only bid if you can work on this now. In your bid, please mention "within-a-week". Sorry about that, we need that filter to avoid all the spam bids.

I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.