How do you automate cells to poplulate fields in separate workshee

[newexcelerator]

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.

 

[JP]

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/excel/HP101023431033.aspx?pid=CH100648431033

HTH,
JP

 

[Gord Dibben]

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 Edit>Paste Special>Paste Links>OK>Esc.


Gord Dibben MS Excel MVP