Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying records to another worksheet
I am currently using Ron de Bruin's macro that copies unique values to
separate sheets. Currently, they copy into the same workbook. I would like for them to copy into separate workbooks. I have tried his other macro for copying to separate workbooks, but it creates a new workbook each time you run the macro. I have 3 unique values in the control sheet. The control workbook has numerous worksheets because a new one is created for each working day of the month. With your help I have been able to specify which sheet is being copied and how to give the new sheets a unique name, but I would really like for those sheets to in copy into specific folders set up in the master folder. Master folder would have these four workbooks: Control, MV, RMS, BE. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying records to another worksheet
What is wrong with these statements?
Sheets.("RMS" & " " & ws1.Name).Select Sheets("RMS" & " " & ws1.Name).Move Befo=Workbooks("RMS.xls").Sheets(blank) <<< it bugged out here Sheets("MV" & " " & ws1.Name).Select Sheets("MV" & " " & ws1.Name).Move Befo=Workbooks("MV.xls").Sheets(blank) I recorded a macro moving these sheets to another workbook, and pasted it in at the end of the macro. "marcia2026" wrote: I am currently using Ron de Bruin's macro that copies unique values to separate sheets. Currently, they copy into the same workbook. I would like for them to copy into separate workbooks. I have tried his other macro for copying to separate workbooks, but it creates a new workbook each time you run the macro. I have 3 unique values in the control sheet. The control workbook has numerous worksheets because a new one is created for each working day of the month. With your help I have been able to specify which sheet is being copied and how to give the new sheets a unique name, but I would really like for those sheets to in copy into specific folders set up in the master folder. Master folder would have these four workbooks: Control, MV, RMS, BE. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple records for the same vendor | Excel Worksheet Functions | |||
copying rows to all possible records during a macro | Excel Programming | |||
Copying records from a date interval from one worksheet to another | Excel Discussion (Misc queries) | |||
Copying records to another sheet | Excel Discussion (Misc queries) | |||
Copying records from sheet1 to sheet2?? | Excel Programming |