Are you speaking of two worksheets?

In Target sheet in a cell type = sign then switch to source sheet and select a
cell and hit ENTER key.

Target cell formula will be =Source!cellref and will update as Source cell
gets changed.

These formulas can be copied down or across.

Alternative.................select a range of cells on Source sheet and Copy.

Switch to Target sheet, select a cell and EditPaste SpecialPaste LinksOKEsc.


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 11:42:01 -0800, newexcelerator
wrote:

I am trying to automate my reports so that when I enter data in a detail
report (base report) that same data gets populated in the pertinent related
field on a top roll report.