displaying specific cells of a row based on a date search

[wv1973]

Hi and thanks in advance for the help

First off let me describe the date I'm working with.

On my master document I have columns A to BH. In column AC is the date, and this is what I will be basing my search on.

What I am trying to do is a date search. For example: If the date is >= 01 jan 09 and <= 01 feb 09 display column A, D, H, L of that Row.

The date range will be inputed by the user on a different tab within the same excel document.

I'm hoping I explained this clearly, where should I start with this problem. From what I'm reading in the other threads I'm guessing this is a VLookup scenario.

Thanks,

Wade

[davesexcel]

Hi wv1973,

AutoFilter would work great for this.

A quik sear gave me this, there are many topics on autofilter in the form

http://www.excelforum.com/excel-prog...tom-dates.html

[wv1973]

Hmmm that article has me lost. I'm attaching a sample of what I'm trying to accomplish. There is a tab for data and a tab for where I wish the data to be displayed.

So basically the search is going to be with a date range. In my example we are searching from 01 jun 09 to 05 nov 09.

Within this range the data will be displayed by the following catagories.

Refunds, Revokes and Void
so if a row falles within the date criteria and is voided the 3 cells that will be copied over to the report sheet is the Bkg Ref, TKT# and CC#

The report is broken down in this way and will likely contain more elements, but seeing how this is done will at least give me a handle on how to integrate the other elements.

So would you say that this is still an Autofilter, and if so how, or where can I read how to with this example in mind.

Thanks,

Wade

[davesexcel]

Try this, open the workbook and enable macros, click the button to filter.

[wv1973]

Thank you very much for the example. I'll review it and see if I can wrap my brain around the coding. I'll likely be back with questions : )

[wv1973]

OK well, this is a bit over my head I think, but I'm trying to understand the coding. The data generated in my report can sometimes range from a couple of lines to hundreds. I changed the template a bit by having the Refunds, revokes and voids all generate in their own tab.

I tried modifying the code a bit, but I had problems.

1 problem was when I generate the report all is displayed fine, but when I type in a different date range I get an error. Is there a way I can do a simple reset prior to performing another search?

I see in the code that you have the worksheets identified as WS1 WS2 etc.. do I need to name the tabs this, or is this the default name.

This is definitely on the track of what I'm looking for, and I really appreciate your help.

PS. I attached another document with the layout changes I described above.