Sortere data efter dato med vba jobs

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the porta...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial...

I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.

I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.

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 have a daily dataset of the prices and funding fees of cryptocurren...format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I look forward to your proposals. Screen of excel file.

I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.

I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first...

I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database system...

...linked to specific Achievement Standard aspects. Student grading interface with data linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data...

As I'm 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 line items, on 3 fields. The macr...

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.

Adjust the VBA code to exclude names

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 need an Excel macro develop...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 Systems: Experience with tracking and managing employee training programs is a plus. - Communication Skills: You should be able to effectively communicate with me to ensure the macro meets the business req...

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 interactive dashboards. ...

...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 manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA...

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.

hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by usuing formula in excel or use some VBA code

I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.

Please Sign Up or Login to see details.

...Responsibilities: - Automating repetitive tasks within the Excel spreadsheets, to increase efficiency and accuracy. - Customizing the spreadsheets to better suit the specific requirements of my business. I have a specific deadline for this project, so it's important that you are able to work efficiently and effectively within the given time frame. Skills and Experience: - Proficient in Excel and VBA - Experience in spreadsheet automation and customization - Strong communication skills to understand and implement my requirements - Ability to deliver within a set deadline - Previous experience in similar projects would be a plus. If you're an intermediate Excel developer with a solid understanding of automation and customization, I'd love to hear from you. Pleas...

I am in need of a skilled Word VBA programmer who can assist with automating document formatting and creating custom macros. The ideal candidate should be familiar with Office365 Word and have experience working with formatting styles. Key Responsibilities: - Automating document formatting - Creating custom macros The goal is to make a fully functional document with macros based on an example with Word field codes. Ideal Skills: - Proficiency in VBA for Word - Experience with automating document formatting - Strong understanding of formatting styles in Word - Ability to create custom macros - Attention to detail This project is suitable for someone who is looking to apply their Word VBA skills to a real-world problem, and who can work independently to deliver eff...

...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 should be established to compare timesheet entries against leave entries in our 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 advan...

...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 should be established to compare timesheet entries against leave entries in our 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 advan...

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.

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'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accurately, p...

I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.

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'm looking to contract a savvy architect or designer who can deliver a comprehensive blueprint for a medical spa build-out. The ideal blueprint will feature: - A reception area, for initial customer interaction - Three treatment rooms, serving as the spa's primary service areas - Office, break room, and laundry area, essential for daily operations - A retail area—looking to showcase products for sale The perfect candidate will have experience in commercial design, particularly in designing medical spas or similar establishments. A broad understanding of space utilization for customer comfort, as well as employee workflow and operational efficiency, is required. Experience with integrating a retail space into a design plan would be a definite advantage.

I'm in need of a developer adept at using Visual Basic for Applications (VBA) within Excel to scrape exchange rate data from the web. Key aspects of the project: * The focus is on extracting textual content and tables from exchange rate websites. * The specific data to be extracted includes: * Currency codes * Exchange rates * Date and time Ideal candidate's skill set: * Proficiency in Excel VBA with a focus on data extraction from the web. * Familiarity with financial and exchange rate data is a plus. * Ability to implement robust error-handling processes within the script. * Clear communication and timeliness. I look forward to engaging with a knowledgeable freelancer who can fulfill these requirements promptly.

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'm an advanced user looking for in-depth, personal tutoring in Excel and VBA. The tutoring should focus on, but not limited to: - Writing VBA scripts - Database management in Excel - Advanced Excel functions - Automation - Data Entry Form - Result Page Additionally, guidance should be provided on automation of tasks including: - Data import/export - Data manipulation - Report generation The ideal candidate will have an extensive background in VBA and Excel, with a specific emphasis in automation and data management. They must be skilled in conveying complex processes and concepts in a clear, understandable manner.

...first steps towards digitizing data management, I am seeking a proficient Android developer who can transform my existing Excel-based userforms into an enticing Android application. Specifically, the tasks will involve: Functionalities and Features Development: - While I've nailed down some functionalities, I would appreciate some guidance in further enhancing the app's features. Your ingenious input on potentially beneficial features and functionalities, based off our Excel prototype, would be welcomed. Data Interaction: - The app should be designed for data input tasks solely. Users should find it convenient to input data on the go, directly from their Android devices. External Data Syncing: - A critical feature of this app would be it...

As a beginner in Excel and VBA Programming, I am actively seeking an experienced and knowledgeable tutor who can guide me on the journey to developing structural analysis software. I am reckoning on an efficient and in-depth learning experience tailored around my unique learning pace and style. Key Objectives: - Understand Basic to Advance VBA coding and its application in Excel - How to implement complex algorithms in VBA - Grasp of data analysis functions and graphical interface capabilities in VBA Ideal Tutor's Profile: - Qualified tutor with solid and demonstrable grasp of VBA and Excel - Proven experience teaching VBA with commendable patience and understanding - Proven experience developing structural analysis software will be ...

I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.

I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA

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...

...talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functions smoothly. • Previo...

I n...of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable and efficient automation system that can seamlessly integrate data from Excel into Microsoft Planner. A responsive freelancer with a strong understanding of the software and experience in similar projects w...

I'm in need of an expert in VB/VBA development to assist with my software solution, primarily dealing with a scale system for a food company. Understanding Macola software would be highly beneficial. The core focus will be on: - Error fixing in current functionalities when they occur like label printing and commimocation errors - Developing and integrating new features into the system - troubleshooting errors as there arent many but I need the person to be able to support US EST (East coast US) hours The exact errors to address are not currently available, but a strong analytical mindset will be crucial in tackling this project. The ideal candidate should be knowledgeable in VB/VBA, demonstrate solid problem-solving skills, and have experience working with Macola softw...

...of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate: The ideal candidate should be a...

I am looking for an Excel expert who can set up automation for specific tasks and create custom formulas based on my requirements. Key Requirements: - Automation of s...column and report the count in the dashboard the sample file for problem solving. Ideal skills and experience: - Expertise in Excel: A deep understanding of Excel's functionality and the ability to customize it to meet specific requirements. - VBA programming: Experience with VBA programming is a plus as it will be needed to create the custom formulas and set up the automation. - Automation: Proven experience in automating tasks within Excel and making processes more efficient. - Attention to detail: It's crucial that data is handled accurately and that the formulas are correctly implemen...

I need a proficient Python developer to create a stock and options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existi...

Minimal wordmark logo with sleek and smooth lines. It’s for a med spa called NAVA offering Botox and classy beauty shots for free to clients. So incorporating a camera lens or syringe or womans profile would be neat. I also want a hidden element so you can see two images in one when you look at it for a couple seconds. I'm after a unique logo that reflects simplicity and creativity. Key elements to consider include: - Palette should primarily consist of black and white, but incorporate a pop of color for added interest. - The design aesthetic should lean towards organic, flowing lines rather than geometric or abstract shapes. Think smooth, fluid movement to articulate the vision. - The company name must be integrated into the logo design. Ideal candidates for this job ...

I am trying to fetch ebay api token. Code works in php but not in vba

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!