Hi

Is it possible in excel that if i eneter a value in cell for example

Cell A Cell B
Juke Box

and next time when i enter value (Juke) in a cell, value (Box) comes up automatically in the next cell as shown above.
i would realy appreciate ur help as i need to enter lots of data which is going to repeat in other work books and its is in nos so i dont want to enter that data again and again and with no mistake in it.