Solved

paste - offset

Posted on 2014-07-31
3
92 Views
Last Modified: 2014-07-31
Hi,

I have an copy/paste
Sheets("Add Delete Team Members").Range("N37").Copy
Sheets("Change Summary").Range("A" & lastTransferRow + 1).PasteSpecial Paste:=xlPasteValues

Open in new window


I want to stamp the next column with username and the next column with date

So the above will drop data into columns A:L, then in:

K: Environ("username")
L: Date

I have the code for username and date, i just need to work it into the paste above

Thanks
0
Comment
Question by:Seamus2626
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 40231742
Hi,

pls try

Sheets("Add Delete Team Members").Range("N37").Copy
Sheets("Change Summary").Range("A" & lastTransferRow + 1).PasteSpecial Paste:=xlPasteValues
Sheets("Change Summary").Range("K" & lastTransferRow + 1) = Environ("username")
Sheets("Change Summary").Range("L" & lastTransferRow + 1) = Date

Regards
0
 
LVL 35

Assisted Solution

by:Kimputer
Kimputer earned 250 total points
ID: 40231748
Sheets("Change Summary").Range("K" & lastTransferRow + 1).Value = "username" '(or code to get the username or another variable)
Sheets("Change Summary").Range("L" & lastTransferRow + 1).Value = NOW() '(or code to get the date or another variable)
0
 

Author Closing Comment

by:Seamus2626
ID: 40231777
Thanks guys
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now