Results 1 to 7 of 7

referencing many closed workbooks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    referencing many closed workbooks

    Hi Guys,

    I have a workbook for each day recording energy usage from 52 meters,

    I need to collate the data on a single workbook.

    The only way i can think of doing it is to use the INDIRECT function but this will not work on closed workbook.

    I need to sum the contents of B1:AW1 on the closed workbook and input that into a cell on the new sheet. then repeated for B2:AW2, B3:AW3 up to B52:AW52 once this has been done the process needs to be repeated for 31 workbooks.

    The end product should be 31 Columns (one for each day ini the last month) and 52 rown (one for each meter) and the total daily consumption for each meter (sum of column B:AW)

    I have no idea how this is going to happen but I think VBA may be the only solution.

    thank you for reading and even more thanks for helping
    Last edited by freud1; 11-09-2009 at 07:20 AM.

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