Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet

Discussion in 'Microsoft Excel Misc' started by Minitman, Feb 25, 2004.

  1. Minitman

    Minitman Guest

    Greetings,

    Is there anyway to place the value/contents of a cell (A1) on the
    active sheet into a cell (AA1) on an inactive sheet? Example: The
    contents of cell A1 on sheet 1 is a date. There are 19 other sheets
    with a date in A1, each date is different. I need the date from the
    sheet that I am on to sow up in cell AA1 on a sheet called Data. A
    formula on Data is looking to A1 on the active sheet to give a
    response to the active sheet from the list property of sheet 1. What
    I have was designed for only one sheet working with one Data sheet.
    If anyone has any ideas or samples of other possibilities, PLEASE
    reply, this is driving me up a wall!!!!

    TIA

    -Minitman
     
    Minitman, Feb 25, 2004
    #1
    1. Advertisements

  2. Minitman

    Tom Ogilvy Guest

    In Data put in this formula

    =INDIRECT(RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL("filena
    me")))&"!A1")

    After a calculate, this will return the value from A1 in the active sheet.
    This only works if the workbook has been saved at least once so it has an
    actual filename.

    --
    Regards,
    Tom Ogilvy


    "Minitman" <> wrote in message
    news:blush:...
    > Greetings,
    >
    > Is there anyway to place the value/contents of a cell (A1) on the
    > active sheet into a cell (AA1) on an inactive sheet? Example: The
    > contents of cell A1 on sheet 1 is a date. There are 19 other sheets
    > with a date in A1, each date is different. I need the date from the
    > sheet that I am on to sow up in cell AA1 on a sheet called Data. A
    > formula on Data is looking to A1 on the active sheet to give a
    > response to the active sheet from the list property of sheet 1. What
    > I have was designed for only one sheet working with one Data sheet.
    > If anyone has any ideas or samples of other possibilities, PLEASE
    > reply, this is driving me up a wall!!!!
    >
    > TIA
    >
    > -Minitman
     
    Tom Ogilvy, Feb 25, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. CBlev
    Replies:
    0
    Views:
    265
    CBlev
    Sep 9, 2003
  2. HM
    Replies:
    1
    Views:
    639
    dcronje
    Feb 6, 2004
  3. creativetechguy
    Replies:
    2
    Views:
    267
    creativetechguy
    Aug 5, 2004
  4. Guest
    Replies:
    0
    Views:
    155
    Guest
    Oct 21, 2005
  5. Woodstock

    Display contents of active cell in another cell?

    Woodstock, Mar 20, 2009, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,383
    Elkar
    Mar 20, 2009
Loading...

Share This Page