Nested if question

[Dan23cd]

I am uncertain if nested if is the correct way to handle this -- what I want to do -- is following:
Based on the contents of sheet 2 A11 -- I want A6 to be pasted into a different spot -- if A11=1, then in A20 -- if A11 =2 then H20, If A11=3 then N20, If A11 = 4 .... total of 6 choices -- i.e. the A11 choices range from 1 through 6.

The code below puts in in A20 -- so need something after the second line in the code so that the correct place is chosen. Suggestions on how to do this? Thanks!!

Range("A6").Select
Selection.Copy
Range("A20").Select
'For next cell in the same column (A)
While ActiveCell.Value <> ""
ActiveCell.Offset(1, 0).Select
Wend

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'Clear the clipboard
Application.CutCopyMode = False

[TMS]

Untested, but try:

Please Login or Register  to view this content.

Regards, TMS

[AlphaFrog]

Please Login or Register  to view this content.