Hi Rick,

Need some confirmation of about your requirement re breaking the links.

Assume that if Sheet1 cell A3 is linked to Sheet2 cell A3.

You sort Sheet2 and the contents of cell A3 finishes up in cell A7.

Which cell do you now want linked to Sheet1? (A3 or A7)

Regards,

OssieMac


"Rick" wrote:

I have a set of data (and cell formating) on sheet A that I'd like to copy
over onto sheet B. The trick is that I'd like to ultimately sort sheet B
differently than A.

Could anyone tell me if it's possible to link not only data between sheets
but also formats and how I'd accomplish this?

Assuming success, can the rows be resorted without breaking the links to
sheet A?

Thanks....