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

İzmir'de taksitle otomobil satan bir firmayız, ve bir web sitesine ihtiyacım var. Guru adlı bir sistemin APIsini kullanarak araçları sisteme yükleyebilmemiz gerekiyor.

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 Cloud Guru Solutions, profilinizi fark ettim ve size projemi teklif etmek isterim. İstediğiniz ayrıntıyı sohbet üzerinden tartışabiliriz.

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.

...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...

...storytelling and creating valuable content? Join us to develop and execute content marketing strategies that resonate with our target audience and drive engagement. CRO Expert: Do you have a keen eye for optimization and improving conversion rates? Join our team to conduct in-depth analysis and implement conversion rate optimization strategies that enhance user experience and drive conversions SMM Guru: Do you live and breathe social media? As our social media marketing expert, you'll craft engaging campaigns that captivate audiences and drive brand awareness. Email Marketing Extraordinaire: Are you skilled in crafting compelling email campaigns? Join our team to create personalized email marketing strategies that convert leads into loyal customers. E-Commerce Marketing ...

I am seeking a social media marketing guru who can amplify my brand's visibility on Facebook and Instagram. Key tasks include: - Develop and implement a strategic social media plan that increases brand presence and engages with young adults. Skills & Experience: - Proficient in using Facebook and Instagram for brand marketing. - Proven track record in creating engaging content tailored to a young adult audience. - Understands and can use social media analytics to track campaign success and inform decisions. - Background in boosting brand awareness, preferably within a similar audience demographic. The end goal of this collaborative effort is to connect with, and make my brand more visible to, young adults. Solid experience with other brand awareness campaigns is highl...

I need someone who can work via anydesk and fix my issues right now my anydesk is slow so you have to be patient while working.

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.

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

REUQUIRED PERSON TO BE BASED IN PHILIPPINES ONLY! Are you passionate about social media marketing and graphic design? Do you have experience in creating engaging content for e-commerce businesses? If so, we have the perfect opportunity for you!Our clothing e-commerce startup is looking for a dynamic and enthusiastic Assistant to join our team. As we continue to grow, we need someone who can help us elevate our online presence and drive sales through creative digital marketing strategies.**The ideal candidate will:**- Have a strong understanding of social media marketing platforms such as Facebook, Instagram, and TikTok- Be proficient in creating and managing paid advertising campaigns- Possess advanced skills in Photoshop and Illustrator for editing and creating visually appealing content...

Need some one to improve rankings in google search and website traffic

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

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

I am in need of a well-versed Python expert to assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable and expert assistance in these areas.

I’m searching for a talented digital marketing expert with extensive experience across a diverse range of social media platforms. Marketing Platforms: • Focus predominantly on Facebook and Instagram • Expand our brand visibility on Twitter • Establish our presence on LinkedIn and Pinterest • Look into additional unnamed platforms - suggestions are welcome Campaign Goals: To sell my books: And 20 more books to come in the next months. Required Skills: • Proven social media marketing experience, especially with Facebook and Instagram • Knowledge of Twitter, LinkedIn, Pinterest, and other platforms • Strong track record with increasing brand awareness • Expertise in lead generation strategies Profit sharing basis.

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

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

One excel file with macro as per requirement

I'm seeking a proficient Instagram guru to assist with content creation, advertising campaigns, and enhancing follower growth. The primary goals are to boost brand awareness and increase sales; specifically targeting Millennials. Ideal Skills and Experience: - In-depth understanding of Instagram algorithms and advertising - Proven record in growing Instagram followers organically - Proficient in creating engaging, sharable content - Excellent understanding of Millennial consumer behavior Tasks Include: - Content creation that resonates with millennials - Implement strategies for Instagram-ad reach and engagement - Develop follower growth tactics - Analyze and report performance to drive improvements

One excel file with macro as per the customer requirement

Please read carefully then bid I am looking to hire a fresher who has done training in adobe premier pro probably from India. The person hired will be working full time 5 days a week with me and i am looking to pay Rs. 10,000 per month. Type "Full time" so that i could understand that you have read the project I'm seeking an exceptional video editor to refine a 1-5 minutes instructional YouTube video. Their unique transformation of content should result in engaging and smooth visuals that enhance the learning experience of viewers. Key Responsibilities: - Create smooth transitions and coherent flow - Enhance and adjust audio as needed - Implement creative ideas that align with the video's informational purpose Skills and Experience: - Proficiency in Adobe Premie...

...time frame. Ideal candidate should be; 1. Expertise in Trading view 2. Proficiency in Pine script v5 development. 3. Ability to convert indicators accurately and efficiently. 4. Strong understanding of technical analysis and trading concepts. 5. Excellent communication skills, promptness, and attention to details. 6. Open for discussion at the Zoom meeting. 7. Experience of 2-3 years on Guru is preferred. 8. Should be available and ready to start the work immediately. If you have experience with Pine Script v5 and are capable of developing custom indicators with trade signal capabilities, please submit your proposal with details of your past projects, relevant experience and examples of past indicator conversion work. I will only contact the right candidates to d...

I'm in need of a savvy blog writer who can help me create appealing content that focuses on the latest technology trends. This job requires: - SEO expertise: To make sure our posts reach the right people and improve search engine rankings. - Knowledge in technology: You don't necessarily have to be a tech guru, but being familiar with current technology trends and having a genuine interest in the field will be a plus. - Exceptional writing skills: I'm looking for someone who can craft engaging, informative posts that will grab my audience's attention and keep them coming back for more. Ultimately, the aim is to increase website traffic and engage my target audience efficiently. Proven experience in similar tasks will be highly considered. I'm excited to ...

I'm in need of a Wordpress guru who can meticulously comb through my website, inspecting all links, rectifying any errors and improving overall functionality. Key Tasks Include: - Conduct a thorough review of all internal links on every page, particularly focusing on the 'Services' page where I have noticed some issues. - Resolve any identified errors and improve the operational efficiency of the links. - Review a main navigation menu to include the following: 'Home', 'Services', 'Contact Us'. Your input on optimizing the structure and layout of this menu will be appreciated. - Utilize your Photoshop skills for some minor graphics work. Ideal skills for this job include: - Proficient in Wordpress and familiar with its menu structure. -...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...

I'm in need of a detailed-oriented professional who is versed in both web development and social media management. The website is already established, but I will need a lot of further development and enhancement done. This is all surrounding financial content and working with news wire distribution partners and downstream partners. I will need proper posting of news to the site, preferably fed directly into the site once a news event hits the wire, and site maps that are extremely crawl-able. Quality of work, and functionality in the site's design and operation are paramount. On top of that, we need to create from scratch all social media outlets and engagement to go along with press releases we send out, and need help with growing all of that. The successful candidate will ne...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I'm looking for a WordPress developer adept in theme customization. Specifically, your task will revolve around modifying color schemes and layouts. Ideally, you should be proficient at both implementing my ideas as well as offering creative suggestions based on your experience. Key responsibilities: - Modify existing theme's color schemes and layouts. - Balance of implementing my ideas and providing creative suggestions. Ideal Skills: - Strong grasp on WordPress theme structure and customization. - Excellent knowledge in color theory and responsive design layouts. - Ability to interpret and implement client ideas efficiently. - Excellent communication skills and creativity for influential suggestions.

I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

I need a classic ASP developer who can help capture the current page's URL and then have it displayed on the same page. Key requirements include: - **Classic ASP Expertise**: I need someone experienced with classic ASP development, particularly in handling page URLs. - **Frontend Development**: Proficiency in frontend development is vi...same page. - **Problem Solving**: The ability to troubleshoot and problem-solve is crucial; ensuring that the URL is accurately captured and displayed is key. - **Testing**: The successful freelancer should conduct thorough testing to ensure the functionality works correctly before final delivery. This project is a small but critical task for our overall functionality. If you're a classic ASP guru with a keen eye for detail, I'...

I'm on the hunt for an experienced digital marketing guru who can champion marketing campaigns for our natural skin and haircare products. - You'll need to be proficient in: - Social media marketing - Email marketing - Search engine marketing Segmented marketing strategies that resonate with both men and women are crucial. Furthermore, the campaign should incline towards creating brand awareness in our potential customers, driving them towards our line of natural beauty products and converting them into sales. Experience in the beauty or related industries would be a definite advantage. A proven track record in brand awareness and sales campaigns is highly desirable.

As the client for this project, I urgently require an expert in VBA.

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.

**** IMPORTANT **** - Do Not Autobid - I am ready to hire somebody within 48 hours - You should not bid less than 180 days of work for this project - Projects that bid less than 180 days will be ignored - Read the entire project description. There is certain text I am looking for in order for your bid to be considered. If your bid does not have this text, the bid will be ignored - I am not looking to redefine the project terms written in this description. If you are looking to rewrite the project description, do not bid on this one. - The bid on this project should be $2,500 USD. Twenty-one milestones are to be created. Read below for more details. I want to rank in the top three google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - T...