Excell 2000 Problems

[dbell6]

I have three work sheets. The last two will pull the information fro
my first worksheet. When I try to add another work sheet it will no
pull the information from the first page like the others. What am
doing wrong? I have tried to cut, copy and paste the formula but i
still won't work. I have also tried linking each cell separately, thi
works but it will take forever.

Much help appreciated.

Dustyn
:confused

 

[Debra Dalgleish]

If you have one link working on the third sheet, you can use the
AutoFill feature to quickly copy it to adjacent cells.

Select the cell that has a working link.
Point to the Fill Handle -- the small black square at the bottom right
of the selection
When the pointer changes to a black plus sign, drag to the right to
copy the formula across (or drag down, left, or up to fill in
other directions)