help please! I really need to figure this out

d0wnt0wn, please post which thread(s) you are referring to and some more specifics on your question. What do the numbers mean in terms of coding a solution? Can you provide some examples?

Try entering in cell B1 in sheet 1:

=INDEX(Sheet2!B1:B10,A1)

Then enter 1-10 as you describe. If you enter a number in A1 outside the range you specifie you will receive an error in B1.

Andywiz

Would this be the same thing as your thread here?
http://www.mrexcel.com/board2/viewtopic.php?t=178388

yes kristy it would be the same...... sorry for the double post but i am really under the gun to get this done

How's this:

<font face=tahoma><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Change(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range)
    <SPAN style="color:#00007F">Dim</SPAN> rng <SPAN style="color:#00007F">As</SPAN> Range
     <SPAN style="color:#007F00">'   Only look at single cell changes</SPAN>
    <SPAN style="color:#00007F">If</SPAN> Target.Count > 1 <SPAN style="color:#00007F">Then</SPAN> <SPAN style="color:#00007F">Exit</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
    <SPAN style="color:#00007F">Set</SPAN> rng = Range("A1")
    <SPAN style="color:#007F00">'   Only look at that range</SPAN>
    <SPAN style="color:#00007F">If</SPAN> Intersect(Target, rng) <SPAN style="color:#00007F">Is</SPAN> <SPAN style="color:#00007F">Nothing</SPAN> <SPAN style="color:#00007F">Then</SPAN> <SPAN style="color:#00007F">Exit</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
        <SPAN style="color:#00007F">If</SPAN> Target.Value >= 1 And Target.Value <= 10 <SPAN style="color:#00007F">Then</SPAN>
            Range("B" & Target.Value).Copy Sheets("Sheet2").Range("B1")
        <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

Smitty

andy...... thanks but i actually need the cell to be copy pasted and not just get the info from the cell


fire.... basically i am trying to do this.....

i want to select the name of a picture from a drop down menu

then i want the picture to appear beside my selection and then next to that a description of the picture

i thought that by inserting a picture into a comment i could relate that picture to a cell... then if i just copy and paste that cell with the comment in it and turn comment indicators on then the picture would appear... this is probably the wrong way to go about things but it seemed to make sense to me.

hi smitty thanks for the responce

i see where you are going with this but i need something a little more

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
' Only look at single cell changes
If Target.Count > 1 Then Exit Sub
Set rng = Range("A1")
' Only look at that range
If Intersect(Target, rng) Is Nothing Then Exit Sub
If Target.Value >= 1 And Target.Value <= 10 Then
Range("B" & Target.Value).Copy Sheets("Sheet2").Range("B1")
End If
End Sub


if target value =1 then copy sheet2 b1
if targetvalue =2 then copy sheet2 b2

etc

but also id like the same dropdown in A1 through A10 on sheet 1 to work not just the A1 range

Couldn't you change this: to: Smitty

smitty i tried the code you gave me just to test it and when i enter something into a1 on sheet 1..... whatever i had on sheet2 b1 vanishes and nothing pastes to sheet 1