tpowell1986
New Member
- Joined
- Jun 23, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
hi,
i need of some help please, i have a simple script that is copying values from a workbook to the next empty row on another tab, i would like to have a time and date stamp in column B showing when the information was pasted.
thanks in advance
Range("t2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("invoice").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
i need of some help please, i have a simple script that is copying values from a workbook to the next empty row on another tab, i would like to have a time and date stamp in column B showing when the information was pasted.
thanks in advance
Range("t2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("invoice").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues