Results 1 to 6 of 6

Changing Horizontal to vertical references

Threaded View

  1. #3
    Registered User
    Join Date
    01-02-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Changing Horizontal to vertical references

    Ok here is the Sheet im working on.

    If you go to the first sheet (Monthly summary) theer is essentially a table that summaries all the costs in the other 31 sheets (each representing a day of the month)

    What i am trying to do is, for example in the sheet ('1') (day 1) im trying to reference cells j81 to r81 into the 'monthly summary' sheet into cells J5-J13.

    And i want to do that for each day of the month, i.e. 31 sheets, so for day 2 of the month (2!) i want to put j81-r81 into "monthly summary" K5-K13 and so on for each day.

    And i have 3 tables to fill. so as u can imagine it would take ridiculously long to reference each cell individually from each other 31 sheets. I treid something with index in the K column but its wrong :S

    Thanks for your help, it is really appreciated.
    Attached Files Attached Files
    Last edited by Seriously; 01-02-2010 at 11:39 PM.

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