Results 1 to 4 of 4

Split Row into 2

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2019
    Location
    New York
    MS-Off Ver
    Office 365 ProPlus
    Posts
    2

    Split Row into 2

    Hello,
    I have a set of data that is representative of a transaction between a buyer and seller. I would prefer to see the Buyer on one row and the Seller in a second row, there is a record that link them. At present they are on one row and that makes running metrics a little difficult. Is there a simple vba to accomplish the following:
    insert a row,
    copy above row,
    repeat until the last row?

    Thank you

    Dave
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 34
    Last Post: 03-07-2025, 08:47 PM
  2. Need Macro code to split data split in 7 sheets based on variable rows in column A
    By Alija_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 08:03 AM
  3. [SOLVED] create macro to split screen and then in top split, go to a certain cell
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-17-2015, 05:45 PM
  4. Split cell to create sorted heading on empty row above and keep second split info
    By CastingDirector in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2015, 12:24 AM
  5. [SOLVED] Split Array, Listing Marked Items in Split Arrays
    By lesoies in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2013, 02:07 AM
  6. [SOLVED] Split Macro modification to Split into new Workbooks instead of sheets within one workbook
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 08:11 PM
  7. Can excels Split() function split a string up at multiple spots?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 02:36 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