Closed Thread
Results 1 to 2 of 2

formula or macro / vba to insert new row everytime unique value appears?

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    formula or macro / vba to insert new row everytime unique value appears?

    Hi there,

    I am trying to learn VBA / Macro's but am finding it difficult to apply the following to a large data spreadsheet.
    I would be grateful for your help?

    Please see attached for a sample of the data.

    I have data in columns E, O, S and U which changes. What I would like to do automatically is when the value changes, insert a new blank row to separate them.

    For example, a blank row to be inserted under row 4, 6, 9, 10, 235 etc. There is approx. 12,000 rows and there is no consistency in the number of rows before a unique value appears.

    Is this possible? It can be based on 1 column as far as I am aware.

    Many thanks for your help.

    Regards

    N
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: formula or macro / vba to insert new row everytime unique value appears?

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] macro / vba to insert new row everytime unique value appears?
    By nimv1 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-27-2017, 08:14 PM
  2. Type Mismatch Error appears everytime Excel is opened
    By russwongg in forum Excel General
    Replies: 19
    Last Post: 11-21-2014, 11:05 PM
  3. VBA to insert row but row number changes everytime
    By freeon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2014, 11:29 AM
  4. How to see data everytime a value appears in multiple columns
    By lauriexstevens in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-28-2013, 11:58 PM
  5. Replies: 19
    Last Post: 01-05-2013, 06:14 AM
  6. Replies: 3
    Last Post: 08-17-2011, 05:07 PM
  7. macro to insert 1 column with formulas everytime it run
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2009, 11:44 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