do you want a resort with the errors at the top or do you want to insert new
rows with the errors?
do you want the entire row with error, or just the cell with the error?
do you want to delete the original cell with the error, or leave it in place?
How do you identify the error?
how do you indicate the error?
do you want the macros to move the error, or a separate macro to more the
error?

an example of input data and format and prefered output format would be
usefull

We need some more details before we can answer your question. because there
are a lot of options.



"Daren" wrote:

I'm working with some data with about 30 fields. I've written macros to
capture errors within any of the fields. At this point I need to determine a
way to pull all of these errors to the top of the worksheet. How do I do
this. Thanks.