Addictions
Board Regular
- Joined
- May 27, 2018
- Messages
- 60
- Office Version
- 365
Hello,
Please can someone possibly help.
What changes should I make to code below so it can find the column by name instead of specific range and copy all data to the last row
Many thanks,
Please can someone possibly help.
What changes should I make to code below so it can find the column by name instead of specific range and copy all data to the last row
VBA Code:
LastRow = .Range("T" & .Rows.Count).End(xlUp).Row
Sheets("Sheet1").Range("A2:A" & LastRow).Copy
Sheets("Sheet2").Range("1:48").Find("Full name").Offset(1, 0).PasteSpecial xlPasteValues
Many thanks,