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.

Cannot be done without a formula on second sheet to pull the data over.

Formulas cannot "push" to other cells or sheets.

You would requires some VBA code to do this.

A sample formula on sheet2 would be........

=IF(Sheet1!A1=1,Sheet1!B1)

Or to trap non-valid entries or a blank in A1 or B1

=IF(OR(Sheet1!A1="",(Sheet1!A1<1),(Sheet1!B1="")) ,"",Sheet1!B1)

If you want event code post back.


Gord Dibben MS Excel MVP

On Thu, 15 Nov 2007 15:40:00 -0800, Foodie
wrote:

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.