What is vbamunkák
SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, ossz...
Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.
Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti
1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: ...inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables -...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly solution that s...
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
...an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience working with NSE ...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
...issues with featured images on our WP site. They are currently not showing up on some of new pages, even though they appear as expected on the homepage, blog posts, and product pages. If we copy an existing page and modify it to make a new page, the featured image shows up, but if you create a new page, the image is not showing up. Also a side menu bar is also not showing on the new created page unless we copy the existing page and modify to make a new page. We believe that this is the code issue. The perfect candidate for this job will: - Have extensive WordPress experience and a deep understanding of its back-end systems - Have experience with a variety of WordPress themes - Be able to troubleshoot and resolve the issues in a timely manner Please propose your...
I have an original album cover in SVG format that was used for the song "Inside Out". This June a remix of the same song will be released. The idea is to give the current album cover a fresh, modern and professional touch. It will also be necessary to add "Twilight Remix" to the title (side note: the full name of the release will be "Ge & Luke - Inside Out (Twilight Remix)"). Feel free to experiment with the current cover (you can change the color scheme, change some design elements, change the typography). The overall style should lean towards a minimalist design, staying clear, crisp and visually impactful. However, the design of the old album cover should still be recognizable. The ideal freelancer should have - Proficiency with design tools ...
I have an error in my asp.net MVC application. The form is using AJAX to show particular dropsownlist data. its working fine but if the validation works, the ajax call is reseting and stop working.
We're experiencing challenges with the currency exchange feature on our Laravel project. Here are specifics: - The exchange rates are incorrect. - There are conversion errors during transactions. - We're unable to save API settings. Currently, we're utilizing the Currency Converter API for conversion tasks. Therefore, we're seeking an expert who's proficient with this API and Laravel, capable of: - Identifying the root cause of these issues. - Correcting the incorrect exchange rates. - Resolving the currency conversion errors. - Ensuring the API settings save as desired. Strong API troubleshooting skills are fundamental to the success of this initiative. A solid understanding of Laravel frameworks and previous experience handling similar issues would be ideal....
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Y...
Comment pensez-vous à un projet sur la littératie financière pour les jeunes adultes? Ça pourrait inclure des ateliers sur la gestion de l'argent, l'épargne, les investissements, etc.
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you ...
About us: BA Marine is 3 years old company with a track record of USD 15 Million value of transaction of 60 vessels in GCC during the past 3 years and operated by the owner alone that generate 60 existing clients and 400 prospective clients. We are looking for bilingual speakers: Arabic and English for social media/ LinkedIn outreach. Your tasks include: -Screening existing Facebook and Instagram users by sending DMs using your accounts to check if they are interested in a certain boat by providing our boats database. -Approaching users on LinkedIn targeting C-Level, Doctors, Engineers etc who are based on Arabian Gulf seafront cities. -Inviting users on public groups or any other boat lovers communities to join our FB page or to follow us on Instagram. -Nurturing clients who...
I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom...developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar project...
I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.
...this job offer only if you can submit completed job by the due time. In your EOI please list relevant experience. The job will be assigned to the most suitable Freelancer within 1 hour of being posted. Due date - 6 a.m. 2nd May 2024 AEST (Sydney time). QUALIFICATIONS - Freelancer with MEDICAL BACKGROUND is preferred, especially experienced OCCUPATIONAL THERAPIST, PSYCHOLOGISTS or ADHD COACH. Please list in dot points what HR should be aware of considering hiring a person with ADHD, what are the struggles at work of an adult employee with ADHD, potential contributing factors and symptoms of work burnout and risk of low performance (KPI's). Key Responsibilities: - Conducting thorough research into the area of work performance, with a focus on cognitive, beha...
I need a text-based logo for my residential property business. The logo should be unique, catchy, and represent the quality service we deliver to our clientele. It should resonate with the housing or real estate industry and be easily recognizable. Ideal Skills & Experience: - Previous experience in logo designing, particularly in the property or real estate sector would be preferable. - Proficient in graphic design software. - Strong creative thinking and understanding of branding.
More details: Cross platform app for creating a community of like minded friends. Could be based on an existing open source dating or social media site. Goal is to facilitate managing loneliness. Technology: Flutter or suggest your favorite development platform. Is this project for business or personal use? For personal use, if works well, it will be core for incubating a non-profit (maybe charity) enterprise What information should successful freelancers include in their application? Past cross platform Flutter work. Working demo from which our product cab be spawned is not necessary but can go a long way towards selection. How soon do you need your project completed? Within a month
I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be ab...
...skilled and experienced individual who can handle our monthly social media and SEO for Facebook tasks for professional education, YouTube marketing and LinkedIn. Below are specifics of what I require: - Must be Arabic speaking native - non Arabic speakers do not send please. - Platforms: Primarily, I'm looking for someone who can effectively manage Facebook, Instagram, LinkedIn, and YouTube. - Goals: The primary goals of this role will be to increase our brand awareness, drive traffic to our website, and generate valuable leads for our services. - Target Audience: The target audience for our marketing efforts is primarily business professionals and engineers. More Details in the attached initial Plan Ideal candidates are Native Arabic speaking, Can partner...
...Budget is 10 USD The calendar should look like this: Link I want it for "November 2024" Please note: the Budget is 10 USD Please take a look at the attached calendar because I want it to include: Monthly P&L ( like in the attached example) Number of weeks for the month. ( like in the attached example) Note: I want to delete red numbers or red days. Also, you have to add the amount of dollars like in the attached example Delivery, sigma link ****Please note:*** Please note: the Budget is 10 USD This budget is fixed. If you cannot accept the allocated funds for this task, kindly refrain from submitting your request. The delivery time is flexible
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
I am looking for a skilled Python engineer to create an engine which is capable of finding pre-defined Data Points (DP’s) within the PDF file. Objectives for the system: 1. It has to be completely offline (no online solutions will be accepted); 2. System has to be integrated with LLM (Llama or similar); 3. LLM must be capable on answering questions (via chatbot interface on GUI) on: a. DP’s; and b. Text it read while it was scanning the PDF and looking for DP’s; c. Previously read documents related to the same client. 4. DP’s are to be saved to SQL table; 5. We need a dashboard, to train the engine on finding DP’s in the document. Current problems: A. Large part of documents are scanned, but regardless if the document is scanned or not, it&rsqu...
...entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experien...
...entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experien...
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
...this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I bel...
...entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experien...
Hi hope you have a good day. I have odoo installed on like this I have asked someone else to update my docker image to version 17 odoo. I have no... I have odoo installed on like this I have asked someone else to update my docker image to version 17 odoo. I have now this problem It has to be fixed on the saas for the enterprise version V17 I am in search for someone who can solve this for me. Is this something you can do? Thank you for you're response. Cheers, Deef
...currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule is...
...graphics design. Your work. Client share some money to your account. You have to pay this money to my freelancer. You must capable to handle the transaction. Only comfortable in bank transfer. Your share is 5% on every payment that you get in your account. For example first payment you received 1000$ than you have to send $950 to freelancer 50$ I'd you profit. Monthly transaction - 10000 to 20000+ a month. So you can earn 500-1000$ or may be more every month without spending more time. First we do smaller payment and when we go trust on you we continue with our normal payment. Who is capable to handle this on behalf of me let me know. Note: for this job you need 10-15 minutes time when client send the money. And you must need to gave the ACCOUNT number. ...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.
...handle include: - Managing and optimizing Facebook ad campaigns - Managing and optimizing Google AdWords campaigns - Implementing and managing conversion tracking and optimization Key points to consider for this project: - I already have existing Facebook and Google Ads accounts set up, so the focus will be on enhancement and optimization of existing campaigns - The primary goal of these campaigns is to increase website traffic. Helping me with setting up my catalog with Facebook meta. The ideal candidate for this job should have: - Proven experience in managing and optimizing Facebook and Google Ads campaigns - Proficiency in conversion tracking and optimization - A proven track record of increasing website traffic through Facebook and Google Ads I'm seeking a professi...
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - U...
I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped with a section for open job cards where I can easily manage and keep track of ongoing tasks. - **Inventory Management:** I prefer a manual entry for inventory items. The system should facilitate the creation and maintenance of inventory templates in an easy and efficient manner. - **Dashboards:** The dashboards should be highly customizable and provide me with a detailed overview of all the key metrics that I need to monitor regularly. The level of customization should be advanced, allowing me ...
I'm looking for a skilled graphic designer to create a unique and professional logo for my business. - The logo should be original and distinctive, reflecting the essence of my business. - It needs to be suitable...strong portfolio of previous work. - Ability to understand and translate clients' needs and business identity into visual concepts. - Proficiency with design software and tools. - Strong communication skills to ensure a smooth and collaborative process. Please include examples of your past work and a brief overview of your approach to creating a custom logo. I'm a remedial therapist, business name is Full On Remedial . I would like the initials to be combined FOR with business add to . I'll will attach something I like and would like the same sort d...
...existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start this project as soon as possible, and timely completion is esse...
I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks depending on th...
I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.
...implement a powerful goal seek macro for my spreadsheet. Here are the details: - **Scope:** The macro's primary purpose is to automate complex calculations, which would otherwise be time-consuming and prone to errors if done manually. - **Functionality:** The macro should be capable of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to ...
More details: I'm short on time and want some parts of the attached Word document removed. Some wording is incorrect, specifically, 8 words that I'll show you when we chat soon. The font type, size, spacing, etc all need to be the same including the footer and header, and graphics the whole document needs to be the same, just minus the incorrect words I've highlighted thanks. I want this project completed ASAP thanks for applying.
