Create Worksheets based on column data

's Computer Specifications

I have a spreadsheet that contains dates in a column.

I'd like to create a macro that will copy and paste anything with
3/1/08-3/31/08 into the MAR08 sheet

anything with dates between 4/1/08 and 4/30/08 into APR08 sheet.

Any suggestions?

Thank you

's Computer Specifications

You can use EasyFilter
http://www.rondebruin.nl/easyfilter.htm

Or a macro
See the autofilter example and the text below the macro
http://www.rondebruin.nl/copy5.htm#AutoFilter

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Clara" <(E-Mail Removed)> wrote in message news:E405078D-4CDF-4B23-BFC0-(E-Mail Removed)...
>I have a spreadsheet that contains dates in a column.
>
> I'd like to create a macro that will copy and paste anything with
> 3/1/08-3/31/08 into the MAR08 sheet
>
> anything with dates between 4/1/08 and 4/30/08 into APR08 sheet.
>
> Any suggestions?
>
> Thank you

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert Worksheets based on column data.	malycom	Microsoft Excel Programming	10	1st Feb 2010 11:11 AM
Can I create a form with column headers based on the data for data editing?	Stapes	Microsoft Access	1	15th Jun 2007 05:30 PM
Create New Worksheets based on Pivot table data	=?Utf-8?B?RGVl?=	Microsoft Excel Programming	2	22nd Nov 2006 08:09 PM
Dynamically create worksheets in Excel based off existing data?	=?Utf-8?B?dGxvemllcg==?=	Microsoft Excel Misc	1	10th Sep 2005 12:25 AM
Create Worksheets Based Upon Changing Column Values in XP	Gary	Microsoft Excel Programming	1	18th Dec 2003 12:07 AM