New excel sheet

[bt707]

I have a excel sheet that compares to columns of numbers for differences
and highlights them, is there any way to run a scipt that will
automatically make a new excel sheet and import the different numbers
into it.

Thanks for any help.

 

[Tom Ogilvy]

Worksheets.Add

will add a worksheet

Beyond that, it would be difficult to provide sample code. If you are using
code to do your highlighting, then just modify the code to copy the cells to
the new worksheet as well.