Vba add numbers 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.

Although the GPS tracking app running on the Android phone shows the GPS device correctly, the app shows the phone's location incorrectly. In order for the application to show the location information correctly, it must get the location from the google maps application, not the phone hardware. When installing the application on the phone, necessary changes should be made to ensure that the application runs in a high priority classroom and the application works without any restrictions when the phone switches to battery saving mode. Actions to be taken: 1-Fix location update error of app 2- Changing app permissions to high priority 3-Ensuring that the application is not affected by battery saving restrictions Turkish language: Android telefonda çalışan GPS izleme uygulaması G...

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

I am using an existing panel. I want to add an additional feature to this panel that I have used. The panel name is opengamepanel. I want to add plugins for counter-strike. Open the plug-in, close the plug-in, there will be plug-in information. That's all I want. price: 10 $ website panel.

Merhaba, Hali hazırda vb.net ile geliştirilen masaüstü yazılımı için, swarm check-in ekleme ve silme modülü yaptırmak istiyorum. Bu modül bir form üzerinde 3 adet buton ve datagridview kullanılarak ekteki görselde ki gibi bir yapıya sahip olabilir. Start check-in butonu, gridview'da bulunan kullanıcıları aynı satırda bulunan mekanlara check-in yapma üzere başlatmak için kullanılır. Stop check-in butonu, tüm işlemleri durdurmak için kullanılır. Delete All check-in butonu, Yapılan check-in'leri silmek amacı ile kullanılır. Tüm işlemler foursquare api üzerinden gerçekleşir

The project is the translation of the document from English to Russian. It's around 4.000 words. Some of them is proper noun and numbers.

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.

Reklam filmine Türkçe altyazı dosyası (.srt) oluşturmak istiyorum. Videonun uzunluğu 11 dakika 44 saniye.

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

Önceki projemizle ilgili süregelen çalışmam var 'Add jquery elements/add interaction to html/css website'

..._________________________________________________________________________________ Company of its employees, Android and Iphone mobile phones when a call comes, instant caller ID, checking to my MSSQL database and show the caller's name, mobile phone screen to show will provide an application we want. In addition, our staff of Android and Iphone Save to phone us as their names and phone numbers in our database snapshot should be saved. Android, iOS app, web service and database design by bidder will be encoded. Truecaller similar but, database belong to us...

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

We have owned for a web page, a different system with 10 user-name, image entry will be provided on a specific subject. 700 photos are required to be on average per week. The site's name and picture to be drawn of the categories will be told after the agreement. Sites like Pinterest are working with. Photos must be of high quality. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sahibi olduğumuz bir web sayfası için , Farklı 10 kullanıcı adı ile sisteme , belli bir konuda resim girişi sağlanacak. Ortalama haftada 700 resim olma zorunluluğu vardır. Sitenin ismi ve resimlerin çekileceği kategoriler anlaşmadan so...

Add links to many different sources about a website. 100 links = 10 USD Belirtilecek olan web sitesi ile ilgili linkleri, internetteki farklı kaynaklara ekleyin. 100 link = 10 dolar

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requir...with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

1. Need a page made for inputting phone numbers in iOS Xcode storyboard with ViewController 2. Need a page made that pulls from an API via AlamoFire and also plays an audio file with each item from the database (array) - also need to add a description field under each item in the array.

Hi there, I have a built Bubble App with Stripe already connected and set up. I need to add a "Cancel subscription" button to the settings page so users can easily cancel their subscriptions.

i have a list of 11,000 car part numbers. need to find the image from each one, if you type the part number in google you'll find the image for that part.

I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses,...

...lifestyle content creator, my main focus is to increase the number of subscribers on my YouTube channel. Key Requirements: - Goal: The primary aim is to develop a strategy to organically increase the channel’s subscriber count. - Skill: You are expected to have experience in growing YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with your detailed proposal. I'm looking for...

I'm looking for a proficient professional who can effectively scrape leads from LinkedIn, Facebook, and Instagram and all over the internet Key responsibilities: * Extracting Email leads, Phone number leads, and Social media leads. * Collecting specific data - Name, Job title, Company, and Location, email and phone numbers Ideal freelancers for this project should have: * Extensive experience in data scraping, especially on the platforms mentioned above. * Proficiency in data mining techniques and possessing advanced analytical skills. * Understanding of ethical data scraping practices. * Strong attention to detail - ensuring all data is accurate and up-to-date. * Proven track record of delivering quality leads in a short timeframe. Get in touch if you're up for the t...

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

I require a straightforward, user-friendly spreadsheet that calculates energy savings based on specific input. My ne...savings based on specific input. My needs are very particular. Here are the key aspects: Input Specifications: - It should only take one input: an initial savings value representing the savings our product offers. Calculation Requirements: - I expect the spreadsheet to perform calculations for both percentage and dollar amount savings. Results Format: - The results should be shown as simple numbers; I don't need them displayed as percentages or any graphical representations. The freelancer fit for the task should be proficient in spreadsheet software and have experience in building similar savings calculators. A good understanding of energy savings would b...

I have a mix of digital and paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and acc...

I have two images of vans, I want to add my logo to both vans on the side of each van and put both vans on one image (adjust the brightness so it looks like they are on same location. And then put them both on a background of a British street location.

I have a set of images with barcodes on them and I need specialized enhancements. Primarily, I'm seeking a freelancer with advanced image processing ca...specialized enhancements. Primarily, I'm seeking a freelancer with advanced image processing capabilities to make my barcodes highly readable. Specific Requirements: - Adjust the brightness of images to improve readability. - Enhance the colors for clarity. - Remove any background noise which may be obstructing the view of the barcodes. The ultimate goal is to make it easier to read the actual numbers under each barcode. As timing is imperative, I require this project to be completed ASAP. Ideal Skills & Experience: - Proficiency in Image Processing and Enhancement - Experience with Barcode Recognition - Excelle...

I've made a significant discovery in the "Distribution of Prime Numbers" that could have a profound impact on the Riemann Hypothesis. I need an academic researcher to assist me in sharing this discovery with institutions like the Clay Institute and others. Key responsibilities will include: - Approaching the Clay Institute and other mathematical institutions to showcase my research. - Compiling a detailed written report that clearly and accurately conveys the implications of my findings. - Ensuring that my research is presented in a manner that is accessible to a wide audience, especially those in the mathematical community. The ideal candidate should have: - A strong background in mathematics, particularly in prime numbers and the Riemann Hypothesis. - Expe...

I've made a significant discovery in the "Distribution of Prime Numbers" that could have a profound impact on the Riemann Hypothesis. I need an academic researcher to assist me in sharing this discovery with institutions like the Clay Institute and others. Key responsibilities will include: - Approaching the Clay Institute and other mathematical institutions to showcase my research. - Compiling a detailed written report that clearly and accurately conveys the implications of my findings. - Ensuring that my research is presented in a manner that is accessible to a wide audience, especially those in the mathematical community. The ideal candidate should have: - A strong background in mathematics, particularly in prime numbers and the Riemann Hypothesis. - Expe...

Looking for a graphic designer who can create a set of modern and minimalist branding graphics for my product. Photos shows the fruit packer robot ...multiple units next to each other. Logo, branding colors and photos of machines in a factory are in the data set. Machine currently have a blue logo sticker. This will be removed and replaced with new branding. Orange should be used sparingly as there are lots of machines in a row next to each other and don't want the branding to be over powering. The front an rear needs a location for an ID numbers (shown in the photos) Clear windows can have some branding but it needs to be subtle and not obscure the view too much. The top of the machine is not visible so does not need branding or minimal branding depending how it wraps o...

We are in need of an experienced Flutter developer to create a robust phone authentication system for our mobile application. The primary objective is to implement a secure and user-friendly authentication process using phone numbers. We aim to streamline the user onboarding experience while ensuring the highest level of security. **Project Scope:** 1. **Phone Number Verification:** - Implement phone number verification using OTP (One-Time Password). - Integrate SMS gateway for sending verification codes. - Handle the verification process seamlessly within the application. 2. **UI/UX Design:** - Design and implement intuitive screens for phone number entry and OTP verification. - Ensure a smooth and responsive user experience throughout the authentication flow. 3....

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...footage of the team carrying out the tasks, but I'm wanting to add some nice looking renders of the plans, which give a top down and front on view of site that aren't just black and white drawings. I've attached some examples of what I'm looking for in terms of the render. Key Responsibilities: - Convert plans into 3D graphics - Realistic rendering of the various layers - Deliver Photoshop layers for ease of integration with video content Task: Ideally you will create the various layers from the plans, and then provide me a Photoshop file with the various layers (For Example: Soil, Pipes, Top Soil, Earthwork markups, Retainer Wall and other significant points marked out on the grass, adding in scale and other important numbers and other key landmar...

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...

I'm looking to leverage Azure docum...financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal Skills and Experience: - Proficiency in Azure document intelligence and training models for document data extraction. - Strong experience in working with a variety of tax and financial documents. - Advanced Google spreadsheet knowledge for exporting and handling the extracted data. - Ability to develop a user-friendly interface for do...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

I'm in need of an experienced WooCommerce developer who can help me integrate a selective product feed from into my WooCommerce website, deripet.ro. This will be focused on products in the "Pets" category. Key Requirements: - The product feed should include all necessary information from the source, such as titles, descriptions, prices, SKU numbers, images, and product availability. - The integration should be seamlessly done and products should be correctly categorized under Same Categorys and subcategory like original on my WooCommerce site. - The integration should only include products from the "Pentru animale" category on and exclude other categories such as Furniture, Home Decor, and Garden & Outdoor. Ideal Skills and Experience: - Proficient ...

I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word ...create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights from t...

I'm looking for a freelancer who can take the annual billing data from my personal business and create a professional, neat invoice from it. Key Details: - Final Format: The fin...beneficial for understanding the context and importance of the data being presented. Please note that I don't need any interactive elements such as clickable links or formulas. The main focus here is on turning the raw billing data into a clear, professional invoice. You're going to take a simple excel file with customer data and account numbers and create an easy to understand, simple annual billing invoice/income statement with my company logo on it. Account numbers will be redacted except for a unique 4 digit code at the end. There won't be endless re-writes. I'll be...

I am currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project is crucial for our s...

I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content - Strong communication skills to understand any addition...