I have a file I import from Mainframe to Excel. A new request requires that
the data be filtered and split into 6 different sheets. Since I can have up
to 8 criteria requirements on 1 field, I understand I cannot use an Auto
Filter. It looks like I can use the Advanced Filter, but then I need to copy
the filtered data (you can only copy filtered data to the active sheet) to
the original data import sheet instead of immediately copying it to the
individual sheets. That means I then need to copy each individual filtered
range and paste into the specified sheet. Am I understanding this correctly,
and/or is there a better way of doing this? Thanks for any help with this; I
really appreciate it.