Is this possible in a macro?

booey

New Member
Joined
Dec 5, 2005
Messages
2
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.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

booey

New Member
Joined
Dec 5, 2005
Messages
2
I noticed a mistake in terminogy. I meant, is it possible to rename the worksheet ,not the workbook based on the filter criteria?

Thanks,
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,092
Members
412,310
Latest member
mark884
Top