Vlookup Questions

[lardy999]

Hi, I have a worksheet called Data_dump which contains my students
results for their last 6 exams.

I then have another worksheet called action_plan which has a drop down
box which shows all the students names. When they select their name, I
use vlookup to generate a graph of their performance from the
information in Data_dump. At the bottom of this page is cell (C9) for
them to enter their comments about how they plan to improve their
performance.

I have 2 questions.....

1. The students can type their plan for improvement into cell C9 &
then printout the page, but I can't find a way of taking what they
type into this cell & setting it into the relevent cell in my
Data_dump sheet (column L). What I'm trying to achieve is a bit like a
reverse lookup table, I want to take the information typed in & set it
back into my data table.

2. Assume that I have 50 students. To print out their individual
improvement page, I have to select them one at a time from the drop
down menu & then print them out (again one at a time). Is their any
way of printing all 50 at one time?

I hope I have managed to explain this properly, if not please let me
know & I'll try to explain it better.

Thanks in advance for any help
Helen

 

[Bob Phillips]

You could use VBA

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A2" '<== this is the cell on action_plan _
with the dropdown, change to suit

On Error GoTo ws_exit
Application.EnableEvents = False

If Not Intersect(Target, Me.Range("C9")) Is Nothing Then
With Worksheets("Data_dump")
.Cells(Application.Match(Me.Range(WS_RANGE), .Columns(1), 0),
"J").Value = _
Me.Range("C9").Value
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

This assumes the student names are in column 1 of Data_dump

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)