+ Reply to Thread
Results 1 to 5 of 5

I need to insert rows using macros, based on rows values. Please Help!

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question I need to insert rows using macros, based on rows values. Please Help!

    Hi There, I have a problem my output is in the form attached, if the value of the output is zero or there is no data it goes and plots the next data in the next column, but what I need there is an actual zero or no data. Basically I need the numbers of my columns to all line up such that they match the numbers in the first row (1-90).
    For example in row 4 Column F there is a 4 because of lack of data for the first 3 entries, instead I need this to be blank or zeros and the 4 to actually be in column L where it should belong. There are many skipped data points in each row and they are basically random. Hopefully that makes sense. Please let me know if I can do anything with macros to help fix this. Thanks

    Anton
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: I need to insert rows using macros, based on rows values. Please Help!

    Welcome to the board!

    Is the sample you provided the way the data is formatted? Or have you added the headers?

    What I'm getting at is, could we just read the data into a regular workbook? (We'll have to have a macro enable workbook in order to save the code to manipulate the data anyway.)
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    07-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: I need to insert rows using macros, based on rows values. Please Help!

    Yes we can definitely work in workbook, Also i have simplified it slightly because in my data there are 3 sensors in which the data is exactly the same so I deleted the unnecessary rows and filled the blank spaces with zeros this is where I am at right now. I am getting closer but I am still missing the decisive step to organize them properly.

    Thanks for the reply.

    Anton
    Attached Files Attached Files

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: I need to insert rows using macros, based on rows values. Please Help!

    Sorry for the delay. I had to go out of town unexpectedly.

    Go to Output page and click Go.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: I need to insert rows using macros, based on rows values. Please Help!

    Thank you, this is perfect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1