Linking cells in different workbooks

[merlynsdad]

I have 24 workbooks, each with a summary row. I need to link each row with a similar row in a workbook that summarizes everything. I can do them manually by going to each cell, hitting =, then clicking on the cell in the other workbook, but selecting each cell individually will take forever. I don't want to use VBA, because the people maintaining these spreadsheets don't know it. Within a workbook I can highlight an entire row, or rows, and copy/link it to another worksheet. Is there a way to do this across workbooks?

If the square peg won't fit in the round hole, sand off the corners.

 

[randy700]

I don't want to use VBA, because the people maintaining these spreadsheets don't know it.

HUH? Why would they need to know VBA?
Build a macro and simply let them run the macro.


Randy

 

[merlynsdad]

I just did a copy/past special paste link and it works fine. Thanks.

If the square peg won't fit in the round hole, sand off the corners.