I have a control workbook with 25 sheets in it, one for each workday. At the
end each of day, I would like to copy the information from the control sheet
to several sheets based on the criteria. I am currently using the macro that
I copied from Ron de Bruin's tip page. (I can't thank him enough), but I
would like to make one change and be able for the user to specify the
worksheet to copy from and to be able to name the new sheets. Can anyone
help please???
thanks,
marcia

On Jul 30, 6:24*pm, marcia2026 <marcia2...@discussions.microsoft.com>
wrote:
> I have a control workbook with 25 sheets in it, one for each workday. *At the
> end each of day, I would like to copy the information from the control sheet
> to several sheets based on the criteria. *I am currently using the macro that
> I copied from Ron de Bruin's tip page. *(I can't thank him enough), butI
> would like to make one change and be able for the user to specify the
> worksheet to copy from and to be able to name the new sheets. *Can anyone
> help please???
> thanks,
> marcia

Can you be more specific -- what options / variables determine what
page gets what? If I was to approach this type of thing I would have
IF statements control that type of thing...

Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then
Sheets("MySheet1").Range("A1").Value =
Sheets("MySheet2").Range("B1").Value
End If
End Sub

Private Sub OptionButton2_Click()
If OptionButton2.Value = True Then
Sheets("MySheet1").Range("A2").Value =
Sheets("MySheet2").Range("B2").Value
End If
End Sub