Results 1 to 3 of 3

Thread: the contains of a cell with the contents of another cell

  1. May 19th, 2009, 10:00 PM #1
    Art W.
    Art W. is offline

    Thread Starter
    Hyperactive Member Art W.'s Avatar
    Join Date
    Apr 2002
    Location
    In My Own Little World, But that’s OK because they know me there!
    Posts
    271

    the contains of a cell with the contents of another cell

    Hello Everyone:

    I am using Excel 2007, I am trying to fill the contains of a cell with the contents of another cell, so that when the first cell is changed the second cell is updated automatically. If I put the following code in the contains of the cell is updated. But if I go back and change the first cell nothing happens.

    ='[A565]565 A'!C14

    What am I doing wrong?

    Thanks

    Art
    SLEEP: A Totally Inadequate Substation For Caffeine!
    Reply With Quote Reply With Quote
  2. May 20th, 2009, 02:14 AM #2
    anhn
    anhn is offline
    Head Hunted anhn's Avatar
    Join Date
    Aug 2007
    Location
    Australia
    Posts
    3,669

    Re: the contains of a cell with the contents of another cell

    Press F9 or set Auto Calculation to On.
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • If your question was answered please use Thread Tools to mark your thread [RESOLVED]
    • Don't forget to RATE helpful posts

    • Baby Steps a guided tour
    • IsDigits() and IsNumber() functions • Wichmann-Hill Random() function • >> and << functions for VB • CopyFileByChunk
    Reply With Quote Reply With Quote
  3. May 21st, 2009, 08:43 PM #3
    Art W.
    Art W. is offline

    Thread Starter
    Hyperactive Member Art W.'s Avatar
    Join Date
    Apr 2002
    Location
    In My Own Little World, But that’s OK because they know me there!
    Posts
    271

    Re: the contains of a cell with the contents of another cell

    Sorry, neither of them worked.

    Art W.
    SLEEP: A Totally Inadequate Substation For Caffeine!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width