Hi,
I really need help with a spreadsheet at work.
It is basically a list of sales orders that are taken from NAV18 via Microsoft Query along with comments that each department fills in to let us know the status of the sales order. This sheet gets refreshed often and updated manually at the moment, but I really need to figure out some VBA that will filter Column D (dates) to include all the items in the list before 2 days in the future. For instance today (Wednesday) all dates before that plus tomorrow and Friday and change dynamically daily.
Is there any way VBA can help me with this? There are many non tech savvys along with myself at work, Ideally we just want to press the macro button to refresh sort and filter our data.
Any help would be really appreciated.
Bookmarks