Workbook.worksheets vba 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.
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 have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I would prefer someo...
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 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 in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.
I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...
I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data A...Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an added advantage. If you are interested in this project, please include any relevant experience in...
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...
...data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential for automation: I'm not entirely sure if I want the macro to automatically update the original workbooks if the gro...
...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...
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
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 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).
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 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.
the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book
I am seeking a skilled and experienced content writer or academic writer to create a workbook assignment focusing on Leadership Practices Within Organizations. Key Requirements: - The workbook should be tailored for Undergraduate students. - It should include 3 distinct sections: - Understanding Leadership Practices Within Organisations: 800 words - Analyzing the Impact of Leadership within Organisations: 1500 words - Examining the following aspects of leadership: Leadership styles, Leadership effectiveness, Leadership development. Ideal Candidate: - You should have proven experience in academic writing or content creation with a focus on leadership. - Familiarity with educational materials and the ability to create engaging and informative content for undergraduate ...
I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...
the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...
I need a skilled developer who is proficient in working with Google Cloud...proficient in working with Google Cloud's OCR functionalities. The project involves the following specifics: - File Format: The OCR system should be able to extract text from PDF files, no other formats are required. - Output Format: The extracted text should be converted into a word file and worksheets. - Language Support: The OCR should be able to recognize and extract text in English only. This task requires someone with expertise in Google Cloud's OCR, the ability to generate word files and worksheets, and a solid understanding of language processing for English. High attention to detail and accuracy is crucial for this project. Basic UI is also needed for file management like input...
FARMING DATA Data: Download this Excel Workbook including these 3 tables: ● ○ Prices_Crops_Livestock ○ Production_Crops_Livestock. ○ Land_In_Use NOTE: These tables contain agricultural information for 20 countries and a list of various crops and livestock products. The data is sourced from the Food and Agriculture Organization of the United Nations where you can find definitions and standards. Scenario: Imagine you're a data analyst at a global agricultural organization, entrusted with enhancing worldwide agricultural production understanding. American stakeholders seek a comprehensive view of global farming trends as they evaluate diverse food supply chain initiatives. Audience: American stakeholders. Insights: Address several questions to gain insights about your data
I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used as refe...
...consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attention to detail is a must. - Communication: Regular updates and clear communication throughout the project a...
As discussed I have delivered the excel workbook. Thanks!
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
I need some who could develop the skeleton of an app to generate specif...buttons will be displayed on this screen, Start Again button (starts from the beginning to choose another topic) and Retry button (redo a new test on the same topic) All logic and error checking needs to be done for each question type. The following link provides all the maths type of questions that need to be included, we are only focusing on YEAR 3 questions. I would like to get a MVP for the first 5 categories Place Value, Addition, Subtraction, Multiplication, Division. Please provide cost for MVP and in your reply the rest of the categories. If you have read this brief, please answer the follwing question in your reply. What is the the opposite of UP?
Looking for someone proficient to create the design of my book. It is a book like a workbook or photo album. Book size: A5 (148 x 210 mm) The book consists on: - Introduction - Table of Contents - 100 activities. One activity per page (please see the example attached) - Quotes that intersperse the pages - Conclusion PLEASE READ - PLEASE READ - PLEASE READ Start your proposal with the budget and delivery time
I need assistance with EXCEL- Working with Multiple Worksheets and Workbooks The task is quite urgent, so I need someone who can start right away and complete the project in a timely manner.
I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the system. Proficiency in Excel and background in quality c...
I am in need of an experienced ghost writer to craft a workbook consisting of 50 short activities. The workbook is for late teens age 17-19. The main objective of the workbook is to handle anger management and emotional regulation. Key tasks and outputs: - The activities should be a mix of mindfulness exercises, cognitive behavioural therapy (CBT) strategies, worksheets, journaling assignments, and self-reflection prompts. - The resource should aim to foster critical thinking, improve communication, and inculcate creativity in teens. - The writer should be skilled in working pedagogical theories into content that resonates with teens. Preferred skills: - Ghost writing experience, specifically in emotional health or wellness sector. - Effective communication...
