Copy to destination of "A50" + value in I12 (sequence#) A51,A52

's Computer Specifications

I amy trying to copy the current value of a row from one worksheet (Data
validated list) to another worksheet. The first time the destination is
"A50", the second time has to be "A51" so as not to overwrite previous copy.
In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
cant figure out how to use the value in I12 to advance the destination from
A50 plus that value.

's Computer Specifications

GeekRN,

Try this as your copy destination:

Range("A" & 50 + Range("I12").Value)

--
Hope that helps.

Vergel Adriano

"GeekRN" wrote:

> I amy trying to copy the current value of a row from one worksheet (Data
> validated list) to another worksheet. The first time the destination is
> "A50", the second time has to be "A51" so as not to overwrite previous copy.
> In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
> cant figure out how to use the value in I12 to advance the destination from
> A50 plus that value.

's Computer Specifications

Dim myDest As Range
Set myDest = Worksheets("Sheet2 Name").Range("A50").Offset(Worksheets("Sheet2
Name").Range("I12").Value,0)
Worksheets("Sheet2 Name").Range("whatever").Copy myDest

HTH,
Bernie
MS Excel MVP

"GeekRN" <(E-Mail Removed)> wrote in message
news:26B57C37-FB3F-4E37-9DB0-(E-Mail Removed)...
>I amy trying to copy the current value of a row from one worksheet (Data
> validated list) to another worksheet. The first time the destination is
> "A50", the second time has to be "A51" so as not to overwrite previous copy.
> In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
> cant figure out how to use the value in I12 to advance the destination from
> A50 plus that value.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I add the icons "Delete", "Cut", "Copy" and "Paste" in Vis	=?Utf-8?B?TW9vbndhbGtlcg==?=	Windows Vista File Management	4	17th Sep 2007 11:02 PM
Multiple "source" workbooks linked to single "destination" workboo	=?Utf-8?B?REFWRUpBWQ==?=	Microsoft Excel Worksheet Functions	1	17th Sep 2007 05:33 PM
change "carbon copy" to "courtesy copy" (for "cc") in Outlook	=?Utf-8?B?SW5maWRlbA==?=	Microsoft Outlook Discussion	1	28th Aug 2006 10:44 PM
Folder browsers need a "go back" or "go to Inbox" key sequence	=?Utf-8?B?T25vbmRhZ2E=?=	Microsoft Outlook Discussion	3	7th Jan 2005 02:29 PM
Re: would the sequence "" & "IT" & "" return IT anywhere in a strin.	Lynn Trapp	Microsoft Access	3	2nd Sep 2004 07:55 AM