Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Formula
Hello,
How could can copy the data from sheet1 to sheet use VB formula? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Formula
One way:
Sheets("Sheet1").UsedRange.Cells.Copy _ Destination:=Sheets("Sheet2").Range("A1") In article , bowling wrote: Hello, How could can copy the data from sheet1 to sheet use VB formula? Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Formula
Cheers mate. How to bring all the data that i type in sheet1 to sheet2? Is
that posibble to split the data? For example in sheet1 i enter John 22 male, its should come under male table in sheet2 and if i type beth 24 female and it should come under female table in sheet2? Thank you "JE McGimpsey" wrote: One way: Sheets("Sheet1").UsedRange.Cells.Copy _ Destination:=Sheets("Sheet2").Range("A1") In article , bowling wrote: Hello, How could can copy the data from sheet1 to sheet use VB formula? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|