merlynsdad
Programmer
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.
If the square peg won't fit in the round hole, sand off the corners.