copy rows programmatically from one worksheet to another

  • Thread starter Thread starter Deodiaus
  • Start date Start date
D

Deodiaus

Hi,
I have Worksheet1 with lots of data
I want to create Worksheet2 with a subset of this data, where I want to
just specify the rows to copy.
I did this by specifing the cell, and replicating it for all the cells
that I need to, but that is a lot of work??
Any suggestions?
Sorry, but I am a novice at this, and don't know how to find it.
 
Copying rows is just as easy as copying cells, take row 5 for example

Rows("5:5").Select
Selection.Copy
Sheets("Sheet2").Select
Rows("5:5").Select
ActiveSheet.Paste
 
Back
Top