ScottEmberson
New Member
- Joined
- Jul 31, 2014
- Messages
- 12
Hello
I am trying to take data from specific cells on PBI_DATA_SORT and paste it into a new line in PBI_DATA_SORT_TRACKING with a date and time stamp in separate cells.
I have been able to get it to copy from one to another but not with a date and time stamp.
This is how the table would look like in sheet PBI_DATA_SORT_TRACKING
<tbody>
</tbody>
I am trying to take data from specific cells on PBI_DATA_SORT and paste it into a new line in PBI_DATA_SORT_TRACKING with a date and time stamp in separate cells.
I have been able to get it to copy from one to another but not with a date and time stamp.
Code:
Sub Macro3()
'
' Macro3 Macro
'
Sheets("PBI_DATA_SORT").Range("D139:H139,M139").Copy
Sheets("PBI_DATA_SORT_TRACKING").Cells(Rows.Count, "B").End(xlUp).Offset(1). _
PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sheet
End Sub
This is how the table would look like in sheet PBI_DATA_SORT_TRACKING
Date | Time | Total1 | Total2 | Total3 | Total4 | Total5 | Total6 |
<tbody>
</tbody>