View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Pete
 
Posts: n/a
Default Verification/Import of data

In your second sheet you enter a formula like:

='Sheet 1'!A1

to bring the value from cell A1 into the cell where the formula is
(assume A1 also). Whenever you change the value in the first sheet, the
second sheet's value will also change. The formula can be copied across
and/or down the second sheet to bring values from other cells on Sheet
1 - it will not copy the formats, however.

Hope this helps.

Pete