Solved

paste - offset

Posted on 2014-07-31
3
98 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 50

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

831 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