+ Reply to Thread
Results 1 to 3 of 3

insert row when word is changed along A cloumn

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    insert row when word is changed along A cloumn

    hello my friends,

    can u help me about one so simple code
    i wanna insert empty row when the word is changed along A column.

    pls have a look to my attached file.
    in Sheet1 u ll see that A10 ve A11 has different words, so exactly between two of their rows , i wanna create one empty column like i did manually Sheet2.

    pls help me y friends
    thanks a lot.
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: insert row when word is changed along A cloumn

    Try:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: insert row when word is changed along A cloumn

    yeah thats what i wanna!!!
    suuuuuuuuperb save by Tim Howard!!!

    thanks a lot OLLY!!!

+ 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. [SOLVED] MACRO to Insert row in 'D' col after name changed.
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2013, 08:34 AM
  2. [SOLVED] How to conditionally insert text string into a line after first word using Word 2010
    By staggers47 in forum Word Formatting & General
    Replies: 5
    Last Post: 12-08-2012, 11:07 AM
  3. Insert new columns when the value in the column changed
    By mridzuani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2011, 04:14 AM
  4. Insert function changed
    By EZDO Bob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-08-2005, 12:06 PM
  5. Replies: 0
    Last Post: 01-23-2005, 03:06 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