| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data
I am trying to set up a macro to copy info from one sheet
to multiple sheet but in the next available slot. Example Copy sheet1 data A5 to d5 and paste it to sheet 2 & 3 for the next available A? on sheets 2 & 3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying Data
worksheets("A4:D5").Copy _
Destination:=worksheets("Sheet2").Cells(rows.count ,1).End(xlup)(2) worksheets("A4:D5").Copy _ Destination:=worksheets("Sheet3").Cells(rows.count ,1).End(xlup)(2) -- Regards, Tom Ogilvy "Dan" wrote in message ... I am trying to set up a macro to copy info from one sheet to multiple sheet but in the next available slot. Example Copy sheet1 data A5 to d5 and paste it to sheet 2 & 3 for the next available A? on sheets 2 & 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying rows of data into new worksheet but placing data into colu | Excel Discussion (Misc queries) | |||
| copying data | Excel Worksheet Functions | |||
| Copying data as static as source data changes | Excel Worksheet Functions | |||
| Copying Data into Column with Existing Data | Excel Discussion (Misc queries) | |||
| Copying data down to next dirty cell, then copying that data | Excel Programming | |||
Linear Mode
