+ Reply to Thread
Results 1 to 7 of 7

need formula to copy data from sheet 2 onto sheet 1

  1. 10-02-2014, 03:59 PM #1
    seanss
    seanss is offline
    Registered User
    Join Date
    10-02-2014
    Location
    Naperville, IL
    MS-Off Ver
    2010
    Posts
    2

    need formula to copy data from sheet 2 onto sheet 1

    Looking for a formula that will copy data from sheet 2 to sheet 1:

    Below are in 6 different columns and read like this:

    =Sheet2!$C$3 =Sheet2!$C$4 =Sheet2!$C$5 =Sheet2!$C$6 =Sheet2!$C$7 =Sheet2!$C$8

    (need a formula that will increase each cell by 9 rows; example

    =Sheet2!$C$12 =Sheet2!$C$13 =Sheet2!$C$14 =Sheet2!$C$15 =Sheet2!$C$16 =Sheet2!$C$17

    =Sheet2!$C$21 =Sheet2!$C$22 =Sheet2!$C$23 =Sheet2!$C$24 =Sheet2!$C$25 =Sheet2!$C$26 ....and so on.

    I know it's basic but I'm banging my head on this one!!

    Thanks for the help! SS
    Reply With QuoteRegister To Reply
  2. 10-02-2014, 04:12 PM #2
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: need formula to copy data from sheet 2 onto sheet 1

    Would this be what you are looking for:

    Doesn't work
    Last edited by newdoverman; 10-02-2014 at 05:42 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  3. 10-02-2014, 04:21 PM #3
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: need formula to copy data from sheet 2 onto sheet 1

    If the copy starts in A1 of sheet1 then enter this is A1 and copy across and down:

    Doesn't work.
    Last edited by newdoverman; 10-02-2014 at 05:42 PM.
    Reply With QuoteRegister To Reply
  4. 10-02-2014, 04:58 PM #4
    seanss
    seanss is offline
    Registered User
    Join Date
    10-02-2014
    Location
    Naperville, IL
    MS-Off Ver
    2010
    Posts
    2

    Re: need formula to copy data from sheet 2 onto sheet 1

    Thanks for the quick reply but that's not what I'm looking for. Just need the formula =sheet2!$C$3 to jump down 9 rows to =sheet2!$C$12. I don't need the value of cell C$3 to increase by 9. Sorry if I'm not explaining this better. I have a very basic understanding of Excel.
    Reply With QuoteRegister To Reply
  5. 10-02-2014, 05:18 PM #5
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: need formula to copy data from sheet 2 onto sheet 1

    The formula is designed to retrieve the values from every 9 rows. As the formula is copied down, the value retrieved is 9 rows down from the previous value retrieved.

    If that isn't what you want, please upload a workbook that illustrates what you want to retrieve and where you want the values.
    Reply With QuoteRegister To Reply
  6. 10-02-2014, 06:18 PM #6
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: need formula to copy data from sheet 2 onto sheet 1

    I think that I have something that actually works. The formula for each column on Sheet1 will have to be manually entered (for now) if this is what you want.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 10-02-2014, 06:42 PM #7
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: need formula to copy data from sheet 2 onto sheet 1

    Here is another way. You want 6 columns wide but this can be copied over to 9 columns if you want.

    Enter in A1 and copy across and down.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If you start in C1 the formula would change to:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If you want to limit the columns to 6 and still have every 9th row then use this syntax:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by newdoverman; 10-02-2014 at 06:45 PM.
    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. [SOLVED] how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
    By parag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2014, 07:34 PM
  2. VBA formula to copy paste selected data from main sheet to new sheet
    By vbanoob123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2014, 12:28 PM
  3. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  4. Copy Sheet / Create & Name New Sheet / Insert Before a Sheet / Paste Data
    By thinkspac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 02:27 PM
  5. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1