Vba increment column 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.
Günlük devir satırını değiştiriyoruz ama günsonu alınca başka bir değer günlük devir satırımızı değiştiriyor. Bunu çözecek birisini arıyorum
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.
Merhaba Kadir bey Web sitesi için sıfırdan görsel çalışması yetenekli tasarımcı arıyoruz, ilgilenir iseniz, detaylar aşağıdaki gibidir Fiyat Görüşülülebilir İhtiyaç...ikinci ise Fantazi Erkek Kampanyası için slider, Kampanyalar ile alakalı bilgiler verilecektir, Ebatlar (775x455) 3) Kategori Bannerları, Sütyen Kategorisi, Büyük Beden Kategorisi, Ev giyim Kategorisi (380×455) 4) Kampanyalar bannerları, Özel Fantazi İndirimler, Özel Sütyen Kampanyası (Toparlayıcı), 770×400 5) Kategori Ekstra Bannerlar, Ana kategori alt menüsü html 12 column dır, 3 column kategoriler için olur, 9 column ise bu kategori ile görseli bozmadan tamamlayıcı bir görse...
Merhaba Web sitesi için sıfırdan görsel çalışması yetenekli tasarımcı aranıyor İhtiyaç olan görseller 1) Logo (orijinal dosya 250 x 100 px Export edildiği zaman tam...ikinci ise Fantazi Erkek Kampanyası için slider, Kampanyalar ile alakalı bilgiler verilecektir, Ebatlar (775x455) 3) Kategori Bannerları, Sütyen Kategorisi, Büyük Beden Kategorisi, Ev giyim Kategorisi (380×455) 4) Kampanyalar bannerları, Özel Fantazi İndirimler, Özel Sütyen Kampanyası (Toparlayıcı), 770×400 5) Kategori Ekstra Bannerlar, Ana kategori alt menüsü html 12 column dır, 3 column kategoriler için olur, 9 column ise bu kategori ile görseli bozmadan tamamlayıcı bir görsel olmalıdır, To...
tabloda aradığım özellikler= 1) kolonlarda genişletip daraltabilme özelliği olmalı (resize) 2) kolon yerleri birbiriyle yer değiştirmeli (column drag and drop) 3) kolonlardaki bilgiler Alfabetik sıralamaya göre sıralanabilmeli (sortable) 4) satırlar yukarı veya aşağı yer değiştirebilmeli (row drag and drop) 5) tablonun sağında solunda boşluklar olmalı, örneğin bootstrap grid mantığı ile düşünürsek, container row tablonun sol tarafı: col-md-3, tablonun yerleşeceği alan: col-md-6 tablonun sağ tarafı: col-md-3 tablonun altında ve sağında scroll bar olmalı (scroll x bar ve scroll y bar) 6) yukarıdaki işlemlerde, sayfaya yeniden gelindiğinde, tabloyu nasıl bıraktıysan aynı şekilde gelmeli 7) satırı ve kolon sayısı sınırsız olmalı
merhaba, c# asp.net(veya mvc) + signalR + sql server tabanlı bir websocket sistemi yaptıracağım. İnternette mevcut örnekler var. Bir adet sql server veritabanı ve içerisinde 2 adet tablo olacak. tabloda 7-8 tane varchar, int, bit şeklinde columnlar olacak. c# içerisinden tasarımı yapılaca...7-8 tane varchar, int, bit şeklinde columnlar olacak. c# içerisinden tasarımı yapılacak(asp.net, html veya mvc). veritabanına connectionstring ile bağlanacak. tasarımı yapılan arayüz ile veritabanına değer gönderecek, ayrıca veritabanında herhangi bir değer değiştiğinde angularjs sayesinde tüm clientler anında güncellenecek. Sistem angularjs yapısında yapılacaktır. veritabanında değişen column diğer clientlere gönderilecek. d...
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
...want to see this extra fiels, ( Phone Number, Email, Name Surname, City Plate No, Label No, ) under the Ticket info Tab. --- TICKET DETAILS --- --- TICKET LIST --- When i click to ticket list i want to see this titles ID, Name Surname, Plate No, Province, You can see the search box on top right. All extra feilds can be searchable, for example when i write the new column plate number. I want to see result or phone number or name. Please add all extra columns to search array. --- TICKET LIST --- When clients creating a ticket client, can select "Mark ticket as closed" (Normally this option only visible on Ticket reply page.) You can put this radio button (Mark ticket as closed) or instead of this button you can put Submit and Close ...
VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.
...me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA shift and 2 middle shifts, i want a r...
...that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-down list. They should be able to start typing the name of the exercise and the drop-dow...
3D modeling of a villa in Revit: 1. Copy architectural model to construction: - Levels - Axes - Columns - Walls - Ceilings 2. Adding column sections - Wall sections - Beam sections 3. Connecting columns to ceilings 4. Linking beams to levels 5. Openings: windows and doors 6. Tables of quantities for concrete + blocks + iron.
Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.
I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is only sample data.
I currently have a PHP script that echo's the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob bris...
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.
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 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.
...integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images when clicked. The CSV files must be Shopify-compatible ...
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...
...Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - 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: - ...
...edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and movement pattern columns are not as important but if you could also select them that would be great. If there is equipment clearly used then select it from the dropdown, it is likely to only be Dumbbell, Barbell, Bench or Resistance band
Only FTP will be provided. Link 1 column with another table. and amend existing API only
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.
...the capabilities of multiple open source projects. The exact projects requiring development haven't been specified, but the key components will include: Brief description: Members can also upload items (only to designated columns set by administrators). Assumption: The administration will set up a category column—Card Trading. Members who log in can upload related items to sell, but only to that column; they cannot upload to other columns. Let's break it down step by step: User Column: Modify the administrator's product management template. The administrator will set up a category, such as the Card Trading Market. Then, all items uploaded by users will be categorized under this classification. To purchase items in this category, users must...
I need to liquidate (sell) ) some the goods in Manila, need someone with experience in liquidation this information and quantity: The price we liquidate is given in column G, This is a very cheap price compared to the price I imported, and I guarantee it is the cheapest in the wholesale market Currently the goods are in my warehouse in Manila, please contact us for more detailed discussion
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.
Project Duration: 1 Hour Project Type: Python Script Modification Project Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an e...Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an existing Python script that allows us to upload a CSV with two columns: Prompt Output The script then submits each “Prompt” to the OpenAI API, inserts the output into the “Output” column. We would like one change made to the existing script. Change Required: We would like to add one more column to the CSV file, “Id”, it will be the first column. We use “Id” as our own reference number for the row This column and its value should be...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or autom...word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the pr...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or autom...word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the pr...
...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...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only....document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the pri...
Need an Excel combinations generator that can generate combinations into a list from multiple numbers. Need an input, numbers will have commas between them, for example (9,12,21,22,29,40). Input numbers 6* and need output of 3 numbers. the result should look like this list. Have the option for output, how many numbers of combinations to choose from. input can be up to 20 num...21,29,40 22,29,40 5,18,30 5,18,41 5,18,46 5,18,52 5,30,41 5,30,46 5,30,52 5,41,46 5,41,52 5,46,52 18,30,41 18,30,46 18,30,52 18,41,46 18,41,52 18,46,52 30,41,46 30,41,52 30,46,52 41,46,52 11,14,19 11,14,33 11,14,44 11,14,54 11,19,33 11,19,44 11,19,54 11,33,44 11,33,54 11,44,54 14,19,33 14,19,44 14,19,54 14,33,44 14,33,54 14,44,54 19,33,44 19,33,54 19,44,54 33,44,54 Results should all be in one column with ...
...comprehensive report I can present with confidence. Note* 1).The PASNAP ( Union name) 2023 LPN & RN spreadsheet shows the license years (years of experience if you will) and shows both salary in 2023 and current salary in 2024 2).The FA (Fair Acres nursing) leadership file highlights all Nurse supervisors/managers ( uses this for comparing salaries. (also note their start dates are listed in column "O") 3).The Fair Acres employee list is a list of all employees. I've highlighted in "green" & "pink" the LPN nurses and the RN nurses ( nursing category employees notes on file) you are to compare the .The FA (Fair Acres nursing) leadership file and the Fair Acres employee list (pink & green). This is the data you will be worki...
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
I am working with GridCore library from .NET Core. I am having issues getting the column headers to be displayed with the filters added. Now, I am only able to display the column headers titles. I need someone that has proven experience using this library and can give me the solution.
One excel file with macro as per the customer requirement
...the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It ...
...supports and deflection check. Additionally calculations for one timber post (probably glue-lam) determining the demand stresses making sure the bending stresses about y and x axis are both 0, determine strength capacity (design for compressive and bending strength) check cross section resistance adequacy and check member stability Finally with a rough working out to calculate the transfer load of column needed for a clay stiff pad foundation in my design Skills & Experience: - Proven civil engineering background with a heavy bias on structural design - Proficiency in load calculations - Extensive experience in material specification - Sound understanding of technical manuals and structural design - Superior problem-solving abilities Involvement in similar projects in ...
