+ Reply to Thread
Results 1 to 5 of 5

Getting Values from Other Excel Sheets

  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    5

    Getting Values from Other Excel Sheets

    Helol there,

    I would like to know if there is a way to compile values from Different spreadsheets..

    I woulk like a way to get the value of all Single Cell (ex : C5) on a bunch of different spreadsheets, so I could then do some maths for reports.

    any way do do so?

    Thanks,
    Climbo

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    If your sheet names are Sheet2,3 etc try this

    =INDIRECT("sheet"&ROW(A2)&"!C5") and drag down

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    02-16-2007
    Posts
    5

    Getting Values from Other Excel WORKBOOKS

    Hello there,

    my previous tread was erroneous my mistake, sorry...

    i'm talking about workbooks (a different file), and now spreadsheets ...

    so here we go again..

    I would like to know if there is a way to compile values from Different WORKBOOKS..

    I woulk like a way to get the value of all Single Cell (ex : C5) on a bunch of different WORKBOOKS, so I could then do some maths for reports.

    any way do do so?

    Thanks (again),
    Climbo

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    It varies a lot if you are using opened or closed workbooks ...
    Which case are you in ...?
    HTH
    Carim


    Top Excel Links

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    As Carim says it all depends if open or closed. Here's a few ways for closed workbooks

    These sites might help

    http://www.rondebruin.nl/ado.htm

    http://xcell05.free.fr/english/moref...direct.ext.htm

    VBA Noob

+ 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