displaying sales order equal to user input

[avilla]

:HI

can anyone help this beginner????

I have a worksheet that hold sales for one of our company depots fo
the year todate. There are over 1000 sales and i would like to create
macro using VBA that allows me to enter a date into an inputbox whic
then filters and displays the records with the same date.

I have been trying to do this for almost two weeks now and i just ca
not do it

Please Help!!!!

 

[JMay]

as a beginner, why not just use the Data, Auto-Filter Tool;
It works wonders!!

 

[avilla]

I am trying to create a macro to filters the invoice date colum

 

[Dave Peterson]

See one guess at your other post.

:HI

can anyone help this beginner????

I have a worksheet that hold sales for one of our company depots for
the year todate. There are over 1000 sales and i would like to create a
macro using VBA that allows me to enter a date into an inputbox which
then filters and displays the records with the same date.

I have been trying to do this for almost two weeks now and i just can
not do it

Please Help!!!!!