+ Reply to Thread
Results 1 to 6 of 6

Dragging down linked cells as a series

  1. #1
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    67

    Dragging down linked cells as a series

    1. I have worksheet A with cells A1, A3, A5 filled in.
    2. I have worksheet B. In worksheet B I want to drag down A1, A2, A3 showing A1, A3,A5 from worksheet A

    The 1st cell is easy ='A'!A1
    the 2nd cell ??
    the 3rd cell ??

    Little flustered. The series would be skipping 1 cell each time but how do I show that in a formula form so dragging it down will be simple for bigger examples.

    Thank you.
    Last edited by Jbelle7435; 07-05-2016 at 04:31 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Excel is a Drag

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Dragging down linked cells as a series

    This video is perfect for you.
    https://www.youtube.com/watch?v=3daluFYyEko

    This would be what I would do.
    Please Login or Register  to view this content.
    Last edited by mikeTRON; 07-05-2016 at 04:38 PM.

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Dragging down linked cells as a series

    Entered in SheetB A1 and dragged down:

    =INDEX(A!A:A,ROWS(A$1:A1)*2-2+1)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Dragging down linked cells as a series

    I'm looking into this index stuff. Looks new to me. I will close this out soon enough.

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Dragging down linked cells as a series


+ 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. Cannot re-drag to do new formula in excel, please HELP
    By Luong Ta in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-25-2015, 02:37 AM
  2. Excel Drag Drop for link from other excel/workbook
    By NARENDRABT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2013, 05:35 AM
  3. drag and drop from Excel
    By MLC2 in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-12-2012, 02:04 PM
  4. Excel Drag Page
    By kcuk in forum Excel General
    Replies: 2
    Last Post: 09-17-2010, 02:00 PM
  5. Excel drag & drop
    By daniel123 in forum Excel General
    Replies: 5
    Last Post: 11-10-2009, 05:43 PM
  6. how to add a drag-down list box in Excel
    By lili in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2005, 03:20 PM
  7. Drag Drop in Excel
    By rahul.singh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 12:35 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