Thread: formula to send data to 2nd sheet
View Single Post
 
Old 01-20-2016, 08:37 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,344
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
As I said in post #2, a formula can't show/hide rows. A formula to fill 'YES' gaps would be considerably more complex and you'd never know whether all the data were captured unless you made sure to have amply more rows with formulae than you have with 'NO' data to display.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote