I created a report in Excel that uses a data validation list of Unique IDs which is automatically added to the validation list in report card 2. By selecting an ID, the contents of the report update with the relevant data. I would like to create a macro that can select and print all the report of each ID selected in the validation list till it reaches the last ID in the validation list.:I need a vb code to perform this task. I will be glad , for any help.