Closed Thread
Results 1 to 3 of 3

newbie here pls help!

  1. #1
    Registered User
    Join Date
    01-21-2009
    Location
    toronto
    MS-Off Ver
    Excel 2003
    Posts
    23

    newbie here pls help!

    I have file which is repeating, and i want to insert a row after the end of each repitition.

    here is my sample data from:

    123 sat
    123 sat
    444 mat
    444 mat
    444 mat
    555 abi

    to:
    123 sat
    123 sat
    new row insert
    444 mat
    444 mat
    444 mat
    new row insert
    555 abi

    I know it involves a macro and i dont know how. pls help as its a HUGE data and i need to automate it.

    many many thanks
    tesfamichael

  2. #2
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949
    Sure thing, I can help you with that, but you'll need to fix your thread title first!

    We need threads titled appropriately for the sake of others who use the search engine to find solutions to their problems which have already been solved.

    Something along the lines of "VBA to insert rows" would be awesome.

    mew!
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    tesfamichael,

    Thread closed as you reposted. Please read the forum rules below before reposting

    Many thanks

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

Closed Thread

Thread Information

Users Browsing this Thread

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

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