file saving macro

Dear everyone,

this is my inventory file my assistant is reporting everyday movement by filter todays date saving it to pdf then send it to me unfortunately everyday i have to do page breakview setting then save...can someone please make macro for me in which while pressing the button it ask for date after putting the date it save that day movement in a pdf ....il highly appreciate your help the tab is 'movement'in the attachment

regards

thanksssssss

.
Hello.
> You put the date in O2, and
> Double click on O1
.

Please Login or Register  to view this content.