Vba macro count sheet työt
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
...Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the name "Adelya" with the name "Tecmark" Step 6: There should be 12 replacements, then you know you have done it right Step 7: Save the file once again as "Tecmark Expansion - Australia and New Zealand" Step 8: Save a second copy of the file in PDF version (Powerpoint will offer you an option called "Save as file type") Step 9: That's all. Move on to the next n...
...proficient aid in accounting and finance. The primary tasks include: - Bookkeeping: This involves accurate record-keeping of all monetary transactions. Your keen attention to detail and remarkable time-management skills would be beneficial. - Financial Reporting: A systematic record of all financial activities is needed for strategic planning. Expertise in preparing income statements, balance sheet reports, and cash flow statements is necessary. - Tax Preparation: Your tax preparation skills should ensure compliance with laws and regulations to avoid penalties. The individual best suited for this role should have a background in accounting, finance, or a related field. Experience working with sole proprietorships is a plus. Excellent analytical skills, familiarity...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells 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...
...Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the name "Adelya" with the name "Tecmark" Step 6: There should be 12 replacements, then you know you have done it right Step 7: Save the file once again as "Tecmark Expansion - Australia and New Zealand" Step 8: Save a second copy of the file in PDF version (Powerpoint will offer you an option called "Save as file type") Step 9: That's all. Move on to the next n...
As a TikTok Influencer Outreach Specialist, your main task will be to connect with influencers/KOLs on TikTok within the United States. Key Responsibilities: - Reach out to TikTok influencers with a follower count of over 5K - Encourage the influencers to accept a free premium product sample - Request the influencers to create video content around the said product Your role is pivotal in ensuring the success of our TikTok influencer promotion campaign. Ideal Skills and Experience: - Proven experience in influencer outreach on TikTok - Familiarity with the United States market and TikTok trends - Exceptional communication skills - Ability to close deals with influencers - Knowledge of how to negotiate and motivate influencers to create content Please note that w...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo...
As a lifestyle content creator, my main focus is to increase the number of subscribers on my YouTube channel. Key Requirements: - Goal: The primary aim is to develop a strategy to organically increase the channel’s subscriber count. - Skill: You are expected to have experience in growing YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with your detailed proposal. I'm looking f...
...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 Outloo...
I'm in search of a talented tattoo artist who can create a unique blackwork tattoo design for me. NOTE: The design is to be based on an existing tattoo (photo is attached, must incorporate this tattoo), but expanded upon with a fresh blackwork twist. The placement is upper arm/shoulder area. The current tattoo is approx. 3 i...incorporating sacred geometry and symbolism into your designs. Key Points: - Proficiency in blackwork tattoo style - Ability to artfully incorporate sacred geometry into the design - Understanding of creating symbolism in tattoos, particularly representing enlightenment and spirituality Your creativity and ability to merge these elements will be essential in completing this project. A transfer sheet will be required upon awarding. Looking forward to se...
I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed furniture from the area...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
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
Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg ta...I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and s...
I need a skilled developer to help me create a high-quality app sheet for the education industry. The main aim of this project is to increase my online visibility and generate more leads. Key Features Required: - Primarily, the app must have quizzes and assessments. Ideal Skills and Experience: - Experience developing app sheets or similar software within the education sector. - Knowledge of incorporating interactive elements like quizzes into an app. - Strong understanding of how to optimize visibility online and generate leads. As an app developer on this project, you'll take on a pivotal role in creating a valuable educational tool. If you’re passionate about development and education, I'm eager to hear from you.
I'm in urgent need of a writer with a solid understanding of nursing. Please place your bid if you are capable of starting immediately. Ideal Skills & Experience: - Strong background in nursing - Ability to work with academic references - Quick turnaround time Please note that I've skipped specifying the word count and references for now. If we proceed further, we can discuss these details.
...popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+ Authentication is done through twitter, I will connect my twitter account and run the script
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new
NERC Holidays Insertion Directions I am creating a excel sheet for electricity pricing research. There are typical days and there are holidays for which the typical load (demand) shape gets distorted. As a preliminary step in this project, I need to identify all of the holidays that occurred from January 1, 2006 until present. The recognized holidays for the US electricity markets are called “NERC holidays,” which is the abbreviation for the North American Electric Reliability Corporation. The six recognized NERC holidays are New Year’s Day Memorial Day (last Monday in May) Independence Day (always July 4) Labor Day (first Monday in September) Thanksgiving Day (the fourth Thursday in November) Christmas Day (always December 25) Please also add three
I am in need of a skilled animator to create a 3D promotional animation for my locker product. The target audience for this video is adults, so the animation should be informative and visually appealing to a mature audience. Key requirements and responsibilities include: - Creating a 3D animation styled video - Crafting the video with ...changes into green and he can take out his bed again Maybe we have a different light at this time because it’s afternoon or evening He leaves and the door closes automatically because of the self closing hinges. Contest: The video should not be longer than seven seconds, and in the next step we will add all the administrative functions on the video as well. But that is another object Please count with some small changes included aft...
I'm in need of a talented designer to craft a classic and elegant booklet for my project. Here are the specifics: - Size: A4 (8.3 x 11.7 inches) - Page Count: 20 to 50 pages The design should reflect a timeless and sophisticated aesthetic, incorporating classic elements while still appearing fresh. I want the design to be simple and uncluttered, evoking a sense of refinement and simplicity. Ideal Skills: - Proficiency in graphic design software (e.g., Adobe InDesign, Illustrator) - Strong understanding of classic design principles - Experience in booklet design - Ability to create engaging layouts for a multi-page document. Please include samples of your previous work in a similar style when applying. Your design will be critical in ensuring my booklet is both informative ...
...and Authentication: • Users can sign up using their email or social media accounts. • User accounts store personal information, trip history, and preferences. Operator Registration and Authentication: • Coach operators can register and provide details about their services, pricing, preferred locations, etc. User Dashboard: • Users can submit trip details including location, and passenger count. • Users receive quotes from multiple operators. • Users can view and manage their trip requests, quotes, bookings, and messages. • Chat functionality to communicate with operators. Operator Dashboard: • Operators can view available trip requests. • Operators can send quotes to users. • Operators can manage their accepted bookin...
...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 integration &...
...tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual Return). G. Preparation & Filing of Annual Returns Form MGT - 07/07A (Management Related Annual Re...
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).
Input data dari laporan keuangan perusahaan ke excel (Balance sheet, laba rugi, cashflow). Cari beberapa data penting dari laporan tahunan perusahaan dan dimasukkan ke excel. Buatkan excel dan grafik dari data yang diinput dalam format yang menarik dan informatif untuk dibaca.
I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
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 looking for a skilled SEO professional who can enhance the SEO of my Cannabis Product Delivery Shopify store. Many of the Products have already been done for reference but there are still around 500 products still needing to be done. The focus will be on using the Yoast Plugin to enhance Product titles. Increasing the word count of Product descriptions to around 230 words (sometimes creating from scratch using other sites as reference and or using AI to help), then creating search engine title and focus keywords and repairing URL structures if needed. If working through CSV is easier, a data export can be sent with relevant data columns. Key Responsibilities: - Enhancing product descriptions for improved SEO performance - Optimizing meta tags to drive more organic search ...
I am looking for a freelancer who can help me sign my restobar business on Grab Food app by creating a menu template on MS Excel. The menu is currently available as a picture and needs to be converted into a simple spreadsheet format that meets Grab's requirements. Key Requirements: - Convert picture based menu into an Excel sheet for Grab Food app - Keep the menu descriptions short and simple - No need for special formatting or design elements, just plain text Ideal Skills: - Proficiency in MS Excel - Accurate data entry skills - Familiarity with food service industry or Grab Food app would be a plus
...government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complexity level specified. This initial project will just be designing a procedure to easily import traffic count text files into SMSS via stored procedures, a PowerShell script or any process compatible with SQL. Full aut...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details...want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you ...
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.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I need a top-notch ghostwriter for a book empha... Here are some specifics I'm looking for: - Knowledge in Business & Sales: You should have a strong understanding of business, particularly sales strategies, and be able to articulate concepts uncovered through interviews in a reader-friendly way. - Research Prowess: You will conduct a series of interviews with experts to create the content. - Word Count Flexibility: I'm not entirely sure about the exact word count yet but it will be a book that we will print and sell. Flexibility here would be fantastic. Prior book ghostwriting experience is required. Having written business or sales-related content before will give you an edge, and if you've actually ghostwritten entire books before, ...
I'm looking for a skilled and experienced YouTube growth specialist to help me increase views and subscribers for my channel. Key detai...be/vdxx3aPiC2k?si=gbbxNfmhUlVTcrNv - **Goal:** My primary focus is to grow the number of viewers and subscribers on my channel. - **Target Audience:** I cater to professionals and businesses, so the strategies employed must resonate with this demographic. The ideal candidate should have the following skills and experience: - Proven track record in growing YouTube channels and increasing view/subscriber count - Experience in creating content for professionals and businesses - Good understanding of YouTube's algorithms and best practices in content promotion I'm looking to work with a committed professional who can help me scal...
Hey, I have to prepare 70 folders data using google sheet and also rename some file names and move it. This will be 1-2 hours of work in total
...task management: Ensure the sheet is structured for managing tasks, deadlines, and priorities effectively. - Enable collaboration and sharing: Set up the sheet to allow seamless sharing and collaboration among less than 10 users. Prioritize privacy and permission settings. - Reporting and analytics: Integrate necessary reporting and analytics tools to help us track progress, performance, and efficiency. Skills and Experience: - Proficient in Smartsheet: Should have prior experience in setting up Smartsheets for teams and projects. - Real-time Collaboration: Understands how to leverage Smartsheet's real-time collaboration features and can set up a system that suits our needs. - Strong Communication: Willing to communicate effectively with me to ensure that the shee...
I'm seeking a designer to revamp an existing sheet metal flyer for my roofing company. The current design isn't to my liking, but I'd like to retain the essential information from it. Below are details to consider: - The new flyer should be designed in a modern style. - The dimensions should be 8x10. - The flyer should prominently display our company's contact information. - It should also effectively showcase the range of services we offer. The Ideal Freelancer: - Experience in designing marketing collateral. - Proficiency in creating modern, eye-catching designs. - A portfolio that showcases successful flyer designs. - An understanding of the roofing or construction industry would be a plus, but not necessary.
...on TikTok. You will need to reach out to the KOLs on the list and ask them to accept business partnership. We provide them with the free sample product, they will use it, and make a video to sell the product. KOLs will get 20% of sales as commission. They are risk free. The risk is on us: they agree and make committment, but just don't make video after they received the products, which doesn't count a job done. For this task, you need to have a strong understanding of influencer marketing on TikTok, a good network of influencers, and experience in outreach and negotiation within the beauty and personal care niche. It will be a bonus if you have experience working with influencers from different age groups and have a good eye for identifying influencers who will be a ...
As a business that primarily gains leads through referrals, I'm eager to expand my reach with effective Facebook ad campaigns. I'm keen on briskly escalating my lead count. To achieve this, I seek a Facebook Ads expert with a proven track record in lead generation. Key tasks: - Design targeted Facebook ads to draw potential clients. - Track and adjust campaigns according to performance. Ideal Skills: - Experience in creating high-converting Facebook ad campaigns. - Proficiency in lead generation strategies. - Strong problem-solving skills to identify and fix poorly performing campaigns. - Extensive knowledge of Facebook Ads Manager. Is this your skillset? Bid on this project, and let's take my business to the next level.
I am presently seeking a highly skilled freelancer for an email extraction project from two highly popular social media platforms - Facebook and Instagram. Key Project Specifications: - Scrape email addresses from both Facebook and Instagram. - Selection of the profiles for scraping should be primarily based on the following criteria: levels of user engagement and followers count. - Along with the email addresses, extract additional user information namely: the account name and its location. Ideal Candidate Profile: - Must have experience in deducing complex social media algorithms. - Understanding of digital privacy laws to ensure compliance during the extraction process. - Fluency in software that can automate this extraction process would be advantageous. My ultimat...
I am seeking a native English speaker to review and evaluate three articles written in English by a non-native speaker. The total word count for all three articles is approximately 6,000 words. The articles cover the topics of traveling. Responsibilities: - Read all three articles - Evaluate the language quality of each article, including flow, grammar, vocabulary, and style. - [Main Task] Assess the likelihood that a native English reader would recognize that the articles were written by a non-native speaker. Note that you don't have to write/rewrite anything. All you need to do is to provide your feedback and assessment.
...Name of founder 3. Company's main website 4. Founder's Linkedin profile URL 5. Founder's email - Direct email with founder's real name ONLY, no generic email addresses like director @ or info @ will be acceptable 6. URL where you found the information listed in Point no. 6 (Write the full URL) 7. Head office in which country ? Please fill in the data into the attached Excel sheet What we are looking for - Your ideal skills and experience: - Strong web research skills - Excellent attention to detail - Proficiency in using search engines and online databases - Ability to work efficiently and meet strict deadlines - Experience in data entry and data management - Knowledge of email verification and validation techniques Project Scope: - The contact details...
I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropriate technical skills.
As someone who needs bilingual copywriting for my emails and messages, here's what I'm looking for: 10 years+ experience in copy wr...candidate should have strong writing skills in both languages and a deep understanding of cultural nuances. - The main task would be creating email and message templates. The templates should cover different scenarios and they should comply with professional etiquettes. - I have some specific examples or templates for the messages and emails I need. I will provide these for reference, although I count on your creativity to bring a fresh perspective. The job would suit someone with previous experience in bilingual copywriting, particularly those who have previously written emails and messages in a professional context. Strong communicatio...
