Results 1 to 7 of 7

Thread: repeat formula from diferent SHEET's

  1. #1

    repeat formula from diferent SHEET's



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have been trying to solve a problem but with no success.

    I am designing a summary sheet which needs to pick up values from different sheets, all in the same document.

    The formula I am typing is this: ='ON 1302'!E6 ( ON 1302 = sheet name)

    I would like for the cell below to pick the same information (= same cell E6) but from the following sheet (ON 1303), which would be: ='ON 1303'!E6


    Doing this is easy, the problem is to repeat this "ratiocination" to all the cell´s below, since I must pick information from more than 80 different projects/sheets ( ON 1301 to ON 1384) and in 11 different parameters - expenses, profits, taxes, etc....

    Is this possible, and can you help me?

  2. #2

    EXCEL example

    Here is the document I am working on.

    Thank you.
    Attached Files Attached Files

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    782
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by gcp View Post
    Is this possible, and can you help me?
    Pleas see attachment, if you can help this formula and a list of all the sheets.

    =INDIRECT("'" & ListSheets!A2 & "'!E6")
    Attached Files Attached Files
    Last edited by navic; 2014-02-01 at 07:01 PM. Reason: ad attach

  4. #4

    almost WORKING

    Quote Originally Posted by navic View Post
    Pleas see attachment, if you can help this formula and a list of all the sheets.

    =INDIRECT("'" & ListSheets!A2 & "'!E6")

    Dear NAVIC,

    your formula works but very few cells are giving a mistake I do not understand why?

    Can you check my file again?

    (I had to reduze the original for me to be able to upload it)

    Kind regards.
    Attached Files Attached Files

  5. #5
    The errors are in rows 09 / 10 / 12.

  6. #6
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    782
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by gcp View Post
    your formula works but very few cells are giving a mistake I do not understand why?
    You do not laugh at the name of the worksheet to have a blank sign (space) in front of the name worksheet
    You have to pay attention to the names are spelled correctly worksheets

    btw: It also performs, delete extra rows and columns that would have reduced the size of the file
    Attached Files Attached Files

  7. #7

    Perfect

    THANK YOU VERY MUCH!

    Sorry for the "stupid" last question...



    Quote Originally Posted by navic View Post
    You do not laugh at the name of the worksheet to have a blank sign (space) in front of the name worksheet
    You have to pay attention to the names are spelled correctly worksheets

    btw: It also performs, delete extra rows and columns that would have reduced the size of the file

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •