Linking many cells

[bbbngowc]

Hello All,

Question:

I know I can link a cell in one Excel Worksheet to a cell in another Excel Worksheet. How can I link Many Cells at once to another group of Cells in another worksheet? I really do not want to link each cell one at a time. I'm talking 300 cells in about 400 Worksheets. I'd rather do a group all at once.

Any suggestions?

[bbbngowc]

I figured it out. Really easy actually. Just Highlight and copy the cells you want to link and then 'paste special\paste link' to the workbook you to link to.

Thanks for looking.