SleightOfHand
New Member
- Joined
- Jun 19, 2020
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi,
I'm almost there trying to copy and paste but I can't seem to find the right solution.
I've got a column that starts from E7 and goes to E100. It contains a few different inputs, but also has many yellow cells that I want to paste into another sheet. This sheet would need to be on the next available ROW that doesn't have data starting from the first cell of that row. This would be that I can edit those yellow cells and log them into another sheet. Lastly, the data would need to be transposed. What I've got at the moment:
Adding transpose:= true doesn't seem to work.
Another thing is that this code just freezes up the sheets themselves although it does copy what I want.
Cheers!
I'm almost there trying to copy and paste but I can't seem to find the right solution.
I've got a column that starts from E7 and goes to E100. It contains a few different inputs, but also has many yellow cells that I want to paste into another sheet. This sheet would need to be on the next available ROW that doesn't have data starting from the first cell of that row. This would be that I can edit those yellow cells and log them into another sheet. Lastly, the data would need to be transposed. What I've got at the moment:
VBA Code:
Sub Copy()
Dim Data as Range
For Each Data in Sheets("No1").Range("E2:E100")
If Data.interior.Color = RGB(255, 255, 183) Then
Data.Copy
Sheets("Out").Range("A" & Rows.Count).End(xlUp).Offset(1,0).PasteSpecial Paste:=xlPasteValues
End If
Next Data
End Sub
Adding transpose:= true doesn't seem to work.
Another thing is that this code just freezes up the sheets themselves although it does copy what I want.
Cheers!
Last edited by a moderator: