Originally Posted by excelDuffer

Attaching a smaller version (.zip format was the only one I could get in under the size limit). In this copy, I want to read Sheet1!C4, and create a link in Sheet1!D4 that points to Sheet2!E7. Fill in the pattern, etc.

Please let me know if this requires any clarification.

Thanks