I've been trying to find a solution to this problem but I just cant find one.
I have a series of excel workbooks, each corresponds to maintenance orders. Then I have a master list on an excel workbook with information regarding each maintenance order. These are done on a weekly, bi-weekly, monthly, quarterly, yearly basis. On the master list, the orders show a status that tells how urgent the order is, I also have a status that just tells if the order is due at the end of the week or not. I would like to be able to print out the orders that are due at the end of the week (which are workbooks) by pressing one button. Currently I do have a macro, that someone here was kind of enough to help me with, that prints out workbooks in a certain folder with the certain file format that the maint. order have but I havent figured out how to sort which files go into this folder.
I realize thats probably confusing so please let me know if you have any questions and I will post up some dummy files to help explain. Also I have been searching like crazy but if there is a similar question answered, I apologize and please point me in that direction. i would really appreciate any help. Thank you in advance.
Bookmarks