Vba sheet işler
Firmanın start up ında P&L , Balance Sheet , Cash flow hazırlama Konu hakkında tecrübe sahibi finans konusunda uzman destek gerekli
Hi, we have a small group of stock exchange advise followers. We need user administrations on our website. We have some tables at Google Sheet, and they are perfectly good for us. We need to publish that tables real time on our website and mobil applications which are needed to create bottom to top. Merhaba, Küçük Borsa yardımlaşma grubumuzun web sayfasını oluşturacak, kullanıcı erişim yönetimini geliştirecek, mobilde de paralel şekilde nispeten sade bir uygulama geliştirecek bir arkadaş arıyoruz. Sistem zaten Google Sheet üzerinde çalışmaktadır ancak daha profesyonel bir düzeye geçmek istiyoruz. Alt yapı ve iş modeli hali hazırda kurulu bulunmaktadır. Yardımcı olabileceklere şimdiden teşekkür ederiz.
...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.
Uzun yılların verdiği tecrübe ile progesif ve tandem kalıp dizaynı process dizaynı ürün analizi gibi konuları işleyebilirim tekliflerinizi bekliyorum
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.
stok takibi yapabilmem için gerekli olan web arabirimini yazdırmak istiyorum, web sitesine girdiğimde barkod okuyucu ile ürünleri tanıtıp giriş çıkışlarını Google sheet üzerinden yapabileceğim bir arabirime ihtiyacım var.
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
metal solıd sheet de cızım yaptırmak uzere elımızde 25 adet urun var bu urunlerın teknık cızımlerını yaptırmak ıstıyoruz urunlerımız oto hava fıltresıdır cok basıt teknık cızımlerı yapılcak
VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.
I have a detailed list on an Excel sheet that I need converted into an organizational chart. The chart needs to include information like 'Grade', 'Nationality' and 'Occupation' and display them in a visually appealing format. Key Requirements: - Convert an Excel sheet which consists of approximately 140 line items into an organizational chart. - Display the following information in the chart: 'Grade', 'Nationality' and 'Occupation'. - Create visual lines connecting positions to indicate the reporting relationships. - Provide the final output in both PowerPoint and Visio formats. Customization: I am looking for a moderate level of customization in the design of the organizational chart. This includes playing wit...
Need virtual assistant for collect email address and phone. New freelance welcome. See Google sheet and make sample 10 pcs. And put your name
I require a freelancer to assist with a one-time copy typing project. The task involves entering data from a single document into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy typing - Proficient in Excel - Attention to detail and accuracy - Previous experience in similar projects is a plus.
The aim of the system will be to develop a system where you can capture staffs performance on a daily basis and make notes as needed. Under the reporting section you will then be able to select an employee and date range and view any offenses that was made by the employee. Portal will consist of: 1. Work Category: This is where you can create the various categories in your business. We will...and click on FILTER to search We then show all employees who has infringements under this category for the date range and categories. Sample Layout 5.2 Infringements by Employee: Fields to start will be Select Date Range Select Employee and click on FILTER to search We then show the specific employee with their infringements Sample Layout All reports in 5.1 and 5.2 can be exported to XLS ...
I need an iOS app developed that allows for data entry, spreadsheet viewing, and data manipulation. The design should be colorful and vibrant to make it visually appealing, yet s... yet simple to use. Authentication will not be required as all data should stay on the device, ensuring privacy. I need to get a finance tracker for all my personal accounts. I need a place to input values from banks, fund houses, sips etc, which would be stored in the file and give me nice dashboard of my funds, current and previous month comparison and growth calculations. I already have a sheet that I use, which can be a starting point. Ideal Skills: - Swift or Objective-C programming - UI/UX design with an eye for vibrant color schemes - Experience with data manipulation and presentation on mobil...
I'm looking for an expert to scrape data from a website. I will provide the list of data (approx. 16K entries) that will be entered into the search bar and I need 2 fields extracted from each search into an excel sheet. This will be a one-off scrape of the website.
I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as you help me define the righ...
...products. I'm attaching some examples of task below. Will discuss more things on Zoom meeting. You will be provided a list with the name and images of products and you will need to assign them 1 or multiple keywords based on what kind of product it is. Like in the sheet (link attached) under "Smart Collections" You can see all of the tags we have. You will select related tags from this sheet. And "Sheet1" shows the names of products and how the final tags will look like. I did first entry for you to understand the task. Sheet link is here: There are much more products and much more other tasks for you to do. We need 6 freelancers and we will pay per hour. 1$/hour. And we have own tracking
Description: I need an app (iOS) to automate data entry into a Google Spreadsheet used for my car rental business. Each tab in the spreadsheet represents a specific car. The app should allow employees to: Select a car category (corresponding to a tab in the spreadsheet). Select a rental date. Input various amounts (e.g., rental income, expenses). Automatically update the corresponding tab in the Google Sheet with the provided data. Requirements: Experience with Python and Google Sheets API. Ability to create a user-friendly interface. Strong understanding of gspread and oauth2client libraries. Good communication skills and responsiveness. Deliverables: A functional app that performs the required operations. Documentation on how to set up and use the app. Support for initial setup...
I'm in need of a Progressive Web Application (PWA) for collecting survey responses towards an onboarding process. The application will feature: - A mixed set of survey questions, including both multiple choice and open-ended questions. - Responses will be sent to a Google Sheet for easy management. - Integration with a payment gateway after the survey for users to proceed with payment. - Survey responses should not be anonymous. The ideal freelancer for this project should have experience in developing Progressive Web Applications (PWAs) and integrating them with Google Sheets and online payment gateways. They should also be able to implement a mixed survey layout and ensure that the survey responses are not anonymous.
I'm looking for a skilled digital marketer to complete a comprehensive two-month social media campaign including complete analysis, keyword targeting, off-page SEO, and social media optimization activities. Your duties will include: - Weekly posting on various, yet unspecified, social media accounts - Creating promotional backlinks - Submitting weekly updates in an excel sheet Despite the target platforms and audience not being specified, the ideal freelancer should have a broad understanding of various platforms (including but not limited to Facebook, Instagram, and Twitter) and be able to adapt to varying target audiences. The primary goal of this campaign remains undefined, so a flexible approach to either increasing brand awareness, generating leads/sales, or buildin...
I'm in need of an expert who can fix a google script for me. This script connects with an external web service API that provides data and populates specific columns of a Google Sheet with the parsed JSON data. Lately, it has been throwing up an error: Address unavailable:(Code: 63:32). I haven't made any changes to the API or Google Sheet recently, so I am unsure as to why this is occurring. I would appreciate it if a proficient Google Scripts and API specialist could look into this matter and fix the issues that are leading to this error. Ideally, I am looking for someone who: - Is well-versed with Google scripts - Has a good understanding of APIs, especially ones related to external web services - Can troubleshoot errors effectively and efficiently Looking for...
...Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to match the row of the card on the sheet * The project will not be considered delivered if there are inaccuracies, hence you need to double check all numbers and words. * Note that 99% of the cards are in English. For cards with multiple languages, if the information is also in English, only the English data is required. * The partner needs to report on the progress of the data entry * Sample of the scanned cards is atta...
I need a skilled web developer to duplicate 785 WordPress pages within 1 hour. The project involves customization of the URL and page title to align with specific city names provided in an Excel sheet. Key Requirements: - Duplicate 785 WordPress pages quickly and accurately - Customize the URL and title of each page according to its respective city - Ensure that the formatting and layout of the duplicated pages remain consistent with the original - Provide a high level of detail and accuracy to maintain the integrity of the multi-location business promotion strategy Ideal Skills and Experience: - Proficiency in WordPress and web development - Ability to work quickly and accurately under time constraints - Strong attention to detail to ensure correct customization of each page - Ex...
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...
...to docks swiftly and efficiently as priorities change. - Dock Management: The core function of the application is to manage the docking of vehicles based on the priority given for each against time (backend). This includes real-time adjustments as priorities change. - Google Sheets Integration(additional): The system should also be able to fetch and update data about the vehicles from a Google sheet to ensure the most recent and relevant information is being considered. Ideal Skills and Experience: - Proficient in JavaScript - Experience in real-time web applications - Familiarity with Google Sheets API - Prior experience in developing management systems is a plus - Strong project management and communication skills If you're confident in your ability to deliver a high-qua...
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'm in search of a skilled artist, preferably with a knack for producing cartoon-style characters, to create a unique 2D sprite sheet for me. The actions needed for this character are: - Running - Jumping - Attacking The dimensions for this sprite sheet should be set at medium size, which would be 64x64 pixels. Please ensure you are well-versed in executing this pixel size and can maintain the quality of the character design at these dimensions. Additionally, your experience in designing engaging and visually appealing cartoon characters is highly valued for this job.
...hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Critical Thinking - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Experience in the nightlife industry...
I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.
Looking for an efficient, detail-oriented freelancer to recreate an existing one-page design on an Excel sheet, intended solely for data entry. You must be swift but precise, ensuring all data entered is accurate and comprehensive. I will provide the design for recreating, so your task will be purely focused on data entry. Skills & Experience: - Proficiency in Excel - High attention to detail - Speed in data entry without jeopardizing quality - Familiarity with handling and organizing large data sets.
I'm looking to develop a Microsoft Access database to manage and print cage cards for laboratory mice from an existing Excel file. The Excel includes columns like Cage ID, Strain, Sex, Age, Mouse ID, and Notes, among others. Each card should group mice by their Cage ID and include relevant details such as Strain, Mouse ID, Sex, and Requirements:Database Development: Create a database from the Excel Card Design: Design printable cards with the listed Functionality: Enable direct printing from Interface: Simple UI for selecting and printing cage provide a quote and timeline for this project, along with any similar work you've done.
I'm looking for a Virtual Assistant with experience in lead generation for Instagram. However, I'm including in this post a training video so you understand how ...valuable IG usernames and since my reps charge me a lot the only ones who can afford it is rich people. It also just so happens everyone who works in night life knows... rich people. :) Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Critical Thinking - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Experience in the nightlife industry Here's the video to watch:
I am looking for a comprehensive bakery management system with an in...This will help us keep track of our bakery items, ensure we never run out of stock, and improve our overall inventory management. - Android App with Payment Integration: The project also involves developing an Android app that should be user-friendly, visually appealing, and efficient. The app must seamlessly integrate a payment gateway to enable secure and convenient transactions. - Balance Sheet and Profit and Loss Statement alongwith wastage to be generated Daily Ideal Skills: - Experience in developing comprehensive management systems and Android apps - Proficiency in order and inventory management systems - Previous work on payment gateway integration - Familiarity with real-time tracking and notificati...
I'm looking for a specialist to create a synchronization from my Shopify store to a Google Sheet happening in real-time. The projected data includes: - Product Prices - Inventory Levels - Customer Basic Information - Order Numbers and Line Items - Abandoned Cart Data The ideal freelancer for this job is someone experienced with Shopify API and Google Sheets and able to flawlessly and automatically sync provided data fields. Understanding of e-commerce and Shopify platform is a plus. Please, make sure to include examples of similar work in your proposal.
I'm looking for a designer who can make one single lead-generation landing page for a website of mine. The main goal of the website landing page is to collect contact information from potential customers. from an ad campaign on click of CTA button, this landing page has to come up. I will prefer the generated leads to get accumulated on an excel sheet if its possible. I WILLNOT RESPOND BACK TO people who bid blindly by sending their portfolios.
I'm in need of a skilled professional to help me convert a 3D model I have of a sheet metal part from Rhinoceros 3D to a flat pattern in DXF format. The intention behind this flat pattern design is for manufacturing purposes. Key Requirements: - Experience with Rhinoceros 3D: As the 3D model is in Rhinoceros, you need proficiency with this software to understand and handle the model appropriately. - Sheet Metal Design: Proficiency in sheet metal design is crucial to ensure the flat pattern is suitable for manufacturing. - DXF Conversion: You should have experience in converting 3D models into flat patterns for manufacturing, specifically in DXF format, as this is the final deliverable needed. - Attention to Detail: Given this is for manufacturing, precision is...
I am in urgent need of a professional well versed with Excel Operations to help typify a vast array of data into an Excel sheet. The data includes: - Text - Dates - Numbers A key part of this project involves adhering to specific formatting requirements, which include: - The application of currency formatting - Utilizing bold or italic text when necessary - Highlighting certain cells This is a time-sensitive project that requires immediate attention, therefore the ideal candidate should be able to commence work ASAP. Your experience with Excel, data entry, and attention to detail will be highly beneficial in executing this project.
I'm looking for a professional bid writer with experience in the construction industry to help me put together a comprehensive proposal for the renovation of an existing structure. Key Project Details: - The bid should include a line-item sheet, which should cover materials, labor and equipment costs. - The scope of work to be included in the bid is the complete renovation of an existing structure. - The level of detail required in the proposal is a detailed breakdown with clear timelines and stages. Ideal Candidate: - Previous experience in writing construction bids is highly desirable. - Strong understanding of construction logistics, material costs and labor requirements. - Excellent communication skills to ensure the bid is clear and engaging. - Ability to break down com...
...script but I expect the freelancer to think outside the box and be smart and sharp. Hours: - I expect the freelancer to work around 20 hours per week on cold calls during Melbourne, Australia Time business hours. About the role: - Cold calling leads and following up potential leads - Set appointments with decision makers in charge of procurement. - Filling in all details of each call into a google sheet I'll provide. Data MUST be filled in accurately. About you: - Previous experience working in phone sales or outbound sales position (preferably within the cleaning industry) - A strong track record of success in achieving sales targets and standards - Hungry for sales - Confident communicator on the phone WHEN APPLYING, PLEASE INCLUDE A RECORDING OF YOU SPEAKING ON THE PH...
I'm looking for a proficient individual to assist in organizing and maintaining my Google Sheet designed for inventory management. Key Responsibilities: - Handle data entry and ensure the organization of the sheet - Assist in setting up formulas and analysis tools This will be an ongoing project, with updates required on a monthly basis. The primary purpose of the sheet is to effectively manage inventory. Ideal Candidate: - Proficient in Google Sheets - Experience in data entry and organization - Skilled in creating formulas for data analysis - Available for recurring monthly updates