Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking cells in different workbooks

Status
Not open for further replies.

merlynsdad

Programmer
Nov 18, 2010
175
US
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top