+ Reply to Thread
Results 1 to 4 of 4

count oval shape for each name and merge for repeated name

  1. #1
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    count oval shape for each name and merge for repeated name

    hello
    I want counting oval shape where is existed for each name and if repeat the name should merge and summing , if delete the oval shape for some names have already been marked should count again .the result should be in columns M,N and update every time run the macro
    Attached Files Attached Files
    Last edited by Mussa-A; 12-14-2021 at 08:20 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: count oval shape for each name and merge for repeated name

    Try this one
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: count oval shape for each name and merge for repeated name

    thank , but I don't want to write the names in column M manually becuase the data increase . I wanted another macro to do that not mod the original code .

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: count oval shape for each name and merge for repeated name

    I understand that, you can now use your own imagination to add a name if it does noet exist
    That's the way to learn, I knew you were going to ask that becasue it is easier to ask then try things out. You will only lear to work with VBA by trial and error.
    I'll work it out for you but you can start for yourself too.
    Just curious: how will you know if a name is missing? The inout box just allows you to enter something and it is case sensitve so an errro is easy to maken.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count data avoiding to count repeated entrys
    By blueangelzx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2020, 08:44 PM
  2. [SOLVED] How to add 3d bevel (Cool Slant) shape effect to Oval shape
    By Steve@Rugby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 11:29 AM
  3. Graph in a oval shape
    By coreytroy in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-22-2013, 02:57 AM
  4. Applying formatting to specific repeated blocks of text in Mail Merge generated documents
    By Uncle Bojangles in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2012, 08:47 AM
  5. Sum/merge repeated columns within an array
    By alhawksford in forum Excel General
    Replies: 10
    Last Post: 02-27-2012, 12:35 AM
  6. VBA code to Merge the repeated cells and sum the corresponding columns
    By kiran234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2010, 07:58 PM
  7. How to merge repeated data cell in Excel?
    By indra in forum Excel General
    Replies: 8
    Last Post: 10-30-2009, 07:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1