Vba move cell contents 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.
...için maddi destek olabilirim. Ama beklenti profesyonel stüdyolardaki designerların kazancı şeklinde olmasın lütfen bana öğrenci bu işe meraklı ve ileride yurtdışına yerleşme planı olanlar yardımcı olabilir. Tekliflerinizi bekliyorum. Lütfen bana detaylıca Ecet bu işi yaparım ve Youtube dan gelir elde edene kadar video başına xxxx TL talep ederim. Şeklinde taleplerle dönünüz lütfen. We will move abroad in February and we will open a YouTube channel, as every foreigner does. I have already started shooting videos that we will publish in the future. We will shoot all the videos and send them online. I need a video editor/designer to edit these videos. The process will be long because we plan to publish videos on average every week...
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...
...with the shortlist of freelancers. The game has a simple mechanic and in-game mechanics will be the same for all levels. Let’s call the game mechanic a puzzle. A level consists of 4 puzzles and when you finish 4 puzzles a level is completed. The progress of this will be shown on the screen. The constraint for a puzzle is the time that is given to the player. The time will be going down when you move forward the levels. For example, you will start level 1 with 90 seconds bu the 100th will be 60 seconds. These values will be parametric and calculated with the code. (like every 4 levels decrease the time 2 seconds) Every level the last puzzle will be special one also we will be limiting the moves. It will be displayed on the screen as well. If the moves end it will be treate...
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.
...files - Writing with different fonts and colors - Drawing with the mouse on the board, drawing types (thick thin silky gold polishing) - Ability to authorize students for writing - Live video / audio sharing from the camera - Authorization of cameras of students depending on the will of the teacher, if they want, students can enable their cameras too. - Live chat box - Ability to add slides and move on them and draw on them with mouse - Setting the necessary back-end of the software with comments on how to integrate. - A box to ask questions - The student will be able to talk if the "raise hand" feature is confirmed by a notification that will appear on the screen of this learning. - Current student list - Record of the movements and video of the webrtc, the playability...
OpenGL ile 3D/2D CAD program arayüzü yapılması 1. OpenGL ya da Vulkan ile 3D/2D-CAD programı yazılması, line polygon, freeform objelerin oluştutulması. 2. Belli başlı modelleme formatlarında yükleme yapılablmesi, örn. *.obj, *.3ds, *.dae 3. Standart menülerin oluştutu...program arayüzü yapılması 1. OpenGL ya da Vulkan ile 3D/2D-CAD programı yazılması, line polygon, freeform objelerin oluştutulması. 2. Belli başlı modelleme formatlarında yükleme yapılablmesi, örn. *.obj, *.3ds, *.dae 3. Standart menülerin oluştutulması, Yeni, Kaydet, Print, Kes, Kopyala, Yapıştır vb. 4. Undo/Redo Özelliği yapılması. 5. Standart 3D/2D CAD özelliklerinin yapılması zoomin, zoom out, move, rotate, scale v.b. 6. DWG, DXF kaydedebilme özeliği...
Modern and Contemporary Music in Turkey Toplam Kelime Sayısı 1750 Kelime Çalışma içerisinde Başlıklar Şu Şekildedir. 1. Introduction Konu ile alakalı genel bilgilerden ve konu içeriğinden bahseden 200 kelimelik bir yazı 2. Modern and Contemporary Music Bu iki kavramın tanımsal açıkl...paylaşılmalıdır. (300 kelime) 5. Sonuç Çalışma genel olarak toparlanmalı ve sonuç bölümü yazılmalıdır. (200 Kelime) Yazım İngilizce yapılacaktır. Çalışma içerisinde en az 12 kaynak kullanımı yapılacaktır. Çalışma'da grammer ve özgünlük önemli bir yere sahiptir. Çalışma süresi boyunca her 2 saatte bir güncelleme yapılacaktır. Çalışma Bütçesi 120 liradır. Kapak ha...
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.
10 Youtube videos needed on Renewable energy 1. Solar Energy 2. Solar Power Power 4. Wind Energy 5. Green Energy 6. Solar Cell 7. photovoltaic Solar panels 8. Solar Panel Manufacturers 9. Renewable Energy 10. Solar Panels
...notifications, and key metrics for the day. Contents: Summary of check-ins/check-outs, ongoing tasks, alerts, and quick links to other sections. Property Listings Page: Allows property managers to view (individual and all listings), add, and edit property listings. Contents: List of properties with details like name, location, status, and actions (edit/delete). Task Page: Shows all tasks for the day, assigned to different team members. Contents: Task descriptions, assigned team members, scheduled times, and status updates. Assaign Page: Shows all tasks ready to be, assigned to different team members. Contents: Task descriptions, assigned team members, scheduled times. Team Management Page: Manage team members, their roles, and responsibilities. Contents...
...ebook should include fewer than 50 unique alcohol-based cocktail recipes and food dishes. - Recipes should cover a range of spirits and styles, from classic to innovative. - Each recipe should come with easy to understand cooking instructions and accurate measurements. - Include high-quality images and illustrations for each recipe, if possible. - Easy-to-navigate layout with an index or table of contents at the beginning. Ideal Candidate: - Previous experience in recipe writing or food/cocktail blogging. - Strong knowledge of cocktail concoctions and mixology. - Creative writing style that can make the content engaging and entertaining. - Proficient in English with excellent grammar skills. - Bonus if you have experience in food photography or graphic design for ebook layout....
We have two sites on windows server that we would like to move to linux, without having to rewrite code for both sites. The current code is ASP and ASPX (vbscript) with Acess dbase. I am looking for someone that can make our ASP and ASPX pages to work on linux server with mysql dbase. We have a VPS on godaddy server, that we can host the two sites on. You are only qualified if you have done this many times before. You may not use our sites to "try" to do this after doing research, we only want experienced individuals on this.
... * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on target. * Data validation for entry consistency: Ensuring that data is entered correctly, preventing errors. *Eligible to insert in google sheets with same formatting The ideal freelancer for this project should have: - Proficiency in Excel formulas and functions for tracking proj...
I need an experienced full-stack WordPress developer for a quick project turnaround. The specific goal of this project is to develop a comprehensive ...skills Key Project Details: - Enhance the WordPress theme (Avada expert) - Develop unique functionalities based on project requirements - The website is expected to include: an 'About Us' page, a detailed 'Services' section, a diverse 'Portfolio', comprehensive 'Team' information, and compelling 'Testimonials'. - Prepare to develop mostly 15-25 total pages with repeated layouts and different contents Kindly attach your portfolio demonstrating similar projects you've accomplished. This project favors those who provide a quick, efficient, and high-quality turnaround. I apprecia...
Hello I am using an existing Godot addon for a 3D camera and it has great documentation and features. However i can't figure out how to configure it the way i would like it. It currently has a feature to move the camera once it hits the edge of the defined frame in the viewport. But i want it to move in the direction of the mouse position and stop once the player hits the edge of the frame in the viewport. I've attached a photo of the viewport frame feature that is already part of this camera addon. I just want the Camera to then follow the mouse position and only stop if the player is touching the edge of the viewport frame.
I'm seeking an experienced WordPress and WooCommerce professional who can help me with my project. Currently, I cannot move forward from the shipping options, after selecting one option, and placing the order I get a message: "Sorry, this order requires a shipping option." When the shipping option was already selected. Another issue is related to the language, it should be in Spanish, but wocoomerce is showing in English instead If the developer can fix this, there are a few small changes required to the implementation. You can check this on Key requirements: - Expertise in WordPress and WooCommerce: The ideal candidate should have a strong background in dealing with these platforms and resolving related issues. - Theme compatibility resolution: The theme I'm u...
As an en...color palette should be primarily pastel-focused. Ideal Skills: - Graphic Design - Branding - Creativity - Knowledge of Gen Z Trends Experience: - Proven track record in brand development for Gen Z audience - Portfolio illustrating past work with minimalist design and pastel color palettes This opportunity is more than just a design project, it's a chance to shape a brand's identity. You'll move beyond aesthetics and engage with the spirit of the project, capturing what it feels like to break molds while still maintaining a dignified, tasteful, and minimalist approach. This brand is set to target the forward-thinking, fashion-conscious GenZ community, expect your work to be visible and influential across this demographic. Bring your A-game, let's c...
...the final move. The plan is to move to Malaga. Here's what I need: - Thorough simulation of tax implications for a retiree in Spain. including wealth tax - The taxation system's specifics should accommodate an expat receiving pension from their home country. - I'm interested in potentially optimizing my finances to reduce tax liabilities. The perfect freelancer for this project would ideally: - Have a strong background in international taxation, particularly Spain's laws and regulations. - Have previous experience in similar tax simulations or fiscal planning for retired expats. - Be knowledgeable about the nuances of tax liabilities involving foreign pension or retirement income. With these essentials, I'm confident we can structure the best...
I'm specifically interested in a 3D and animated style for this project. The logo will primarily be used on our website and Visiting Card and T-Shirt, so it should be versatile enough to look good in both digital and physical formats. You need to bring logo to life in 3D and in ANIMATION also....it should be moving. Even the name should move, not the tagline. I have made a rough logo, please refer attachment with this project, that's important You can download the logo from this link which has to be used in this project. The background of the entire logo can be in blue colour or in plain white....please show me in both backgrounds. You are free to change colour combinations also of words Galaxy and Resumes. (.Com to remain in italics). ....I want everything
I need a professional and impactful Google Slides presentation designed for an information memorandum. The aim of this presentation is to effectively represent: - Our company's business and main history milestone - Our mission and core values - Our company's business performance data - Our future business strategies A broad understand...the presentation. Expertise in chart and graphics creations within Google Slides would be useful—it's important that the data is easy to digest and visually appealing. A creative outlook would also be beneficial to deliver our strategies in an engaging way and to help articulate our company values. Previous experience in business strategy presentations would be perfect. We will provide all the contents and the data on Google Sh...
Specs: Grid Cells select format 1-the color picker: first time open (no previous coclor selected), defaulted luminance to 50%. If previous color selected, default to that color. 2-the selected color needs to be on the button a...select format 1-the color picker: first time open (no previous coclor selected), defaulted luminance to 50%. If previous color selected, default to that color. 2-the selected color needs to be on the button after first selected. 3-a radio button (format button appearance) for each format type: backcolor, forecolor, bold, italic, underline. same like color, needs to select and change the cell. 4-the cell select needs to toggle the format on and off. 5-checkbox to save the format between reload of grid data source. Bid with 1-22-333 in you ...
I need an adept freelancer with loads of experience in WordPress site design. The job involves updating my current website for a more refreshed look and primarily to modify its content. Despite skipping my preferences regarding design improvement, I'm open to a radical transformation. The ideal candidate would pay rapt attention to: • Website layout and structure: Reorganize contents and make navigation user-friendly. • Colours and fonts: Use appealing, easy-to-read text color and font-size. • Images and visuals: High definition images and engaging visuals are necessary to make the project outstanding. It is important that freelancers provide proof/details of experience in their job application. Creativity, timeliness, and previous experiences with Wo...
...blog content focusing on relevant keywords and SEO best practices. • About Us Section: Revamp the About Us section to be concise, interactive, and visually appealing. • Live Chat Support: Integrate a live chat feature for real-time assistance and guidance to potential clients. • Enhanced Testimonial Page: Improve the testimonial page for credibility and social proof. • Scroll Bar Placement: Move the scroll bar to the top of the website for an immersive viewing experience. • Website Speed Optimization: Enhance website speed with a sleek loader for faster loading times. • Footer Design Update: Revise the footer design for improved aesthetics and functionality. • Technical Optimization: Implement cache management, Google Analytics, meta...
I need a wizard in Microsoft Word for a particular job. The task requires fixing issues related to page numbering and the table of contents in my document. Here's what you need to do: - The documents appear to have page numbering inconsistencies which require correction. - The table of contents needs to be arranged with numerical page numbers. It is worth noting that the document does not follow any specific style guide or template. So, a general understanding of Microsoft Word formatting rules is necessary. Ideal candidates should have: - Mastery in Microsoft Word - Experience in troubleshooting and fixing Word formatting issues - Understanding of different formatting styles (although the work does not require adherence to a specific style guide) This is a quick fix...
...for actionable insights to inform our advertising, promotional strategies, and competitive benchmarking. 2. Project Scope The selected vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer ratings, and associated promotions or deals. • Move systematically from one restaurant to another within each app, ensuring comprehensive data collection. • Extend the data collection across all significant food delivery apps available in the specified city. • Store collected data in a structured format for easy access and analysis. • Conduct data mining to extract meaningful insights from the collected ...
...implementing user login and data fetching features. Ideal Skills: - Expertise in Android Studio and Google Firebase. - Strong understanding of user authentication and data retrieval techniques. Running on a flexible timeline, I am keen to get started on the development as soon as feasible. However, missing data regarding the type of data to be fetched and the purpose of the app will be clarified as we move forward....
I'm a dual citizen in need of an accountant specializing in individual tax filing for both US and Canada. I am a dual citizen of Canada and the USA, having obtained my US citizenship in 2020. Due to a recent move to Arizona and plans to sponsor my wife for her green card, I have discovered the need to file my Canadian taxes with the USA. I require an experienced and licensed accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries o...
I have a mobile app that i need to upgrade and make some changes to. Maybe move it to a cross platform if the price is right.
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 – 300 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 knowled...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
I require a specialized ERPNext DocTypes Builder to manage custom fields and forms. The interface must be designed with admins who don't have high tech background in mind, ensuring it is simple and intuitive. Context: We are a social ecommerce platform that uses an in-house inventory, order, warehouse management systems built by our tech team. Our goal is to move to ERPNext because it's easier to scale there. And also to be able to have our accounting team work there. The goal is separated on multiple phases but the first one and the most important is to build our dashboard on ERPNext by copy pasting what we have in the in-house built dashboard and creating DocTypes. After that, we'll create a new request for the other phases. Key features: - Custom field creatio...
I am looking for a AI developer who can speacilse in 3D Development. I am looking to create an extension for my website whereby I can show injuries a 3D skeleton. The user should be able to Move around the skeleton, click on different parts of the body and information on the injuries should be displayed. This skeleton should be trained on an AI api as the user should be able to also click on various parts of the body. A use case example would be a user clicking on the groin and the application to display a message on what happens in case of injury on the groin and surrounding body parts. The application should resemble something similar to . I have the project half complete I need someone to finish it off whereby majority of the 3D development and 1 injury example is
I'm looking for someone to complete a task with Canva. Producing eBooks. I've already created template and cover for several ebooks, it takes me too much time to move the text from the word document so that’s the job. Ideal Skills and Experience: - Proficiency with Canva - Experience in ebook design - Strong attention to detail This task is straightforward and would suit someone who has experience working on similar projects. Images show the details and example. Looking forward to hearing from you. Jake
I need a professional who can convert a 1-10 page PDF document into a fully editable Word file. The main purpose of this conversion is to be able to easily edit and update the contents of the document as needed. Key requirements: - Conversion of a 1-10 page PDF file into an editable Word document. - Retaining the formatting of the original PDF to ensure the Word file looks professional. - Including images from the PDF into the Word document, maintaining their quality and positioning. Ideal skills and experience for this project: - Strong experience with PDF to Word conversions. - Proficiency in Microsoft Word and a good eye for detail to ensure the final Word file is accurate and retains the formatting of the PDF. - Experience with handling images in Word documents. If you think ...
As the client, I'm looking for an experienced Java programmer to build a stripped-down visual representation of Pacman game mechanics for a basic coding project. Only in Programming 4.3 IDE. Key Functionalities: - Pacman Movement: Program the user's ability to control and move Pacman around the maze. - Pellet Consumption: Pacman should be able to eat pellets within the game. - Ghost Behaviors: Ensure ghost characters are present and exhibit the expected behaviors. Design and Visuals: Design need not be complicated. I require a simple, minimalistic design that effectively communicates game mechanics without overwhelming visuals. Ideal Skills and Experience: - Solid experience in Java programming - Previous experience creating game prototypes would be a plus - A kee...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm looking for a professional who can create job ad templates for me in both Word and PDF formats. 6 ads to copy paste to 6 templates I can share few samples you can use the same to design. All contents, logos, images & similar editable formats will be shared. Will award for the lowest price with reviews.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I need to move my ASP.NET 3.5 application from a 2008 server to a dedicated server. Key Requirements: - Migrate ASP.NET 3.5 application: The current application is running on ASP.NET 3.5 and needs to be seamlessly moved to the new dedicated server. - Hosting Environment: The application should be set up on a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - Server Migration: Proven track record of smoothly migrating applications from one se...
