Results 1 to 3 of 3

Gathering data from another sheet.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Myrtle Beach, South Carolina
    MS-Off Ver
    =IF(Win 7,"Excel 2010","Mac Excel 2011")
    Posts
    104

    Gathering data from another sheet.

    Hello,

    I have a sheet that refers to another sheet in the workbook, lets call them sheet1 and sheet2. On Sheet2 I have referenced a cell in Sheet1 by using
    Formula: copy to clipboard
    =Sheet1!A1
    If I wanted to copy the formula down by increasing the row by 20,
    Formula: copy to clipboard
    =Sheet1!A21
    is there an easy way to "Fill Down"? The other option I have is to manually refer the cells around 3,000 times. Thank you in Advance.
    Last edited by jakeisbill; 01-03-2013 at 10:38 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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