i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable me to reduce the file size before i send it.
ok to explain why i cant just copy:
many thousands of rows down under the table the user has created complex formulas and graphs which wont carry if i copy across to another worksheet if i just copy the rows :*(