Results 1 to 4 of 4

Loop That Will Count Number Of Comments In a Column Between Empty Cells

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    Regina, Saskatchewan, Canada
    MS-Off Ver
    2013
    Posts
    22

    Loop That Will Count Number Of Comments In a Column Between Empty Cells

    Good Afternoon All,

    I am wanting to write a macro that will loop and count the below comments, giving me their placement as there can be up to 9 comments. The comments are in Column U and I would count them in row T.

    So in the below example I would like it to put in the numbers beside the comments.

    1 Comment: OEM #1171022
    2 Comment: SALT CHAIN


    1 Comment: 41L SALT CHAIN CAN USE ON JD850C REMOVE 1 LINK.
    2 Comment: CAN USE 3P5927C CMACHAIN NOTEWL
    3 Comment: SALT CHAIN

    The blank cells are part numbers that do not have comments, as well as each part can have anywhere from 1 - 9 comments so it has to be able to adapt to those perameters. There will always be breaks between the comments as there is other data that forces the breaks.

    Any help at all would be greatly appreciated as I am out of my league on this one.

    Thank you.
    Last edited by M7A0S8T8E5R; 07-15-2016 at 06:04 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-01-2016, 05:57 PM
  2. Replies: 10
    Last Post: 09-26-2015, 08:26 PM
  3. Find count of filled cells and empty cells in a column
    By thepinkgeologist in forum Excel General
    Replies: 4
    Last Post: 09-22-2015, 01:03 PM
  4. [SOLVED] Help! VBA on how to count empty cells in one column based on last row of another column
    By MG3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2015, 02:51 PM
  5. Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  6. [SOLVED] Loop to find cells based on criteria, enter formula into next empty column
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2012, 03:32 PM
  7. Count the number of cells in a range that are not empty
    By efernandes67 in forum Excel General
    Replies: 5
    Last Post: 07-23-2010, 05:41 AM

Tags for this Thread

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