Prev: "Send to mail recipient" is dimmed out on my tool bar
Next: How to use the Stop If True Condition for highlight cells
From: Eileen on 13 Mar 2010 16:41
All i want to do is fill a cell with a number and that number to go into a
cell on another sheet as well.
From: Joe User on 13 Mar 2010 17:06
"Eileen" wrote:
> All i want to do is fill a cell with a number and that
> number to go into a cell on another sheet as well.

A little light on details, dontcha think?

Suppose the cell to be filled in is in A1 in Sheet1. Suppose the other cell
is in B1 in Sheet2. Then B1 in Sheet2 should have the following formula:

=if(Sheet1!A1="", "", Sheet1!A1)

The first part of the IF statement ensures that if A1 appears to be blank,
so will B1.
 | 
Pages: 1
Prev: "Send to mail recipient" is dimmed out on my tool bar
Next: How to use the Stop If True Condition for highlight cells