Printing, Sorted list of matching criteria
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?
Re: Printing, Sorted list of matching criteria
Sure. You can start it by recording a macro.
Re: Printing, Sorted list of matching criteria
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.
Re: Printing, Sorted list of matching criteria
Well seeing as you have not posted any code, it is difficult for me to guide you.
Re: Printing, Sorted list of matching criteria
Justin, Please check out the .Find Tutorial in my link.
Sid