+ Reply to Thread
Results 1 to 6 of 6

Reference cell, seperate worksheet. Drag down but reference across

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    Oxford, England
    MS-Off Ver
    2010, 2013
    Posts
    3

    Reference cell, seperate worksheet. Drag down but reference across

    Hi,

    So I am currently creating a data management document.

    On 1 worksheet I have listed down sources of information for different location with the total per location running horizontally.
    on worksheet 2 I need to list the total down but the data is presented vertically.

    When I reference on worksheet 2 I just select reference cell on worksheet 1.
    I then need to drag it down to fill out the relevant cells on the 2nd worksheet but I need the auto fill to go horizontal when referencing the cells

    How do I do this?

    Excel 2010

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Reference cell, seperate worksheet. Drag down but reference across

    Hi,

    Welcome to the forum!

    Please post a sample file with the desire output.

    Regards,
    AM

  3. #3
    Registered User
    Join Date
    05-05-2015
    Location
    Oxford, England
    MS-Off Ver
    2010, 2013
    Posts
    3

    Re: Reference cell, seperate worksheet. Drag down but reference across

    Book1.xlsx
    Heres an example of the question

    Sheet 2 to reference sheet 1.
    sheet 2 is meant to be a summary.

    Sheet 1 is a month with additional monthly sheets to be added

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,964

    Re: Reference cell, seperate worksheet. Drag down but reference across

    take a look at this
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    05-05-2015
    Location
    Oxford, England
    MS-Off Ver
    2010, 2013
    Posts
    3

    Re: Reference cell, seperate worksheet. Drag down but reference across

    Thanks, Should save me a lot of time.

    Many Thanks

  6. #6
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Reference cell, seperate worksheet. Drag down but reference across

    Hi Rgriff,

    If the problem has been resolved then please take a moment & mark the thread as SOLVED.
    Also click on add rep whosoever has helped you.

    Cheers!

    Regards,
    AM

+ 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 down reference to cells on seperate sheets
    By Lbischoff in forum Excel General
    Replies: 3
    Last Post: 10-02-2013, 04:10 PM
  2. Replies: 5
    Last Post: 09-20-2013, 02:44 PM
  3. [SOLVED] Drag/Fill column while skipping multiple reference rows in another worksheet
    By chandlerrw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2013, 07:59 PM
  4. Display data reference from another worksheet based on cell reference
    By Drew123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2011, 03:52 PM
  5. Seconday Worksheet Reference Formula Drag Fill incrementing Issue
    By DavidCharles1224 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-08-2010, 04:05 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