If its all formula driven then the data wont be static, i.e if Sheet2 A1
had a forumula like =Sheet1!A1 it will show you the data that is
currently in sheet1 cell A1 if you change the data in sheet1 cell A1 the
data will change in sheet 2. To be honest your question doesn't really
explain much, feel free to join our forum and make a post where you will
be able to upload a workbook for people to take a look at.


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26436