Copy Range and Paste into new Sheet

[naise]

Hi, I need some help.

I have a list of information provided and I need to copy a specific range and paste it into a new sheet

RC 1
xxx xxx xxxx
xxx xx xxxx
xx xxx xxx

RC 3
xxx xxx xxxx
xxx xx xxxx
xx xxx xxx

RC 2
xxx xxx xxxx
xxx xx xxxx
xx xxx xxx

the 1 / 3 / 2 might not be in sequence

Is there a way to copy the entire information in "RC 1" till 1 row before "RC 3" and paste it into a new Sheet called "RC 1"?

 

[Fluff]

Hi & welcome to MrExcel.

How about

Sub RC_1()
   Dim Ar As Areas
   Dim i As Long
   
   Set Ar = Range("A:A").SpecialCells(xlConstants).Areas
   For i = 1 To Ar.count
      If Ar(i).Resize(1, 1).Value = "RC 1" Then
         Sheets.Add.Name = "RC 1"
         Ar(i).EntireRow.Copy Sheets("RC 1").Range("A1")
      End If
   Next i
End Sub

 

[naise]

Hmm tried but it only copied RC 1.. all the info below before RC 3 not copied

 

[My Aswer Is This]

I looked at this post but did not know what RC1 meant.
Sometimes we use

R1C1

Which means Row 1 Column 1

And its sort of odd to name your sheet RC1
And paste it where on sheet RC1

I maybe could help if you explained what you wanted without using RC1

 

[naise]

Sorry for the confusion.. RC 1 is actually not row or column.. It is the title for my work.. recreation 1 recreation 3 etc

 

[My Aswer Is This]

And so how do we know what range of data you want to copy?

Are you saying you want to copy a Range named RC1

 

[naise]

So basically
Recreation 1 has information below

Recreation 1
Xxxx Xxxx Xxxx (3 columns)
Xxxx Xxxx Xxxx (3 columns)

Recreation 3..
Xxx Xxxx xxx
Xxx
X

Recreation 2

Wanna copy Information from Recreation 1 to 1 line before Recreation 3 but the number of rows differ each time the report is re-populated

 

[My Aswer Is This]

Someone else I believe will need to help you.

I do not know what Recreation 1 is.


We normally use terms like:
Worksheet names
Ranges
Named ranges

I have no ideal what Recreation 1 is.

 

[Fluff]

Are there blank rows below the RC1?
Also is the info you want to copy hard values, or formulae?

 

[naise]

Yes there will be blank rows.
They are hard values