Programming Questions? Ask a Programmer for Answers ASAP
If I were doing this I would not do it with a row hide. I would do it with a second sheet. I would have one sheet with all of the rows with all the data, and then another tab with all the data that meets the criteria that you have laid out.
Not only is it easier, but it is much cleaner than hiding and unhiding rows.
Please let me know if this is an option, because as I stated it make for a cleaner process, and a smoother way to present the data.
if we want to copy and paste to another sheet the best method would be a macro as opposed to a formula, since a formula wouldn't do the copy paste for us.
try a website like sendspace.com, upload the file, then they give you a link. Paste that link here, and I will take a look and see what needs to be done and figure out a price to do it.