Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default copying data from one worksheet to several based on criteria

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default copying data from one worksheet to several based on criteria

On Jul 30, 6:24*pm, marcia2026
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), 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


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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying data based on filter criteria no_rhythm Excel Worksheet Functions 1 January 10th 08 10:45 PM
Copying data based on certain criteria [email protected][_2_] Excel Programming 4 April 10th 07 02:22 PM
Transferring data from one worksheet to another based on criteria dread Excel Discussion (Misc queries) 5 July 28th 06 07:37 PM
Copying data from one worksheet to another based on criteria Caatt Excel Discussion (Misc queries) 1 June 15th 06 10:19 AM
Cut & Paste Data into different worksheet based on specific criteria hailnorm[_2_] Excel Programming 2 December 6th 03 11:56 PM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"