How do I copy cells that link several workbooks?

[Guest]

After linking the first cell of several workbooks, how do I copy the formula
to the other cells? When I do a regular copy/paste or drag the formula, it
gives me the same formula, not the new one for the next cell.

 

[Frank Kabel]

Hi
post your existing formula and your desired results for the other cells

 

[Guest]

Sorry, you lost me. I think I need my hand held on this one. What do you
mean by post my desired results for the other cells? I want all the cell B5
in all the workbooks to add to the summary page. Then I want all the cell B6
in all the workbooks to add to the summary page. When I copy the formula for
B5 into B6, I still get B5 results. How do I get B6 without going in and
changing the cell in the formula?

 

[RagDyer]

I don't know what formula you're using to sum *across* your sheets, but a
formula such as this will change as you describe, just by dragging down to
copy:

=SUM(Sheet2:Sheet4!B5)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Sorry, you lost me. I think I need my hand held on this one. What do you
mean by post my desired results for the other cells? I want all the cell B5
in all the workbooks to add to the summary page. Then I want all the cell
B6
in all the workbooks to add to the summary page. When I copy the formula
for
B5 into B6, I still get B5 results. How do I get B6 without going in and
changing the cell in the formula?