+ Reply to Thread
Results 1 to 4 of 4

Copy/Paste every nRows

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    London, ON
    MS-Off Ver
    2007
    Posts
    2

    Copy/Paste every nRows

    Hello,

    I am currently working on a bid sheet for my company; the accounting department has new software and they need me to alter my spreadsheet to fit a format that is suitable to import into their system.

    I will try to explain this as simple as possible (I have attached an example spreadsheet as well)

    Sheet1: Estimate
    Sheet2: Cost Code Import Sheet

    I need to take the information from Sheet1 and have it converted to fit sheet2 and there are a few issues I'm having:

    #1 I need the line items in column B on Sheet1 (B2,B3,B4) referenced on Sheet2 but every 4 rows (E2,E6,E10)

    #2 Now that I have 3 blank rows between my line items, I need to reference the cost amounts in cells F2,G2,H2 (sheet1) onto sheet 2 (D3,D4,D5)

    I know this might be confusion, I tried my best.

    so far, I have been changing the reference in every cell, and I have hundreds of line items... I do not think I will maintain what little sanity I have left if I continue doing it this way

    please help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copy/Paste every nRows

    See the green cells, and drag them (all 4 together) down.

    Before you do that, make sure you don't have merged cells.

    Merged cells will cause problems sooner or later.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Copy/Paste every nRows

    Try this in J2 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Then this in D3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This in D4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    And this in D5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Then copy those down.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  4. #4
    Registered User
    Join Date
    07-22-2014
    Location
    London, ON
    MS-Off Ver
    2007
    Posts
    2

    Re: Copy/Paste every nRows

    You guys are absolutely... positively... amazing. This really did it all. Thank you.

    My next step is aim to learn and understand the formulas for future use.

    again, Thank you!

+ 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. How do I make the copy/paste of one column contingent on the copy/paste of another?
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 01:51 PM
  2. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  3. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  4. nRows range within SUMIF
    By Meltad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2006, 07:15 AM
  5. Replies: 1
    Last Post: 01-04-2005, 06:06 PM

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