View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Suzanne Suzanne is offline
external usenet poster
 
Posts: 152
Default Copy Validation to next row

I have a spreadsheet with data validation drop-downs; the spreadsheet may
have 2 names or may have 200 names.

Need some help with code:

Where A1 = Name; B1 has validation dropdown

B2: If B1 < "" (if there is a name) then copy A1 validation dropdown to B2

Thanks -- Suzanne