+ Reply to Thread
Results 1 to 6 of 6

FORMULA: Drag formula down a column but copy data from another page row

  1. #1
    Registered User
    Join Date
    04-06-2017
    Location
    California
    MS-Off Ver
    Recent
    Posts
    39

    FORMULA: Drag formula down a column but copy data from another page row

    Hey guys, just like the title says, basically on Sheet1 cell A1, i want to ='Sheet2'!A1. Be able to drag Cell A1 on sheet1 down the entire A column but copy all the data from Sheet2 going down the row (A1,B1,C1,D1...)

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: FORMULA: Drag formula down a column but copy data from another page row

    Put this formula in A1 of Sheet1:

    =INDEX(Sheet2!$1:$1,ROWS($1:1))

    then copy down as far as you need to.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-06-2017
    Location
    California
    MS-Off Ver
    Recent
    Posts
    39

    Re: FORMULA: Drag formula down a column but copy data from another page row

    not working for me Pete. Still only copies Horizontal (row) and not column

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: FORMULA: Drag formula down a column but copy data from another page row

    Your first post is a bit confusing, as you said "... but copy all the data from Sheet2 going down the row (A1,B1,C1,D1...) ..."

    This implies that the data is arranged across the top row (row 1) of Sheet2 (although I don't know why you said "... DOWN the row ..."), and this is what my formula does if you drag it down column A of Sheet1.

    Please explain your requirements more clearly, or, better still, attach a sample workbook and show in there what you want to achieve. Here's how to:

    Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Please note that the Paperclip icon does not work.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    04-06-2017
    Location
    California
    MS-Off Ver
    Recent
    Posts
    39

    Re: FORMULA: Drag formula down a column but copy data from another page row

    Nvm got it to work thanks pete

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: FORMULA: Drag formula down a column but copy data from another page row

    Glad to hear it.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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. drag sum formula down a column but change the formula
    By stephme55 in forum Excel General
    Replies: 6
    Last Post: 02-22-2016, 03:02 PM
  2. Replies: 2
    Last Post: 11-17-2015, 02:34 PM
  3. Replies: 0
    Last Post: 08-04-2015, 05:42 AM
  4. How to drag the formula till the end of the data in previous column
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2015, 03:04 AM
  5. [SOLVED] Page wise drag down formula
    By kishn697 in forum Excel General
    Replies: 4
    Last Post: 06-28-2014, 07:38 AM
  6. Copy and Drag formula!!
    By quikrich3 in forum Excel General
    Replies: 3
    Last Post: 06-17-2011, 12:41 PM
  7. [SOLVED] Copy Formula: How we can drag in a column?
    By Renee Nguy in forum Excel General
    Replies: 2
    Last Post: 02-10-2006, 01:55 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