+ Reply to Thread
Results 1 to 3 of 3

Macro to equalize the top rows of multiple vertical ordered tables

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    Amsterdam, Holland
    MS-Off Ver
    Office 2013
    Posts
    33

    Macro to equalize the top rows of multiple vertical ordered tables

    Hi,

    I have a dataset with multiple tables displayed beneath each other.
    I need a macro to equalize the top rows of the tables. Therefore a new column needs to be inserted only at tables which start with 8 instead of 7.

    See the attached example

    Thanks in advance,

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Macro to equalize the top rows of multiple vertical ordered tables

    Hi Vincent,

    Try this code on your sheet. Run the macro called InsertColumns.
    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-30-2014
    Location
    Amsterdam, Holland
    MS-Off Ver
    Office 2013
    Posts
    33

    Re: Macro to equalize the top rows of multiple vertical ordered tables

    Hi Marvin,

    Macro works just fine, thanks!

    Vincent

+ 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 tables into a vertical, sequential format.
    By Coachwooten in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 08:42 PM
  2. [SOLVED] Macro to copy data from tables with unspecified rows on multiple sheets into one table
    By sara ghaith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 08:31 AM
  3. Replies: 2
    Last Post: 06-06-2012, 07:13 PM
  4. Convert multiple rows into one, vertical to horizontal data
    By ortho-research in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-30-2009, 01:07 PM
  5. Sorting Data - Multiple coluns and rows into an ordered list
    By summerfresh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2008, 10:33 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