| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy from one source sheet to numerous destination sheets
Each row in my source worrksheet has data to be entered into many destination
worksheets. I have tried the following: Windows(Source).Activate Range(row, 2).Select Selection.Copy Windows(dept & ".xls").Activate Worksheets("Info").Activate Range("C3").Select ActiveSheet.Paste My problem is that the "Range(row,2).select" command does not work. Can someone provide me with a command line which would work. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible? Dynamic copy/paste source AND destination? | Excel Programming | |||
| copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
| copying one entire row from a source sheet to a destination sheet | Excel Programming | |||
| copying and pasting from source sheet to destination sheet without naming source sht? | Excel Programming | |||
| Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
