Thread: freeze cell reference when inserting a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rod Rod is offline
external usenet poster
  
Posts: 108
Default freeze cell reference when inserting a row
I have two worsheets A & B. I have linked cell D4 in A to D2 in B. When I
insert a row into B, I would like cell D4 in A to always display the
contents of D2 regardless of the number of rows i insert at that point. Can
anyone help me?
Reply With QuoteReply With Quote