I need to set-up a calculation. If there is a 1 in the cell to the left, then
the information in the cell to the right is transfered to another sheet. The
information to be transferred is alpha info.

Ex. it is for menu creation
if the guest choose this men, i place a 1 next to the item and the item
is entered into a proposal page. without having to retype or = the cell every
time.