Easiest way is to use simple links
to extract the source cell/range contents in the other sheet

Something like this
In Sheet2,
You could place this in any start cell,
say in B2: =IF(Sheet1!A1="","",Sheet1!A1)
then copy B2 across/fill down to C3
to dynamically link it to Sheet1's A1:B2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"jimeeabaohe" wrote:
How do I transfer information in one spreadsheet to another and have the
second spreadsheet automatically update?

Jim Parson