If you're using QV11 you can create alternate states and assign the different alternate states to the different sheets. You can then apply selections to the separate alternate states so in one sheet (alternate state X) you select one year and in the other sheet (alternate state Y) you select multiple years. You can use Select in Field actions assigned to a button (or text box) to do that. Macro's are not needed. If you still want to use macro's you'll have to figure that out yourself. I have no idea if alternate states can be used in macro's.