View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MrRJ MrRJ is offline
external usenet poster
 
Posts: 109
Default Dissect a file into several sheets or files

Hi,
I have a spreadsheet that I would like to dissect into smaller reports based
on certain criteria in several columns. What is the best approach to this?
Create a macro, if so, can you give me an idea on howabout to do so?
There are 20+ columns and more than 5000 rows.
I can filter certain things in several different rows. After I am done with
my filters, I want to copy the end product to another sheet or file.

I welcome suggestions on the best approach to get this done.
MrRJ