Help with creating an exam book..

[pinmaster]

Hi Sarrah,
Here are the basics of Roger's formula
=IF(condition to look for,if True,if False)

condition to look for: $D$7="" (D7 is empty), which will result in a
TRUE or FALSE statement
if TRUE then: "" which means leave the cell blank (double quotes)
if FALSE then: VLOOKUP($D$7,Sheet2!$B$26:$F$100,20 )

Also, the double quotes leaves the cells blank but basically you can
put anything you want in between..... i.e "No Search";"Not Found", but
most people leave it blank.

Hope it makes things a little bit clearer for you. And BTW your english
is as good as mine.

Regards
JG

 

[Pete]

Sarrah,

the information you have provided is still very sketchy, but perhaps
the following might help you. You ask how you can get student
information from student list by typing student number, so this implies
that you have student data along the lines of:

A B C D
Number Surname Forename D.O.B. etc
0001 Smith Jane
0003 Jones David
etc

You will probably have lots more information in this table, but you
want to type student number on one sheet and have some of the
information from the student list to appear. Assume that the table
above occupies cells A1 through to D500 in the sheet called "Students".
Assume further that you want to type a student number into cell A2 on
another sheet for results - the following formulae can be entered:

B2: =VLOOKUP(A2,Students!$A$2:$D$500,2,0)
C2: =VLOOKUP(A2,Students!$A$2:$D$500,3,0)
D2: =VLOOKUP(A2,Students!$A$2:$D$500,4,0)

B2 would return the surname of the student whose number is typed into
cell A2, and the forename would appear in C2 along with the date of
birth in cell D2. You could copy these formulae down and then enter
other student numbers in cells A3, A4, A5 etc - these would not have to
be in the same order as in the main table.

Hopefully, these comments will help you progress a bit further.

Pete

 

[Sarrah]

Ahh right, now I understand, Thanks Roger and Pinmaster for Explaining
it I tried and it worked!!! you guys are the best!!


Alright, One more problem, this would be the last question I promise!!

Okay, I'm trying to store information from sheet1 to sheet3 using macro
on a button but some of the cells in sheet1 contain formula (like
calculate percentage and average etc) how can I transfer these
information using macros?

 

[Roger Govier]

Hi Sarrah

Firstly, let me re-iterate a comment from pinmaster as a result of a
comment you made to him.
Your English is Excellent!!!

I'm glad to have been able to help.
With regard to your last question (I bet it isn't <bg>, especially if
you are going to continue to improve your Excel knowledge) then

use something like = Range("C1").value rather than = Range("C1")
when writing the data out.

 

[Pete]

My posting seems totally out of place here - despite what it says, I
posted it on Jan 8 at 1:00am, and it just seems to have got lost for a
day!

Pete

 

[Sarrah]

Thanks, Roger, Pinmaster, and Pete I found your formula and the way
you explained to be very useful and easy to understand, thanks a lot!!
I think now I can use Vlookup formula in the future without any problem

 

[pinmaster]

Hi Sarrah,

You're very welcome, and thanks for the excellent feedback.

Regards
JG