+ Reply to Thread
Results 1 to 4 of 4

copy infomation from columns on one sheet to rows on another sheet

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post copy infomation from columns on one sheet to rows on another sheet

    I'm trying to set up a spreadsheet that has a summary page with information displayed in rows but each cell in the row is a formula that is referring to other sheets in the same workbook that shows information in columns.

    Example
    Cell A1 on summary sheet refers to cells C1+D1-F1 on other worksheet
    Cell B1 on summary sheet refers to cells C2+D2-F2 on other worksheet
    Cell C1 on summary sheet refers to cells C3+D3-F3 on other worksheet

    I need the summary sheet to refer to lots of information for a year in weekly buckets so can anyone help me with copying the type of formula above into summary sheet.

    Many Thanks for any help you can give.

    Muireann

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: copy infomation from columns on one sheet to rows on another sheet

    Please attach a sample workbook and if possible put in a "Output" sheet to display what you would like to achieve.

  3. #3
    Registered User
    Join Date
    10-20-2011
    Location
    Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: copy infomation from columns on one sheet to rows on another sheet

    Quote Originally Posted by arlu1201 View Post
    Please attach a sample workbook and if possible put in a "Output" sheet to display what you would like to achieve.
    I hope that you can read the attached file. Factory Picture is the "Output" sheet

    Many Thanks

    Muireann
    Attached Files Attached Files

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: copy infomation from columns on one sheet to rows on another sheet

    With the help of the attached file, can you please explain the problem again?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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