Hi Everyone,
I decided to step into Marcos. I ran into a roadblock. I watched a few videos on the subject and I am running into Issues. It appears as though the videos I have been watching involve using FIELDS to filter data rather than VALUES within one FIELD. I need to filter and use a macro where all of the parameters/filters are in one field. Here is my scenario. I have made a lot of reports that are used department wide. Each Manager will print out the report for their supervisors. Now the supervisors would like to print out the reports for their individual officers. I am trying to make a macro where the Supervisor picks a name (officer) from from the input tool and the report filters to only show that officers information. I need some help with this macro. It seems so simple but I am stuck.
Summary:
Develop a macro for user input to select a specific person
Filter all data in report on that person
john