Need to generate Open Order Report Filtered By Customer and Due date

[frank_m]

Edit: before wasting your time reading any of this, Please refer to Edit comments near bottom of this post .

Hi Mark,

Thank you so much for putting this much time and creativity into your solution, towards making it even more user friendly than what I asked for.

Will this run in Excel 2003 ?

I'm getting this error.
Error Message: Can’t find project or library

Code stops at Trim in this line
Application.Match(Trim(ActiveCell.Value), .lstCustomers.List, 0) - 1

So I tried removing Trim

ran it gain and it stops and highlights in blueTrim at the next Trim
DIC.Item(Trim(ary(n, 1))) = Empty

Remove that Trim and ran it again.
it stope at UCase
If UCase(ary(i)) < UCase(COL.Item(n)) Then

removed UCase
and tried again
Now it stops at ReDim aryTmp(0 To COL.Count - 1)

Where I have underlined is highlighted in dark blue , like what you get when you select text with the mouse

in the vbe references box it says MISSING VBHTMLMaker.xla Can we do something different so that we will not need an ADDIN ?
I ask that because this will be distributed to several users, using both Excel 2003, 2007 and 2010 and prefer that deployment be effortless.

Edit: I figured it out. The reference I described is not needed. I unchecked it, and it runs fine.. I'm guessing you had it in there for some other project.


Code and userform are very cool. - Print setup and sheet layout, are exactly as I wanted. -- Thanks a million Mark

I'll test more tomorrow evening.

--------------------------------------------------------------
[]

Hi shrivallabha,

Thanks for your code. I have to sleep now, but I will try in out in about 12 to 16 hours from now.

[]