Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
go to sheet1 to sheet2
Hi please, I would like to have some help: I woul like to transfer data from sheet1 to sheet2. For example , if I have in sheet1 A1=12 B1=15 C1=5 D1=8 E1=9 And I want in sheet2: A1=12 B1=15 C1=5 D1=8 E1=9 Please give me the formula. I did some research, but I did no understand what they were talking about!! Please Give me also the formula for A1, A2, A3 A4 (for an array) fro sheet1 to sheet2 Please Be precise.. Thank you Bra -- bradd ----------------------------------------------------------------------- braddy's Profile: http://www.excelforum.com/member.php...fo&userid=1982 View this thread: http://www.excelforum.com/showthread.php?threadid=46906 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
go to sheet1 to sheet2
see if this will work for you
Option Explicit Dim lastc As Long Sub copyrow() lastc = Cells(1, Columns.Count).End(xlToLeft).Column Cells(1, 1).Resize(1, lastc).Copy Worksheets("sheet2").Range("a1").Activate ActiveSheet.Paste End Sub Gary -- Gary "braddy" wrote in message ... Hi please, I would like to have some help: I woul like to transfer data from sheet1 to sheet2. For example , if I have in sheet1 A1=12 B1=15 C1=5 D1=8 E1=9 And I want in sheet2: A1=12 B1=15 C1=5 D1=8 E1=9 Please give me the formula. I did some research, but I did not understand what they were talking about!! Please Give me also the formula for A1, A2, A3 A4 (for an array) from sheet1 to sheet2 Please Be precise.. Thank you Brad -- braddy ------------------------------------------------------------------------ braddy's Profile: http://www.excelforum.com/member.php...o&userid=19827 View this thread: http://www.excelforum.com/showthread...hreadid=469068 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display a value from Sheet1-A1:A10 in Sheet2-B1 | Excel Worksheet Functions | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
VALUES CORRESPONDING FROM SHEET1 / SHEET2 | Excel Programming |