+ Reply to Thread
Results 1 to 10 of 10

Macro to insert rows using commas

  1. 07-17-2015, 09:52 AM #1
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Macro to insert rows using commas

    Hi all,

    Need a macro to insert a rows based on the count of commas given in the specified cells. Have attached the sample document for your reference. I tried from my end but i am unable to fix the bug.

    Thansk in Advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-17-2015, 10:09 AM #2
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Macro to insert rows using commas 

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  3. 07-17-2015, 10:17 AM #3
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Macro to insert rows using commas

    Thanks a lot. It works perfectly. The rows getting added only in the Column A. But i need the entire rows needs to be inserted. Can u help on this.
    Reply With QuoteRegister To Reply
  4. 07-17-2015, 10:27 AM #4
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Macro to insert rows using commas

    This will work from the bottom up.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 07-17-2015, 10:35 AM #5
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Thumbs up Re: Macro to insert rows using commas

    Hello,

    Please see the attached Macro.. You need to click the fire command button & see..
    Do enable the macro contents..
    Attached Files Attached Files
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html
    Reply With QuoteRegister To Reply
  6. 07-17-2015, 10:46 AM #6
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Macro to insert rows using commas

    Daffodil... Really thanks a lot for your swift response.. Have a great day.. How to add the reputation for you..Please assist me since i am new to this forum..
    Reply With QuoteRegister To Reply
  7. 07-17-2015, 10:53 AM #7
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Macro to insert rows using commas

    Parth007 Thanks a lot for your immediat response. My problem has been already solved by Daffodil..
    Reply With QuoteRegister To Reply
  8. 07-17-2015, 10:53 AM #8
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Macro to insert rows using commas

    Oh it's just the little * Add Reputation button under my name.
    Reply With QuoteRegister To Reply
  9. 07-21-2015, 10:42 AM #9
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Macro to insert rows using commas

    Hi Daffodil, I need to modify small steps from the above wherein while inserting the rows for each category i need to get the relevant details to be dropped down.. Have attached the sample file. Please let me know if you could help on this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 07-21-2015, 08:31 PM #10
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,527

    Re: Macro to insert rows using commas

    You should have started a new thread I think.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to highlight two rows, insert at first highlighted row to shift down, copy two rows
    By LOFFA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2013, 04:56 PM
  2. [SOLVED] Macro code to insert 3 rows on spreadsheet with variable number of rows
    By D18GE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2013, 07:33 AM
  3. Macro: Copy 3 Rows & Insert below with Format....Also hide last two rows inserted
    By AWiT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 12:04 PM
  4. insert commas in existing file..
    By techker in forum Excel General
    Replies: 16
    Last Post: 04-02-2012, 06:13 AM
  5. How do I insert commas only when appropriate?
    By jhietter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2011, 08:07 AM
  6. Multi functional macro- insert rows, copy data- but never sure how many rows it will
    By kjp2u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2011, 07:13 PM
  7. Insert commas into a row/cell of words
    By Hyacinth in forum Excel General
    Replies: 7
    Last Post: 04-16-2010, 07:29 PM
  8. Need to insert double-quotes to preserve commas in cells
    By ScottHibbard in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2010, 11:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1