Copy Rows In New Sheet Based On Date Range Criteria

**ahmedwaseem2000** · 12-10-2006, 02:51 AM

Hi,

I am trying to copy rows from sheet1, In which the column A is a date column. When the sheet2 is selected I want an input box to pop up and take 2 dates as input. All the rows between those 2 dates should be copied in sheet2.

Thanks for your help!!

**VBA Noob** · 12-10-2006, 04:51 AM

Hi,

If you don't need the buttons and want more flexiablilty for the filtering I would try an advance filter.

The attached has an example for you

http://www.meadinkent.co.uk/xlfilter.htm

Hope it helps.

VBA Noob

**ahmedwaseem2000** · 12-10-2006, 05:10 AM

Thanks for your reply, but I need to take the inputs from the user. like using the input box taking the begin date and the end date. could you please help me again????

**VBA Noob** · 12-10-2006, 05:45 AM

Hi,

Try recording a simple filter or adapting the advance filter example and add in this simple input. Change the bold to the filter ranges

Please Login or Register  to view this content.

VBA Noob

Copy Rows In New Sheet Based On Date Range Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Copy Rows In New Sheet Based On Date Range Criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions