Create a report sheet instead, which reads and displays data from your original data sheet! As additional bonus, on report sheet you can have one or several fields, where user can enter/select filter conditions for report - so essentially you get different report for every set of conditions.
|