Help Extracting Data Based On two Criteria

**chadha.hitesh** · 11-09-2010, 06:01 AM

Help Please

i would like to extract data based on two criteria mode = cheque

Second receipt date = todays date

**Bob Phillips** · 11-09-2010, 06:31 AM

Create a pivot table and then filter on mode and date.

**chadha.hitesh** · 11-09-2010, 06:33 AM

i want it Automatically only for today date not all

**alansidman** · 11-09-2010, 09:03 AM

After you pivot the data, filter it on the mode and date to get your expected results.

Alan

**Bob Phillips** · 11-09-2010, 10:36 AM

Originally Posted by chadha.hitesh

i want it Automatically only for today date not all

As I saidk, filter on the required date.

**chadha.hitesh** · 11-09-2010, 10:47 AM

BoB

i want it with the Help of Autofilter VBA macro

**JBeaucaire** · 11-09-2010, 11:08 AM

Chadha, if that's all you want, turn on the macro recorder and let it record you filtering your data the way you want. Then ask specific questions about the macro you created and how you want to improve it.

Help Extracting Data Based On two Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Help Extracting Data Based On two Criteria

Re: Help Extracting Data Based On two Criteria

Re: Help Extracting Data Based On two Criteria

Re: Help Extracting Data Based On two Criteria

Re: Help Extracting Data Based On two Criteria

Re: Help Extracting Data Based On two Criteria

Re: Help Extracting Data Based On two Criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions