Yes, but you'll need to provide more details.

--
Ian
--
"daphoenix" wrote in message
...
is there a way after running a macro to save the results on a new sheet in
the same workbook.