New excel sheet

  • Thread starter Thread starter bt707
  • Start date Start date
B

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.
 
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.
 
Back
Top