I have a script that currently copies the “Active Cell” which will always be between K123:K149 depending on which one is active. These cells hold the users first name which is copied into the last row of Column “C”.
What I need to do is copy the cell to the right of K123 (L123) at the same time and copy it to Column “B”
Example:
K123 “active cell” shows Jane Doe, in L123 is her team name “Ocean_Channel_Services” I need to copy her name to the last row of column “C” example “C123” and the Team name to “B123”
This is a partial script…
Sub Testing()
ActiveCell.Copy
Range("C" & Rows.Count).End(xlUp).Offset(1).Select
ActiveCell.PasteSpecial xlPasteValues
Application.CutCopyMode = False
Sheets("Role Call").Range("L122").Value = "Type Name Here"
Range("L122").Select
End Sub
How do I get the script to understand that I also want her team copied and pasted in "B" row?
Thanks for any assistance.
What I need to do is copy the cell to the right of K123 (L123) at the same time and copy it to Column “B”
Example:
K123 “active cell” shows Jane Doe, in L123 is her team name “Ocean_Channel_Services” I need to copy her name to the last row of column “C” example “C123” and the Team name to “B123”
This is a partial script…
Sub Testing()
ActiveCell.Copy
Range("C" & Rows.Count).End(xlUp).Offset(1).Select
ActiveCell.PasteSpecial xlPasteValues
Application.CutCopyMode = False
Sheets("Role Call").Range("L122").Value = "Type Name Here"
Range("L122").Select
End Sub
How do I get the script to understand that I also want her team copied and pasted in "B" row?
Thanks for any assistance.