Results 1 to 6 of 6

Macro to automatically insert rows between changes in data

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    6

    Macro to automatically insert rows between changes in data

    Hi All,

    I am extremely new to macros, but I think using one for this purpose would save me a great deal of time. I am using Excel 2010 on Windows 7. Here is an example of the data that i have in my worksheet:

    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- MISCELLANEOUS - 11501170
    El Paso Live Events- STREETFEST - 11501179
    El Paso Live Events- STREETFEST - 11501179
    El Paso Live Events- STREETFEST - 11501179
    El Paso Live Events- MEXICAN COOK OFF - 11501181
    El Paso Live Events- MEXICAN COOK OFF - 11501181
    El Paso Live Events- MEXICAN COOK OFF - 11501181

    I would like to have the macro insert a row between each change in data. Is this possible and can anyone help with the code?

    Thank you very much in advance for your help!

    -Chris
    Last edited by JBeaucaire; 10-11-2012 at 01:35 PM. Reason: Moved to correct forum.

Thread Information

Users Browsing this Thread

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

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