Thread: Cell contain default value of cell above it
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default Cell contain default value of cell above it
Use data validation:

Select column to validate e.g. E select Data-validation,tyep List, now
type formula: =OFFSET(E1,-1,0).

DM Unseen

Reply With QuoteReply With Quote