Printing, Sorted list of matching criteria

[hensucker]

hello for example, sheets(5) has cell B5 (which is a drop down of dates) then cell C5 (is a drop down of certain initials) i would like to choose a combination using these 2 fields, press a commandbutton, a macro will then find all matching entries for that date and initial on sheets(3) and printed in a sorted fit to page list, is this possible?

[MarMan]

Sure. You can start it by recording a macro.

[hensucker]

thats the easy part, i can write the code for the printing command thats no issue, its the how to find the data match the data, print the data i requested.

[MarMan]

Well seeing as you have not posted any code, it is difficult for me to guide you.

[Siddharth Rout]

Justin, Please check out the .Find Tutorial in my link.

Sid