+ Reply to Thread
Results 1 to 4 of 4

how to insert empty rows based on column B cell values and paste above values with macro?

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    171

    how to insert empty rows based on column B cell values and paste above values with macro?

    hi to all
    good evening

    i have data from column A to D and i want to insert empty rows based on column B values and would like to paste above values in empty rows.

    DATA I HAVE
    A 2 R Q
    B 3 S V
    C 4 T J
    D 5 U O

    i would like to have results like this
    RESULTS I WOULD LIKE TO HAVE
    A 2 R Q
    A R Q
    B 3 S V
    B S V
    B S V
    C 4 T J
    C T J
    C T J
    C T J
    D 5 U O
    D U O
    D U O
    D U O
    D U O

    i tried wit macro i can able to insert empty rows but unable to paste or repeat the above cell values in created empty rows. can any one help me with macro to achieve my desired results.
    any help in this regard is highly appreciated and thanks in advance
    Genetist
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,138

    Re: how to insert empty rows based on column B cell values and paste above values with mac

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    171

    Re: how to insert empty rows based on column B cell values and paste above values with mac

    Dear Fluff13
    thanks lot for you great work your code is working as per my expectation
    thanks lot for your help and time spent for the same.
    Regards,
    genetist

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,138

    Re: how to insert empty rows based on column B cell values and paste above values with mac

    Glad to help & thanks for the feedback

+ 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. Macro to copy paste values if cell is not empty
    By Xenthys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2017, 06:52 PM
  2. Cut Entire Row, paste it in next empty Row In Another Sheet, based cell values
    By brayboyce in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-23-2015, 06:19 PM
  3. Replies: 1
    Last Post: 10-05-2014, 12:28 PM
  4. Insert rows based on values in column
    By scott p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2013, 01:58 PM
  5. [SOLVED] Insert Rows, based on values in a column, for a 300,000 row dataset
    By engineerlady in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 04:47 PM
  6. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  7. paste RNG numbers
    By kaohik78 in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 10:30 PM

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