Hi Sasikiran,

Copy you formula (or range of cells) that is in workbook 1.
Go to where you want it repeated in workbook 2 and 'Paste Special' - 'Paste
Link'

Mike

"Sasikiran" wrote:

Hi,

I have two workbooks in two different folders. I want to link both the
workbooks in such a way that what ever data I enter in the first workbook
should automatically appear in the second workbook.

Thanks in advance