Results 1 to 6 of 6

Dragging down linked cells as a series

Threaded View

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

    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.

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. [SOLVED] 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