View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
plumfin plumfin is offline
external usenet poster
 
Posts: 7
Default Only show cells if they have data in them

I am designing a price list, which different branches will use different
options on, ie, some will offer products A and C, but not product B; others
will offer all 3. I am struggling to work out how to design this as a macro.
The idea would be that if they "tick" A, B and C, then they would then be
promted to put in some prices, which would in turn generate further
discounted price lists. Any ideas? thanks, Kelly