Macro update to sort between two dates

[sungen99]

As the macro runs now it gives you the option to choose a salesman (Sheet2 B1) and a maximum date (Sheet2 B2) and then it does its breaks down.

I need to add two more levels of functionality which are obviously beyond my VBA ability.

1) I need to add a minimum date (Sheet2 B3) so eventually you are able to give the beginning and ending dates for the search.
2) I need to also add the ability (you can see I added “ALL” to the drop down menu (Sheet2 B1) to choose ALL salesmen and have the macro then break down the lists including them all.

Thank you for your assistance.

[AB33]

Between dates meant <max and >min.

[sungen99]

In between dates is working great but the ALL function seems to not. What I would like it to do is just ignore the salesmen names and just sort them into the correct columns.

[AB33]

Where are the names of sales man? I thought, you use sales man as the value to find. Did you check the result in sheet2. All I did to you code is to include all sales man, that is, all names in column B needs to be searched.

[sungen99]

Sales names are H2:H6 on sheet1.
When i say ALL and run the macro now. it should show all data for each color ignoring the salesmen. It looks now like its repeating.

[AB33]

No, I am missing something. The code you have selects the sales man from B1 and finds all, let's say, Tim's data.
By ALL, you meant you want to select all sales men. Is this right? If so, you have repeated names in column B. Please include a sample out put.

[AB33]

Sorry!
You are right! It is repeating, so I need to use a unique column names which is column H.

[PCI]

A tempoarary solution just for the Min and Max Dates

Please Login or Register  to view this content.