1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel - how do I do this (insert blank rows)

Discussion in 'Business Applications' started by dlarryhancock, Jan 4, 2013.

Thread Status:
Not open for further replies.
  1. dlarryhancock

    dlarryhancock Thread Starter

    Joined:
    Jan 16, 2008
    Messages:
    9
    I have a workbook in which I have two worksheets.
    The first worksheet has 3,400 rows of information
    The second worksheet is meant to take that information and format it in such a way that I can then save that file in tab-delimited format in order to import that file into Quickbooks.

    The second worksheet has to be formatted in a certain way, which means that there will be extra rows in the second worksheet.

    Row 1 of worksheet 2 has other required information
    Row 2 of worksheet 2 will draw information from Row 2 of worksheet 1
    Row 3 of worksheet 2 has other required information
    Row 4 of worksheet 2 has other required information
    Row 5 of worksheet 2 will draw information from Row 3 of worksheet 1
    Row 6 of worksheet 2 has other required information
    Row 7 of worksheet 2 has other required information
    Row 8 of worksheet 2 will draw information from Row 4 of worksheet 1

    This makes it very difficult to write my formulas in worksheet 2 and copy those rows down, since when I copy a row down one row, the referencing changes by one row, whereas I need the referencing to change by THREE rows.

    There are two possible solutions. One, which I do not like, is to figure out how to change the referencing in sheet 2 by THREE rows each time.

    The solution I like, is to figure out a way to insert TWO BLANK ROWS (or two rows of ANYTHING) after each current row in Worksheet 1, so that when I create the rows in Worksheet two and copy them down, the referencing to every third row WILL give me the results I need.

    So.... How can I take a worksheet and insert TWO BLANK ROWS after each currently existing row. (Or create a second worksheet in which every third row refers to the very next row of another worksheet)

    Thanks for looking.
     
  2. Center

    Center

    Joined:
    Jan 13, 2009
    Messages:
    38
    If I'm understanding your scenario correctly, I think one solution would be to use the QUOTIENT, MOD, and ROW functions to determine whether to output a transaction or blank row. So something like:
    Code:
    =IF(MOD(ROW(),3)=0, <insert whatever you need here, use QUOTIENT(ROW(),3) for row reference>, "")
    
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1083707

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice