View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Excel: with an if condition display a row of cell if true


Copy the data that you want from the main worksheet and then paste it
into the other worksheet but don't just paste it, select "Paste
Special" then select "paste as link" hit OK.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495632