+ Reply to Thread
Results 1 to 9 of 9

Formula to copy insert/paste current row to below based on cell content

  1. #1
    Registered User
    Join Date
    01-31-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Formula to copy insert/paste current row to below based on cell content

    Hi all . I'm new be kind. I need a formula to insert copies of the current row to a insert a 1,2,or 3 rows directly below. Scenario: I need to survey people. If i have 1 person in a survey, I would say put the number 1 in cell A3 for example. If there are 3 persons in my particular survey then I need to record details for all 3 people; so if A3 = 3 then I need excel to insert 2 more rows for me. cant be that hard.. is it? preferably want it to copy the current row and paste in directly below. Thanks in advance.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Formula to copy insert/paste current row to below based on cell content

    Hi, welcome to the forum

    Excel formulas can only affect the cell they are in, they cannot put/copy/move anything to other cells

    Having said that, what exactly are you trying to do? perhaps it would help if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-31-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Formula to copy insert/paste current row to below based on cell content

    Hi Ford see attached test file
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Formula to copy insert/paste current row to below based on cell content

    Thanks for the file

    That just shows what you have already explained above, but does not tell me what you are trying to do Why do you need to insert rows, instead of just entering teh data below the last row of data?

  5. #5
    Registered User
    Join Date
    01-31-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Formula to copy insert/paste current row to below based on cell content

    If there is only 1 person to survey then i only need 1 row. If there is a group of people (say 3) to survey, I need to insert 2 rows to enter data for the other 2 persons.. each survey type is specific (sorry should have put that in example) so at say the 5:00am survey i may need 1 row (1 person) but if there are 3 persons, i need to insert 2 rows prior to the 6:30am survey as it will be different

  6. #6
    Registered User
    Join Date
    01-31-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Formula to copy insert/paste current row to below based on cell content

    look at my test file again.. might be clearer sorry
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-31-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Formula to copy insert/paste current row to below based on cell content

    I changed a few things in the test file to better explain what i need to do..

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Formula to copy insert/paste current row to below based on cell content

    I still dont understand why you cant just keep adding data below the last row, as the new data comes in?

    So, say, for the 5:00 AM survey (starting in row 7) and there are 3 people, will there already be data in row 8?
    If not, why cant you just continue entering data in row 8?
    If there will already be info in row 8, then there is no formula that will insert rows for you (and copy whatever down), you will either need to do that manually, or use VBA

  9. #9
    Registered User
    Join Date
    01-31-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Formula to copy insert/paste current row to below based on cell content

    the second part of your reply is correct.. there will be data in following row (for the next survey time hence my need to insert rows to allow for the number of people being surveyed. I thought i might have been able to type "3" hit enter and it insert 2 rows for me.. oh well thanks for your help much appreciated

+ 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. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  2. [SOLVED] copy and paste in current active cell, and need current date then scroll down 140 lines
    By vengatvj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2013, 03:40 AM
  3. [SOLVED] Insert rows based on the current cell value and, then, copy some cells into the new rows
    By Excel-RZ in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-03-2013, 05:19 PM
  4. macro to move 1 cell left and paste CURRENT clipboard content as HYPERLINK
    By sgoesef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 01:31 PM
  5. [SOLVED] Conditional Formatting, current cell color follows to diff cell based on content
    By iallenwood in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2012, 04:13 PM
  6. trying to copy/paste row based on checkbox caption and cell content
    By Zygoid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2007, 06:09 AM
  7. Copy and paste row based on cell content
    By BDan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 11:20 AM
  8. [SOLVED] How do I copy a formula/paste w/o losing the cell content?
    By CShannon in forum Excel General
    Replies: 6
    Last Post: 06-25-2005, 08:05 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