View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rick is offline
external usenet poster
 
Posts: 334
Default linking values and formats on from different sheets

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....