Vba conditional formatting 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.

I need a skilled typist who is adept at converting scanned PDFs into editable Word docs. Key Project Details: - File Format: The final Word documents should be saved as .doc files. - Formatting: It is crucial that the original layout and formatting of the PDFs are meticulously preserved in the Word document. This includes text placement, font size, and styles. - Document Type: The PDFs are primarily scanned images, and thus the successful candidate should have experience with Optical Character Recognition (OCR) software and techniques. Skills and Experience Needed: - Strong typing skills with high accuracy and efficiency. - Proficiency in OCR software and techniques. - Experience with PDF to Word conversion, especially with scanned images. - Excellent attention to detail t...

...data in question does not specifically have to be text, numeric, or multimedia, as I have not stated a preference. However, I need it presented in CSV format for my review and analysis. Key duties include: - Assuring the secure and rapid downloading of data files. - Properly formatting the data into CSV files for easy accessibility and comprehension. The ideal freelancer for this job should possess: - Strong knowledge of data management. - Proficient skills in handling various data types. - Expertise in CSV formatting. - Exceptional skills in file download mechanisms and data security. This task requires a detail-oriented person who can accomplish tasks accurately and in a timely manner. It would be perfect if you are familiar with multiple data types and can handle ...

I'm seeking an experienced video editor to create short form like produced by natt jongsala. The videos will be less than a minute long and should be tailored for Instagram. Key Requirements: - Video Duration: The final videos should be less than a minute in length. The ideal candidate would have experience in creating e...this platform and a good understanding of Instagram's video editing requirements is essential. Applicants with a portfolio showcasing previous work on Instagram or similar platforms will be given preference. Skills & Experience: - Proven experience in video editing - Specialization in short form content creation - Proficiency in fast-paced editing styles - Familiarity with Instagram's video formatting and requirements Looking forward to see...

I need a professional to type up a series of text documents and apply basic formatting to them. The final deliverable should be a Word document. This work is straightforward, but I'm looking for someone with strong attention to detail and a keen eye for accuracy. Ideal Skills: - Proficiency in typing and formatting - Prior experience with Word documents - Ability to maintain high level of accuracy - Understanding of confidentiality Please note that the content is not complex, but I do expect a polished and professional final result.

I want to design a vba code where i can send text or whats app message

I'm looking for a freelancer who can convert a PDF document with less than 50 pages into a text document. Key Requirements: - The document has to be copied with exact formatting. - The content is in English. The ideal candidate should have experience with: - Copy typing - PDF conversion - Basic document formatting Note: Please make sure to detail any relevant experience you have in your bid.

...needs. - The output file format must be in PowerPoint (.pptx) format. - The pages must have professional photos and nothing else. - it must look good also after conversion to PDF format Ideal Skills: - Proven experience in creating professional and modern presentation templates. - Proficiency in graphic design and understanding of color psychology. - Strong knowledge of PowerPoint design and formatting. - Understanding of corporate branding and ability to translate that into a presentation template. Please provide a sample of your past work or portfolio to showcase your relevant experience. Your ability to meet our requirements, particularly in terms of minimalist design and blue color scheme, will be a key factor in our selection process. Please note: I had another person tr...

I have a collection of scanned PDF legal documents that need to be accurately typed into Word. The documents require double-spacing and indented paragraphs. Ideal Skills & Experience: - Proficiency in legal terminology and language - Experience in legal document formatting - Strong attention to detail - Ability to transcribe from scanned PDFs accurately - Proficiency with Microsoft Word and formatting tools Your work will be instrumental in bringing these important legal documents into a more accessible and editable format.

I'm in need of a skilled individual who can efficiently convert a series of PDF documents to Word format. The key requirements and considerations for this project are: - **Primary Focus**: The main reason for...Handling**: It's important that the images and tables within the PDF are editable once converted to Word. So, the freelancer must have the capability to convert these elements in a way that preserves their structure and allows for easy editing. The ideal candidate for this task should have prior experience in PDF to Word conversions, particularly with documents that have mixed content and complex formatting. Proficiency in handling images and tables within Word documents is a must. I'm looking for a professional who can deliver accurate and editable Word docu...

I am in need of a meticulous freelancer to assist with my data entry needs and formatting business reports. The primary task is data entry, which involves inputting various data into our system. Additionally, I require assistance with formatting business reports in Microsoft Word. Key Requirements: - Proficient in data entry with high accuracy - Skilled in Microsoft Word with an eye for detail - Experience in handling business reports would be a plus Ideally, I am looking for someone who can complete this task efficiently and with a high level of accuracy, given the importance of the data. This job requires excellent attention to detail and good time management skills.

I need a meticulous typist for a job that will take between 1-3 hours. The source of the text is a PDF document. The document must be formatted according to the MLA style. Key Requirements: - 1-3 hours of your time - Ability to transcribe directly from a PDF file - Familiarity with the MLA style guide Ideal Skills & Experience: - Proficient in typing with a high level of accur...style. Key Requirements: - 1-3 hours of your time - Ability to transcribe directly from a PDF file - Familiarity with the MLA style guide Ideal Skills & Experience: - Proficient in typing with a high level of accuracy - Prior experience with transcription or typing work - Familiarity with academic writing styles, particularly MLA - Strong attention to detail and ability to follow specific formatt...

...using the given ChatGPT prompts, with the expectation to refine and fine-tune these prompts for optimal results. - Illustration: Create one AI illustration for each story using DALL-E, based on given or self-developed prompts. - Image Editing: Refine illustrations in Canva Pro, focusing on correcting imperfections like extra fingers or blurry characters. - Formatting: Assemble text and illustrations in Google Docs, following a specific formatting style. - Preparation for Publishing: Convert documents to .docx, produce book descriptions and subtitles using ChatGPT, and prepare for publishing using Kindle Create. - Daily Output: Aim to produce three books daily, each containing five stories, to meet a monthly target of 90 books. Skills Required: - Writing and Editing: Excep...

...content is accurately transcribed. The PDF is not image-based, so the main challenge is maintaining the accuracy of the text. - Basic formatting should be preserved. However, please note that I'm not looking for an exact replication of the PDF's layout; a clean and readable Word document is what I'm after. - The PDF contains some images that need to be included in the Word document. These images are an integral part of the content, so they should be kept in their original form. Ideally, I'm looking for a freelancer who has experience in: - Data Entry: The project involves transcription of textual content from a PDF to a Word document. - Microsoft Word: Basic formatting skills in Word are necessary to ensure that the final document is polished and prof...

I need a fluent, efficient typist to convert an English PDF into an doc -formatted Word document. Requirements: - The primary task is to convert the text from the PDF into a Word document. The original PDF is in English. - The Word document must be formatted in doc st...PDF into a Word document. The original PDF is in English. - The Word document must be formatted in doc style. Familiarity with this style is a must. Pdf file must be typing and i need word .doc file . The PDF does not contain any tables but does include images. These images need to be included appropriately in the Word document. Ideal Skills: - Proficient typist - Strong understanding of APA formatting - Experience with incorporating images in Word documents Please provide a brief description of your relevant e...

I need an experienced freelancer who's highly skilled in Microsoft Word formatting. The task involves formatting a short document of 1-10 pages to match the style of another document. Your main duty will be to change bulleted and numbered lists to resemble that of the document I'll provide. The hierarchical structure of these lists in the current document is similar to that of the reference document, making it a fairly straightforward project. Ideal candidates will have significant experience in content formatting, outstanding attention to detail, and a knack for preserving the integrity of document structures. Proficiency in using MS Word is a must.

...professional milestones and proficiencies, I am seeking an expert who can significantly enhance the formatting of my resume. The job involves the following: - Improving the arrangement of different sections including work experience, education, skills and additional information. - Closely reviewing the current setup of these sections and providing suggestions on how they can be better structured. Though I did not specify particular formatting changes, I welcome innovative ideas on improving general layout and design, including but not limited to fonts, sizes, and margins. I envisage that the ideal candidate for the job is someone who has a proven track record in resume writing, formatting and design. They should have a keen eye for detail, an understanding of mod...

**Overview:** Seeking a Virtual Assistant with expertise in Romance languages to help translate and format documents. Proficiency in ChatGPT-4, Microsoft Word, and PDFs is essential. **Responsibilities:** - Translate and mirror format documents into Romance languages. - Use ChatGPT-4 for translation assistance and editing. - Handle document formatting in Word and PDF. **Qualifications:** - Linguistics major, specializing in Romance languages. - Skilled in Microsoft Word, PDF editing, and ChatGPT-4. - Excellent grammar and punctuation skills. **Pay:** - $3.00 USD/hour

I'm looking for a proficient web scraper who can extract text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached exce...

I'm having trouble with fixing a few errors in Latex. The error should be fixed with a specific list of packages. A knowledgeable hand with substantial experience in LaTeX is needed to quickly and effectively fix and check the rest of the errors, if any, in the document. Familiarity with text formatting in LaTeX is crucial. There are about 25 errors that need to be fixed. ! Misplaced noalign. bottomrule ->noalign {ifnum 0=`}fi @aboverulesep =aboverulesep global... l.577 } ! Missing } inserted. } l.577 } ! Missing } inserted. } l.577 } ! Missing cr inserted. cr l.577 } ! Undefined control sequence. @BTrule ...doublerulesep fi fi fi @BTswitch l.577 } ! Misplaced crcr. crcr l.577 } ! Extra }, or forgotten $. endtabular ->crcr egroup egroup $egroup l...

I'm having trouble with fixing a few errors in Latex. The error should be fixed with a specific list of packages. A knowledgeable hand with substantial experience in LaTeX is needed to quickly and effectively fix and check the rest of the errors, if any, in the document. Familiarity with text formatting in LaTeX is crucial. There are about 25 errors that need to be fixed. This needs to be done in 2-3 hours after accepting to the project, so please make sure of that. ! Misplaced noalign. bottomrule ->noalign {ifnum 0=`}fi @aboverulesep =aboverulesep global... l.577 } ! Missing } inserted. } l.577 } ! Missing } inserted. } l.577 } ! Missing cr inserted. cr l.577 } ! Undefined control sequence. @BTrule ...doublerulesep fi fi fi @BTswitch l.577 } ! Misplaced ...

I'm in need of a translator to convert a short and simple Arabic document to Turkish. It's a general text, approximately less than 1000 words. It's just a standard text without any specific formatting requirement. Skills/Experience required: - Proficient in Arabic and Turkish - Experienced in translating general texts - Attention to detail

Objective: Refine and finalize the Quality Assurance Manual almost 50 pages, ensuring it is professionally formatted, coherent, and ready for publishing. The manual must meet strict compliance standards and be visually consistent throughout. Scope of Work: Layout and Formatting Adjustments: Ensure uniform font type and size across the entire document. Preferred font: Times New Roman, 12 pt for text and 14 pt for headings. Adjust paragraph alignment, spacing, and indentation for a clean and professional look. Implement consistent heading styles to differentiate sections clearly (Heading 1 for section titles, Heading 2 for sub-sections, etc.). Header and Footer Configuration: Set up a dynamic header on each page using a table format to include: Section number and title. Document r...

I'm looking for a talented designer who can create a promotional poster with a photographic design. The poster will include text and graphics and should be visually appealing and engaging. For the book typing part, I need someone who is meticulous and accurate in typing. The book is of moderate length and standard formatting. Ideal Skills & Experience: - Proven experience in designing photographic promotional posters - Proficiency in using graphic design software - High attention to detail and accuracy for book typing - Good understanding of typography and layout Please apply if you have the relevant skills and feel confident you can deliver a high-quality design for the poster and accurate typing for the book.

...1. **Designing T-Shirt Graphics:** - Create original and appealing T-shirt designs that resonate with North American (Canadian and American) audiences. - Understand current trends and incorporate them into designs. - Provide design mockups for approval and make necessary revisions. 2. **Print Management:** - Prepare and upload approved designs to Printify.com. - Ensure correct formatting and specifications for printing. - Manage the product listings on Printify and ensure seamless integration with our online stores. 3. **Online Store Management:** - Add new T-shirt designs to our online stores (Shopify, Etsy, etc.). - Write compelling product descriptions. - Ensure product listings are optimized for search engines (SEO). 4. **Marketing and Promotion:...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a professional who can perform a straightforward text extraction and formatting task. The job involves transforming a basic PDF document into a fully editable Word file, ensuring that all textual content is accurately transferred while keeping the original layout and formatting. Key Requirements: - The PDF document is solely text-based, without images, tables, or complex graphics. - You should be proficient in PDF to Word conversion, maintaining layout and formatting. If you're detail-oriented and have experience with similar tasks, I look forward to your proposal.

...fonts like Open Sans, Roboto, or Helvetica Neue (open to suggestions). - Look and feel: Modern, fresh, professional, clean. - Imagery: Template will incorporate icons that complement the overall design. File / Compatibility: - Final template to be delivered as pptx & potx. - Files generated should be compatible with Google Slides. Ideal Skills and Experience: - Strong PowerPoint Design and Formatting Skills - Experience in Creating Templates for Corporate Use - Ability to Work with Specific Brand Guidelines Copyrighted material must not be used nor should primarily AI generated templates. Next Steps: If you're confident in your ability to meet these requirements, I'd be particularly interested in seeing examples of your work in creating presentation templates ...

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You should...

I'm in need of an experienced illustrator to help with my project. I have 10 modules of Yoga Teacher Training Powerpoints which have used available images from internet searches. I would like ...At a high level, you'll need to: - Design and create illustrations for 10 sets of PowerPoint slides - Ensure the illustrations are minimalistic, yet specific to the theme of yoga. The illustrations should include: - A variety of yoga postures and techniques. Ideal candidates will have: - Strong illustration skills, especially in creating specific themed content. - Experience with PowerPoint formatting. - A portfolio that demonstrates their abilities in creating minimalistic artwork. Note: In the example Module, books and DVDs etc. do not require changing. YogaTTS logo will als...

I'm currently looking for a professional to help me upload my book on Amazon KDP. The book is self-authored, but I'm unsure about the format - it might be a Word document, PDF, or EPUB. I need assistance with formatting the book for Kindle, as well. The ideal candidate for this job should: - Have experience with the Amazon KDP platform - Be familiar with formatting requirements for Kindle - Have excellent attention to detail - Be able to work independently - Have strong communication skills

I'm looking for a skilled Wordpress developer to help me make some necessary corrections to my webpage. The main tasks include: - Layout adjustments: The front page requires some minor visual modifications, and the shop visuals need to be aligned with the overall theme. - Content editing: I need help with both the banner design and formatting. The ideal candidate should have a solid grasp of Wordpress and be comfortable working with: - Layout customization - Front page design and adjustment - Graphic design for banners I'm open to suggestions for improving the user experience of my webpage but the changes will need to be minimal and in line with my brand's aesthetic.

I'm seeking a freelancer to meticulously enter and format data into a PowerPoint slide. The slide will contain data Key Resp...enter and format data into a PowerPoint slide. The slide will contain data Key Responsibilities: - Efficiently enter multiple paragraphs of data into a PowerPoint slide - Work with a pre-existing, detailed design to ensure formatting is consistent and visually appealing - Attention to detail is critical as the data must be accurately transcribed Ideal Freelancer: - Proficient in Microsoft PowerPoint - Superior data entry skills - Excellent attention to detail and design consistency - Strong written communication skills to ensure accurate transcriptions and formatting. Please note, this task requires a high degree of precision and adherence t...

...websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of detail. Excel: Analyze Data with Tables and Conditional Formatting Position: Virtual Assistant (VA) from Phillipines. Location: Remote Type: Long-Term Ongoing work (Not ...

...well-versed in Wikipedia's policies and guidelines to help me with the following: - Writing and enhancing the content: Even though 80% of the information and links are ready, I am looking for someone to polish and enrich the existing content to ensure it is comprehensive, engaging, and aligned with the reputation management goals of the project. - Formatting according to Wikipedia's guidelines: It's crucial that the article meets the specific formatting requirements of Wikipedia to guarantee that it is published and maintained on the platform. Therefore, the ideal candidate should be well-versed in these guidelines. - Adding references and external links: To further solidify the credibility and authenticity of the article, I need an expert who can add relev...

I have handwritten notes that need to be entered into a Word document. Key Requirements: - Data Entry: The freelancer will be required to accurately transcribe the text data from the handwritten notes into a Word document. - Formatting: The data needs to be entered in a clear and organized manner, with appropriate paragraphing and alignment. Ideal Skills: - Proficiency in English: A good understanding of English language is necessary to ensure accurate transcription. - Typing Skills: Fast and accurate typing is essential to complete the task within a reasonable timeframe. - Attention to Detail: The ability to closely follow the source material and input the data with precision. - Microsoft Word: Familiarity with Word is important to ensure the data is entered and formatted correc...

I'm looking for someone to convert my 1-10 page PDF document into a Word file. Here are the project specifics: - **Word File**: The final Word file s...looking for someone to convert my 1-10 page PDF document into a Word file. Here are the project specifics: - **Word File**: The final Word file should maintain the original formatting of the PDF. - **Content**: The PDF is text-only, with no images or graphics that need to be transferred to the Word document. The ideal candidate for this project should have: - Experience in PDF to Word conversions. - Proficiency in preserving original formatting during conversions. - Attention to detail to ensure all text is accurately transferred. Please bid if you're confident in handling this task with precision and meeting t...

...such as a product comparison feature Ideal candidates should demonstrate prior experience working with Elementor and e-commerce websites. Evidence of handling scripting challenges in e-commerce would be necessary Note: This is an outline of the requirements, very simple, and fast but may require some scripting in a Flex container for "Price" Three images are easy to follow through. Page 1 formatting, aligning with a possible Price tag in Flex container with scripting that sends price forward to checkout when link button "get started" is hit and page 1 linked to page 2 "Property info" and creates a blank form with about 20 fake tags that we will name and a link button to checkout (page 3 ) where the price is awaiting customer for payment see attac...

I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.