+ Reply to Thread
Results 1 to 5 of 5

count columns with data then insert that number of rows

  1. 02-11-2014, 05:23 PM #1
    johnson1421
    johnson1421 is offline
    Registered User
    Join Date
    11-22-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    9

    count columns with data then insert that number of rows

    Hi

    I am new to vba and am trying to solve the below issue. Any advice will be greatly appreciated.

    Original

    01012014 DAVE JOHN
    02012014 MAT
    03012014 CHRIS MIKE PHIL

    What I want

    01012014 DAVE
    01012014 JOHN
    02012014 MAT
    03012014 CHRIS
    03012014 MIKE
    03012014 PHIL
    Reply With QuoteRegister To Reply
  2. 02-11-2014, 07:09 PM #2
    mongoose36
    mongoose36 is offline
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: count columns with data then insert that number of rows

    johnson1421,

    You will get a lot more help from this forum if you are a bit more descriptive. I understand that you've probably been staring at this problem/issue for days and know it inside out, but the rest of us have just been introduced to it. So you will need to be a bit more thorough in your explanation of what you want done.
    Reply With QuoteRegister To Reply
  3. 02-11-2014, 07:56 PM #3
    perimidt
    perimidt is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: count columns with data then insert that number of rows

    Hi

    Take a backup of your data and try this macro:
    Please Login or Register  to view this content.
    The problem with your request is not each line in the macro, but rather to be able to keep track of the number of rows and columns at all times, hopefully I got it right.
    Best regards

    Per Erik Midtr?d
    Reply With QuoteRegister To Reply
  4. 02-11-2014, 07:58 PM #4
    perimidt
    perimidt is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: count columns with data then insert that number of rows

    And you probably want to remove this:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-12-2014, 06:54 PM #5
    johnson1421
    johnson1421 is offline
    Registered User
    Join Date
    11-22-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: count columns with data then insert that number of rows

    Thank you very much

    It works perfectly
    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. Trying to count number of rows where criteria are met in columns
    By kfloyd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2013, 01:45 PM
  2. Number of Rows or Columns count
    By zulkfal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2012, 11:40 PM
  3. Function to count number of rows and insert a value
    By RyanF in forum Excel - New Users/Basics
    Replies: 28
    Last Post: 06-24-2009, 04:24 PM
  4. insert text in columns based on maximum number of rows containg data
    By twrizzo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2007, 03:35 PM
  5. Count rows and insert number to count them.
    By Mex in forum Excel General
    Replies: 6
    Last Post: 08-22-2006, 09:35 PM

Tags for this Thread

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