Xls name vba jobs
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...
I'm looking for a unique and creative logo design for my ice cream and juice bar. The logo should have a fun and vibrant appe...sense of fun and vibrancy. - It must be bright and colorful, in line with the brand perception. - I would appreciate a mix of both icon and word-based logo options. Name Suggestion: I'm also looking for suggestions for a catchy and memorable name for the bar. The best name suggestion will win the contest. Ideal Skills: - Proficiency in graphic design and logo creation. - Understanding of color psychology and design principles to create a fun and vibrant logo. - Experience in branding and creating a memorable brand name. If you're a creative designer with a knack for fun and vibrant designs, and can come up with a c...
I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successfully deli...
Hi Emilia S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
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.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
...domain is not available for purchase (or purchasing price is too high, like several thousand dollars) . I'm seeking a creative individual to help me find the perfect name for my software solutions company. Company will provide different kind of solutions, so it is not limited to spesific aim of the website is to attract a broad range of clients, to serve all industries equally, and it should be engaging and easy to remember. The ideal name should: - be 10 characters at most. - should not contain the word "soft". - can contains suffixes like "tech" or "era". But not limited to these suffixes only - .com domain name should be available - Be versatile enough to cater to clients from various industries - Be engaging and memorable...
As the client for this project, I urgently require an expert in VBA.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
...only will I need a catchy and engaging logo, but I also need a unique name for my video content production company. Here's what my project entails: • Inspiring and Reporting: I skipped choosing the right name for my company from the given options, so I'm open to any distinctive and inventive names you can suggest. • Logo Design: The logo should epitomize creativity, which I selected over a minimalist or a modern theme. It should accurately represent my business and speak to the nature of my services in an engaging and attractive way. • Future Prospects: Eventually, I will be branching out into managing social media, creating social media content, and strategizing social media marketing. Therefore, the chosen logo and name should allow room ...
I'm initiating a monumental project focused on broad-based medical research. I need a professional to cultivate an impactful identity for my project through stellar naming, logo design, and profile creation. Here's what you should bring to the table: - Proficiency in Branding: I'm counting on you to bring your creative flair to the naming process. Make this project memorable. Name and Logo of the project - Expertise in Graphic Design: Demonstrate your talent in crafting a unique logo that truly symbolizes the essence of the project. Logo, Slogan, Images. - Exceptional Writing Skills: I anticipate a compelling project profile that encapsulates our commitment to advancing the medical field through various research types. Outstanding skills of Powerpoint formation is...
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...
we are trying to reach out to businesses like locksmiths, key cutting stores, shoe repairs, covenience stores and cell phone repair businesss. We are looking for a canada wide list. we need the list to encompass these cities i will find places in these cities: Ontario Toronto Ottawa Mississauga Brampton Hamilton London Markham Vaughan Kitchener Windsor Burlington Greater Sudbury Oshawa Barrie St. Catharines Cambridge Guelph Quebec Montreal Quebec City Laval Gatineau Longueuil Sherbrooke Saguenay Levis Trois-Rivières Terrebonne British Columbia Vancouver Surrey Burnaby Richmond Abbotsford Coquitlam Kelowna victoria Alberta Calgary Edmonton Red Deer Lethbridge Manitoba Winnipeg Saskatchewan Saskatoon Regina Nova Scotia Halifax
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I am seeking a talented designer to create custom tote bag designs that consist solely of names. These designs should be simple, minimalistic and centered around different names. Your application should demonstrate: - Proven experience in graphic design, particularly in creating custom typography designs. - An understanding and appreciation for minimalistic aesthetic and design. - Your creativity in turning names into unique, visually appealing designs. Please include relevant samples of your past work in your application.
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
Development and Enhancement of Excel VBA Project Tracker.
I am looking for a freelancer who can assist with following 3 tasks: 1) Around 250-300 expense invoices data entering in Odoo (given in PDFJPGTXT). Deadline: 26.04.23 2) VAT file preparation in VAT template, based on Sales data (entered in Odoo already) and based on Expenses (entered by you at step 1), which can be extracted in xls. Deadline: 27.04.23 3) P&L report creation and books closing, particularly entering of missing data for P&L: - HR salary in Odoo (3 entries), - Part timers HR costs entering (5 entries) - rental expenses (4 entries) - new fixed assets' (8 entries for depreciation). Deadline: 05.05.24 Skills and Experience: - Experience with Odoo is required. - Knowledge of VAT for UAE filing and financial record management (P&L standards) is requir...
Adjust code to export Supplier's name
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experienc...
• 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 m...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 "Bo...
I'm in search for a skilled developer to create a complete Office Package, compatible with the Windows operating system. Tasks include: - Word processing application: This should be able to read and write .docx and .doc file formats. - Spreadsheet application: This needs to create, manage, and support .xlsx/.xls file formats. - Presentation application: Here, the application should be capable of creating, editing, and supporting .pptx/.ppt file formats. Ideal Skills: - Experience in developing software for Windows. - In-depth knowledge of word processing, spreadsheets, and presentation software development. - Understanding of the requested file formats. Please note, we're searching for a robust, fully-functional software, and the budget has been set considering the c...
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 for successful output.
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 am seeking a skilled graphic designer to create a banner and name board for my upcoming supermarket. Key requirements: - The design should be minimalist and clean. Less is more for this project. - The banner and name board should be visually cohesive and represent the supermarket effectively. Ideal Freelancer: - Portfolio of past work must be provided in application Please apply if you meet these specifications. Let's create an inviting and stylish visual identity for my supermarket.
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.
...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 ...
Need Sticker paints with Company name and Logo on Home Appliances
I'm in need of a name for an online platform that is set to rival LinkedIn. The platform should be professional in tone, and the ideal name should: - Be an average of 5 letters - Easily and simple to remember for both blue and white collars - Cater to various ethnic regions -background in psychology to identify key factors is of added value To apply for this job, please include examples of your previous work and experiences with naming or branding. Your submission should be professional and provide evidence of your skills in this area. Please avoid overly creative or casual submissions, as I'm seeking a professional tone for the platform name.
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'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentia...
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 closes...
In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.
I need a developer who can help me save WPForms submission attachment files into a structured folder. I'd like the files to be saved in a form-based hierarchy, specifically by following: /Form name – form ID /year /month (start at 01) /entry ID The attachments will be a mix of different file types - images, documents, media files, and zip files. Thus, the ideal candidate will be familiar with storing and organizing a variety of file types. Additionally, I'd like the saved files to retain their original names. This way, downloading or accessing them will be stress-free. This task requires strong PHP and WordPress skills, particularly in working with WPForms. The ability to handle file management and ...
...account balance reporting. Optional features include a chart of accounts with automatic generation of accounting entries and export functionality in TXT, JSON, and XLS formats. The ideal candidate should be able to implement these features and ensure they are integrated seamlessly into the existing system. Key Points: - Extend existing module with purchase and sales registration. - Implement correction notes and payment/collection receipts. - Create an account balance report feature. - Optional: Develop a chart of accounts with automatic generation of accounting entries. - Optional: Implement export functionality in TXT, JSON, and XLS formats. - Also required: Develop a receipt form and accounts receivable/payable for clients, suppliers, cash, and banks, as well as for ot...
I'm looking for a freelancer who can type up data from an XLS Excel sheet. The data is related to different categories and I want it organized accordingly. Additionally, I would need some basic analysis done on this data; think simple calculations like sum and average. Ideal Skills: - Proficiency in Excel, specifically with XLS files - Experience in data entry - Ability to perform basic calculations Please note: This project doesn't require any complex analysis like pivot tables or charts, just simple arithmetic operations.
...website and navigate to the list of potential investors. - Carefully extract the following details for each investor: Name, Fund name, and 'Sweet Spot' investment amount. - Collate this information in a well-organized Excel spreadsheet. - Find and add a link to each investor's LinkedIn profile alongside their extracted details. Specific requirements: - A meticulous approach to uphold the accuracy of data. - Experience or familiarity with Excel or similar spreadsheet software. - Strong data extraction and entry skills. - A detailed project proposal demonstrating understanding of the tasks involved. Upon successful completion of the project, I expect to receive the spreadsheet in .xls or .xlsx format. The spreadsheet should be ready for analysis with...
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 systems in Excel. - Knowled...
...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 entry within Excel. Deliverables: Workbook Templates: Standardized teacher workbook template Master File template ...
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
Make a logo for a Coffee Shop. the name of the shop is "Grumpy Monkey Coffee Shop" ** Dont give the monkey a mean or angry face. Also do not make the monkey scary. Do more of a grumpy face.
...functionality into Zoho CRM. *MUST be detail-oriented, intuitive, and goal-driven (a mix of self-directed + training new user on functions). > Limited "directions" to follow-.. instead = "intent/goals" to achieve in organizing our partnerships) + log/line items of tasks & interactions..... set up reminders. + storage / display of real estate inventory (line items of basic data fields) - CSV or XLS files used. + centralized access to source links/quick jumps to various related URLs + templates for standardized emails, trackers, etc *MUST provide 1-2 hours of remote training to a new Zoho user > efficiently able to communicate in English > teach basic Zoho proficiency. Additional training & future workload is negotiable. ...