use of vloop in excel

[Guest]

I just want some of the Information from one sheet to another.

In sheet 1 staff grade is avilabe and in sheet 2 grade is not available.
I need the all the Grade to copy to sheet 2 but in the same row of the
employee.

 

[Guest]

Assuming staff grade start in Sheet1 A1

In Sheet2
A1: =Sheet1!A1
copy down as far as required...