excel formula

G

Guest

I have a spread sheet in which column A has Account
numbers and also Salary. So A1=Smith and A2=5,000. and
so on. In another sheet, I would like to have account in
A, salary in B. Instead of writing the same formula many
times, I would like to say = offset by 1.

How do I do that?

Thanks
 
Top