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.

You didn't post any examples or details, you might want to do so if
you want help.

If you just want information you type in one cell to appear in another
cell, check out: http://office.microsoft.com/en-us/ex...CH100648431033

HTH,
JP

On Jan 11, 2:42*pm, 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.

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.