linking pages in two different work books

[modicum21]

trying to link two different pages in two seperate workbooks.
filling in statistical data in first workbook in
specific fields. then having to open the next work book and insertin
the same in formation again. don't wnat to be redundent and would lik
to populate worksheet in workbook 2 with the same input from workshee
in work book

 

[Marioette]

I am also in need of this ability.
I have a list on one sheet and a chart with the names from the list o
another, same workbook. I have been linking each individual name fro
the list to their location on the chart. When I delete the name i
clears it, but I need it to also be able to move names to a ne
location on the chart when that name goes to a new department heading

 

[123]

it's very simple to link sheets in this way, just enter the = sign i
the cell you want the data to apper in, then click on the cell whic
contians the data you want to link:
see help on linking workbooks for more info
it's easy reall