Is this possible in a macro?

[booey]

Hi,

I imagine my questions is possible, but I am not sure how to do it since I am fairly new to macros.

I have spreadsheets that I need to do an autofilter on and then cut/copy and paste the filtered results to a new workbook. That is simple enough, but is it possible to run a macro that prompts the user for the filter criteria and then prompt again on what to rename the workbook to once the data has been pasted? Or is it possible to automatically rename the workbook with the same name as the filter criteria?

Thanks a lot for the help.

 

[booey]

I noticed a mistake in terminogy. I meant, is it possible to rename the worksheet ,not the workbook based on the filter criteria?

Thanks,