Vba modifications işler

...numaralı kısımda bahsettiğim web servis aynı zamanda bir takım sorgulama ve raporlama imkanları verir (bir tür APİ). Bu web servis yapısı ve dokümanları var, çok karmaşık değil. Ben google spreadsheet ve excelde vba üzerinden rahatça çalışabiliyorum bunlarla. Bizim ihtiyacımız burada basit bazı tablolamaları belirli aralıklarla AİP'ler ile sorguladığımızda görebilmek. Ardından buradaki veriler ile canlı gelen verileri karşılaştırarak ve oradan çıkan sonuçlara göre yeni web servisler çalıştırmak. Not: Bütçe sembolik yazıldı, lütfen abartmadan (uzaya araç göndermeyecek, ben bunların hepsini VBA ile yapıyorum ama excel şişiyor ondan kurtulmaya çalışıyorum) kendi fiyat ...

Sütunları 2, 3, 4lü ... gruplandırıp grup benzerlik oranlarını hesaplayan VBA istiyorum. Aslında böyle bir VBA daha önce hazırlatmıştım, ama bu VBA belli sütun sayısından fazlasını yapamadı. Belki bu dosyada değişiklik yaparak da işimi görebilirsiniz. Ben 300 sütuna kadar karşılaştırma yapmayı istiyorum.

Hisse senedi, emtia ve yatırım fonu alım satımlarım için grafikler ile kar zararı gösterebilecek güncel fiyat bilgilerini internet üzerinden 15 saniye de bir çekip güncelleye bilecek excel tablosu istiyorum.

Excelde çeşitli ebatlarda olabilen bir tablonun hücrelerinde bulunan değerlere göre bir çarpanla çarparak satır ve sütünları değere göre sıralayacak. Rank order clustering isimli bir matematiksel bir çözüm yöntemi.

Excel VBA kodları olan bir excel türünde bazı sayfa ve hücreler şifreli durumda. Bu şifrenin kaldırılmasına ihtiyacım var.

Merhabalar, Temel olarak, adı Matriks (MTX) olan bir masa üstü uygulamadan DDE veriler alabiliyorum. Bu sayede ilgili verileri excel’e çekebiliyorum ve aslında bundan sonra anlatacağım her şeyi VBA üzerinden yapabiliyorum ama excel'in sınırlamaları nedeniyle, eğer yapabilirsem excel'i aradan çıkartan bir uygulama yaz(dır)maya çalışıyorum. Yapmak istediğim şey kısaca; 1. MTX'in DDE verilerini al (excel olmadan doğrudan MTX'ten tercih edilir. Excel’e ben DDE linkle veri alıyorum, sonra da excel dosyasını python ile okuyabiliyorum ve CSV’ye yazabiliyorum, ama bu istediğim şey değil). Biliyorum DDE eski bir veri noktasıdır, ancak MTX'ten veri almanın başka bir yolu -yani TCPI veya başka bir yöntem- ol...

Mevcut bir excel dosyasında adlı siteden veri çekiyordum. Ancak 1 haftadır siteden veri çekemiyorum. Excel dosyasında module kısmı düzenlenerek dosyaya yeniden veri çekme işlemi gerçekleştirilecektir.

Yeni bir parakende mağaza açılışında giderleri tahmin etme ve kar zarar analizi yaparak mağaza açılıma uygundur veya değildir tarzında bir rapor sunacak excel istiyorum.

google excel sheet üzerinden birden fazla firmadan teklif alarak fakat verilen teklifler birbirinden gizli olacak şekilde açık arttırma ihalesi gibi bir makro excel oluşturmak istiyorum.

BENİM BELİRLEDİĞİM HÜCREYE GÖRE OTOMATİK FİLTRELEME YAPACAK EXCEL VBA YAZILMASINI İSTİYORUM

Makale üzerinden modelleme yapılarak vba programı ile ülke ligi ile ilgili program yapılacak

VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.

...the color or the images to the current app. you need to know about programation in arduino, bluetooth and android ,, because this app will manage a lock using the smartphone. I send you the current android app in order that you could understand and know how the buttons work please do not offer your job if you can not open the current job and see how it works Key Requirements: - The design modifications primarily focus on be friendly and easy to use - For the user interface, I'm looking to make changes to the color scheme, font styles, and the overall layout. - In terms of functionality, there are a few particular areas that need work: -The most secure. - easy but secure connection - Enhancing user authentication to ensure robust security measures. Ideal Ski...

I'm seeking a skilled logo designer who can adeptly adjust typography on my existing logo to make it communicate our brand better. The logo is a combination type, incorporating both text and symbols. Key Requirements: • Proficient in working with combination logos • Exceptional typography skills • Ability to understand the brand and reflect it in logo modifications The successful freelancer will have a strong portfolio demonstrating their ability in logo design and font manipulation. An appreciation for brand identity would be particularly valuable for successful completion of this job.

I've purchased a Laravel web app from CodeCanyon and it needs some modifications. This project will include design changes, functionality enhancements, and bug fixes. Here are the specifics: - Design Changes: Although I haven't nailed down the exact modifications yet, I'm looking for a dynamic freelancer who can make my web app look stunning and more user-friendly. Be open to layout adjustments, color scheme modifications, and font changes. - Functionality Enhancements: The main enhancements will involve User Registration/Login and Payment Integration. While the app already has these functionalities, refining them for a smoother user experience would be ideal. - Bug Fixes: As part of this assignment, I'll need bugs identified and fixed to ensure...

I'm in need of a skilled mobile app designer who can assist in enhancing the features and look of my existing app. Key Requirements: - The design modifications primarily focus on UI improvements and functionality enhancements. - For the user interface, I'm looking to make changes to the color scheme, font styles, and the overall layout. - In terms of functionality, there are a few particular areas that need work: - Integration of push notifications to keep users engaged and informed. - Integration of social media, to enhance user experience and engagement. - Enhancing user authentication to ensure robust security measures. Ideal Skills and Experience: - Proven experience in mobile app design, with a strong portfolio of UI/UX work. - Proficient in design to...

Modifications as discussed for WordPress website

We are seeking a skilled 3D modeling expert to modify an existing STL file of a box container, designed to house a 2.8-inch display. The primary objective of this project is to enhance the functionality and aesthetics of the current model. Scope of Work: 1. Internal Modifications: * Integrate four stoppers/screw guides inside the container to secure the components effectively. 2. External Modifications: * Add three strategically placed holes on the sides of the container to accommodate additional components or wiring needs. * Transform an existing USB-C port into an SD Card port, ensuring precise dimensions and fit. 3. Aesthetic Enhancements: * Refine the design by rounding the borders and corners of the container, aiming for a sleeker and more user-friendly f...

I am looking for a Laravel programmer with experience in Filament. The primary purpose of this project is to modify or extend an existing application. Key Requirements: - Expertise in Laravel: Proficiency in Laravel is a must. ...of Filament is crucial. You should be able to navigate its features and effectively integrate it within the existing application. The ideal candidate should be able to enhance the existing application with new features, improve user experience, and ensure a seamless, bug-free operation. You should be able to understand the existing codebase and work collaboratively to deliver the required modifications. Decent communication skills are also important as you will be required to provide updates on your progress. If also experience with WordPress, this is a...

As the project owner, I need a skilled Solidworks expert to convert the attached assembly into a STEP file and meticulously remove the undercuts, while allowing for minor changes in dimensions. This project is particularly important as the modified assembly will ultimately be used...assemblies to STEP files - Skilled in modifying part designs, preferably with experience in removing undercuts - Understanding of and experience with fabrication processes - Ability to respect tolerance specifications by allowing minor change in dimensions post-modification - Strong attention to detail Please ensure that your proposals clearly demonstrate your understanding of the desired modifications and your proficiency in using Solidworks. Any examples of similar past tasks will strengthen your ap...

I'm in need of a skilled patent attorney or professional who can assist me in filing a US patent application. Key Tasks: - Review my conducted patent search and assess potential patentability - Draft and file a comprehensive and legally sound US patent application for my product - Provide advice or make necessary modifications to enhance the application's chances of approval Ideal skills and experience: - Proven track record in successfully handling US patent applications - Proficiency in patent law, particularly in relation to product inventions - Strong understanding of the process and requirements for effective patent filing - Ability to conduct a thorough review of existing patent searches and translate findings into actionable steps - Excellent communication skills ...

...build a basic Shopify app that will eventually be integrated with an API that we're developing (may need hep on this, but it's a separate project). We'll need the freelancers to ultimately sign an NDA and IP agreement. There are several important elements we need built, though we are not yet fixed on a development stack. Basically we need functionality such as shopping cart management, order modifications, returns and exchanges, product information, FAQs, store policies, discounts, and upselling/cross-selling capabilities. Probably most or all is in some github repository, which we are fine with using as well as GPT-4, which, if you don't have an account, we'll get you one. It is important to only use MIT or similarly licensed code such that it is legal ...

I need to move my current ...move my current website, designed on Figma, to Elementor Pro. Sample of job : !!!?type=design&node-id=0%3A1&mode=design&t=acBmxWS1WvkNxU3B-1 Key requirements: - Migrate existing Figma design to Elementor Pro without any loss of functionality or layout. - Ensure the design is responsive across all devices. - Implement any necessary modifications to the existing design to make it compatible with Elementor Pro. Ideal skills and experience: - Proficiency in both Figma and Elementor Pro. - Experience in website migrations, especially from Figma to Elementor. - Strong understanding of web design principles and responsive design. - Ability to effectively communicate and provide transparent progress updates.

I require a skilled photo editor to make modifications to a series of images from a recent event. The project specifics are: - Removal of visible bald spots - To give an impression of fuller hair The source material comprises of high-resolution photos, necessitating proficiency in working with such quality. The end result should be as natural as possible, avoiding an over-edited look and maintain the realism of the original photos. Experience in high-resolution image retouching, hair digital restructuring and a keen eye for maintaining authenticity are the most crucial skills necessary for this job.

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

Hello! I'm seeking an experienced Vue.js and Bootstrap developer who can make modifications to my website. I've uploaded a screen shot of the display that I need changed. I want it to look clean and have the elements align properly. I also uploaded my code. You are free to develop your own classes so there is no conflict with anything else. It's jus a small section of a <div class="person-info" v-for="dataObj in selectedRESEARCHERSLIST" :key=""> Please say in your bid== "I can do this" as the first wording of your proposal That way I can talk to real people,.

We are seeking a skilled 3D modeling expert to modify an existing STL file of a box container, designed to house a 2.8-inch display. The primary objective of this project is to enhance the functionality and aesthetics of the current model. Scope of Work: 1. Internal Modifications: Integrate four stoppers/screw guides inside the container to secure the components effectively. 2. External Modifications: Add three strategically placed holes on the sides of the container to accommodate additional components or wiring needs. Transform an existing USB-C port into an SD Card port, ensuring precise dimensions and fit. 3. Aesthetic Enhancements: Refine the design by rounding the borders and corners of the container, aiming for a sleeker and more user-friendly finish. ...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...

I have a Flutter template that requires several adjustments. - UI Customization: I need the color scheme modified and the layout rearranged. The goal is to create a more user-friendly and visually appealing interface. - Functionality Modifications: The template needs improvements in user authentication, database integration, and push notifications. Experience in these areas is critical to effectively implementing these changes. I'm looking for a skilled Flutter developer who can help me make these adjustments in a timely manner, so please only apply if you have demonstrable experience in this area. Please provide your pricing structure and availability.

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.

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

More details: What type of editing do you need for the logos? Color correction, Image resizing What specific modifications do you need for the logos' text? Font change, Text alignment What specific changes do you need for the PowerPoint presentation? Slide design

...what's not necessary for this job: - No major layout or structural changes are needed. We're sticking to the pre-existing arrangement. To excel in this job, you should have: - Proficiency in working with Visual Studio - Extensive experience working with .rpt format files - Expertise in handling cosmetic changes to digital documents Please note, specific instructions for header and footer modifications will be provided upon project initiation. I’m open to any questions or clarification requests you may have. Looking forward to working with you!...

I'm looking for a skilled developer who can help me customize the Colibrism PHP social network script. Key Requirements: - Experience with PHP and social network development. -...developer who can help me customize the Colibrism PHP social network script. Key Requirements: - Experience with PHP and social network development. - Ability to work with Colibrism's source code and make necessary modifications. - Understanding of user profiles, authentication, and social media integration. - Capable of implementing basic social networking features. This project could be an exciting opportunity for someone who is familiar with PHP and social networking development. The ideal candidate should be able to understand the structure of Colibrism and implement modifications...

...Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensure that existing data in Column B is not overwritten, preserving manually entered or previously fetched data. 4. Customization: - Clearly mark sections in the script for easy customization, such as token keys and Twitter account details, to allow for simple modifications as needed. 5. Notifications: - After new content is fetched, enable the script to send notification messages (5 to 10) via email to inform my translation team about the new updates. - If feasible, also implement notifications via WhatsApp, using the phone numbers of the team members. Additional Requirements: - I would appreciate if candidates could provide a demonstra...

I am searching for a skilled game developer with expertise in C++ and sufficient experience with the Unreal Engine to construct a modded APK for an action game. The desired modifications include: - Unlimited resources - God mode - Unlock of all levels - Customization The perfect freelancer for this project should have a deep understanding of mobile gaming, and proven experience in APK modding. Familiarity with action games will be a significant advantage.

Project Description: We are looking for a skilled and experienced architect or interior designer to modify the layout of our current home. This project involves the addition of two new bedrooms and the integration of an extra bathroom. The initial task will be to convert an existing image of the floor plan into a CAD file. Following this, we will discuss modifications to the floor plan to accommodate the new spaces. Key Responsibilities: Convert an image of the existing floor plan into a CAD file. Rework the CAD file to incorporate two new bedrooms and an extra bathroom, ensuring they harmonize with the overall layout. Design an appealing, functional en-suite bathroom. Ideal Candidate Should Have: Extensive experience in residential floor planning and design. Strong understanding ...

We're looking for a talented Wordpress expert skilled in Avada theme for a set of simple layout modifications and fixes to our website. Specific tasks are: -Fix the mobile menu. Currently it is showing the default theme menu items. Change this so that it reflects the desktop menu links we have created, and make sure it is not shown when on the desktop site.  -The testimonials section on the home page (mobile and desktop) is not displaying properly. Check and fix -Stop the rollover effect on the career sector, so that on rollover nothing changes.   -Point the website contact form to the email address info@domain. set it up and test that it works throughout the site. -Disable the pop-up that appears on the home page when you scroll down.  -Poin...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I'm seeking a talented WordPress professional to breathe new life into my existing website pages. Key tasks include: - Editing and updati...updating the text content on these pages. While this project doesn't currently involve rewording entire paragraphs, maintaining a consistent tone and style across any changes is essential. - Refreshing the images currently live on these pages. Unfortunately, I don't have a specific list of changes for these assets, so I'm looking for someone with a good eye for visual design who can suggest modifications themselves. Ideal candidates will have experience in WordPress content management and a knack for visual design. A strong understanding of written English is a must. Please get in touch if you're confident in making ...

...help me with a few customizations on my WordPress website. The main focus will be on visual design and functionality enhancements. Visual Design Updates: - I need the color scheme to be adjusted. This would involve changing the colors of various elements on the page. - Typography updates are also needed. This includes changing fonts, sizes, and styles of text on the website. - Layout modifications will be necessary. This will involve repositioning and resizing of elements on the page. Functionality Enhancements: - This part of the project will involve making changes to the code of the website to improve its functionality. I'm looking for someone who has experience in WordPress theme customization, CSS, HTML, and possibly PHP for the code changes. Please provide exa...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I used to create the application Android Studio APK, I have the complete source code. I have an application that suddenly stopped generating due to some Android update or some payment system up...been triggered due to these alterations. I am thus seeking assistance from an expert with a comprehensive understanding of Android Studio and its working. Expected skills and experience: 1. Robust expertise in Android Studio and APK creation 2. Solid understanding of UI modifications and its impact on application generation 3. Strong problem-solving skills to identify and rectify the issue Task Requirements: 1. Analyze the issue causing the application not to generate 2. Rectify the issue maintaining the new UI modifications 3. Ensure the application generates successfully withou...

I'm looking to enhance the appearance of my Hospital Management System on Java, which currently has a glitch; the buttons and logo do not scale consistently when viewed on different laptops. Ideally, the modifications would consider the following: - Modify the button styles: Currently, there's no specific preference on the style. Having a design that doesn't change inconsistently when displayed on different laptops would suffice. - Redesign the logo: A unique and attractive logo that represents a hospital management system is preferred. However, no specific color scheme preference was provided. - Enhance the overall layout: The aim here is improving aesthetics and functionality to provide a more user-friendly experience. The freelancer should have a strong skill set...

I'm looking for a skilled Ninja Trader developer to make adjustments to an existing indicator. The changes required include: - Adjusting the indicator's calculation formula: This involves fine-tuning the parameters and logic of the current formula. - Modifying the visual appearance of the indicator: Changing the color scheme and customizing the font or text size are some of the visual modifications needed. - Adding new features or functionality to the indicator: I'm looking to incorporate additional capabilities to the indicator to enhance its utility. The ideal candidate should have: - Demonstrable experience in Ninja Trader 8 development - A strong understanding of indicator calculation and visual customization - The ability to implement new features effectively ...

I'm seeking a skilled Wordpress developer, specialized in the plugin, to implement some changes on my site. The desired modifications encompass a change in the layout/design as well as integrating new functionality. As per the requirements: - Change layout/design: - Add new functionality: A "Post a Request" form needs to be integrated on the home page. - add new functionality: Change "submit listing" to "join Network". add settings as an option on the main dashboard to update a provider listing, More details will be disclosed during the planning phase. Ideal Candidate: - Should have significant Experience working with Wordpress and the plugin. - They should have a strong grasp of creating seamless user interfaces and implementing new featu...

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

...plan. Based on the information you provided, the scope of services will include the following: Architectural Plans: This includes the site plan, floor plan, elevation plan,and structural engineering calculations. Basic Services: I will confirm the design criteria and provide the necessary drawings based on the basic drawing you sent me. If there are any issues with the submitted drawing and modifications need to be made, I will be responsible for revising the drawing until a full set of plans is approved. As part of my commitment to providing you with the best service, I will send you daily reports to keep you updated on the progress of the project. However, please note that I am not available 24/7. I suggest we set a specific time for our communication to ensure that I can add...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement