Macro to copy and paste indivicual rows

[davidp13]

Hi,

I hope there is someone clever out there that can help me or point me to the right discussio.

Im trying to copy data (my data source) from one worksheet to my main worksheet where all my conditional formatting happens.

I have to copy and paste each line individually, because the conditional formatting does not for some reason allow me to copy and past a range of values.

Sheet: DataSource
I have data in A1:G1000
This data needs to be copied to Sheet:DayReporting

Sheet: DayReporting
The first open cell is A5.

 

[VoG]

Perhaps like this

Sub test()
Dim i As Long
With Sheets("DataSource")
    For i = 1 To 1000
        .Range("A" & i).Resize(, 7).Copy Destination:=Sheets("DayReporting").Range("A" & i + 4)
    Next i
End With
End Sub

 

[Andrew Poulsom]

Welcome to MrExcel.

In what way doesn't your conditional formatting allow you to copy and paste the entire range?

 

[davidp13]

When I copy the entire range from Sheet: DataSource to Sheet: DayReporting it only paste the first line and stop on the next line as soon as it reaches the cell that the conditional formatting is checking.

Im checking to see if the cell is Bold or Not Bold using isBold.

 

[davidp13]

Perhaps like this

Sub test()
Dim i As Long
With Sheets("DataSource")
    For i = 1 To 1000
        .Range("A" & i).Resize(, 7).Copy Destination:=Sheets("DayReporting").Range("A" & i + 4)
    Next i
End With
End Sub

Hi VoG,

The code only copies one line. Any reason why that would happend?

 

[Andrew Poulsom]

Maybe you need to use Paste Special|Values instead of Paste.

 

[davidp13]

Hi Andrew,

The Paste Special|Values also does not work. Would you mind if I sent you the file of just post the code that I currently have?

Thanks

Maybe you need to use Paste Special|Values instead of Paste.

 

[Andrew Poulsom]

In what way doesn't it work?

 

[davidp13]

It only paste the first line then stop on the second line once it reaches the filed thats being checked for the Bold condition.

In what way doesn't it work?

 

[Andrew Poulsom]

Sorry, I don't understand what's causing it to stop after the first line. What do you mean by "the field that's being checked for the Bold condition"?