I am using Excel97 and want to know how to change links to another worksheet
in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in
workbook OTB1. In a separate workbook, I have linked the values from
worksheet OTB DEC in column A. In column B I need the same exact cells
linked, but from the the worksheet OTB JAN. How can I do this without having
to either relink column B or type over "OTB DEC" with "OTB JAN" in every
cell? I cannot use change source because they are both from the same
workbook, OTB1.