| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using macro to copy paste
hi....
I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4 at sheet 2 without open sheet 2. Can anyone help me on this.. rgds |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using macro to copy paste
Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1")
Regards, Stefi €˛ramzi€¯ ezt Ć*rta: hi.... I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4 at sheet 2 without open sheet 2. Can anyone help me on this.. rgds |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using macro to copy paste
Please follow following steps
1. add control toolbox to the toolbar (toolbarrightclickcontrol toolbox) 2.add a command button on worksheet 1 3.Right click command buttonview code 4.then add following code in the code window:- Private Sub CommandButton1_Click() dim i as integer For i=1 To 4 Application.Worksheets("sheet2").Cells(i, 1).Value= Application. Worksheets("sheet1").Cells(i, 1).Value next End Sub Now You got it! Have a happy time..... Chris ------ Convert your Excel spreadsheet into online calculator. http://www.spreadsheetconverter.com -- Chris ------ Convert your Excel spreadsheet into online calculator. http://www.spreadsheetconverter.com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200901/1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using macro to copy paste
Thank you Stefi...
"Stefi" wrote: Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1") Regards, Stefi €˛ramzi€¯ ezt Ć*rta: hi.... I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4 at sheet 2 without open sheet 2. Can anyone help me on this.. rgds |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using macro to copy paste
You are welcome! Thanks for the feedback!
Stefi €˛ramzi€¯ ezt Ć*rta: Thank you Stefi... "Stefi" wrote: Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1") Regards, Stefi €˛ramzi€¯ ezt Ć*rta: hi.... I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4 at sheet 2 without open sheet 2. Can anyone help me on this.. rgds |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to copy and paste (to much for me) | Excel Discussion (Misc queries) | |||
| copy and paste using macro | Excel Discussion (Misc queries) | |||
| Copy/Paste Macro | Excel Discussion (Misc queries) | |||
| Should I use a macro to copy and paste value? | Excel Worksheet Functions | |||
| Copy Paste macro | Excel Discussion (Misc queries) | |||
Linear Mode
