If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell 
Author Message
 If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell

My Work Book contains work sheets "Job Data" & "Log
Sheet".  "Job Data" contains various job related numbers,
names, and addresses.  I'd like the data from cell B17 to
copy to "Log Sheet" cell F2.  But if "Job Data" cell B17
is empty, then I'd like "Job Sheet" cell B25 to copy
to "Log Sheet" cell F2 instead.


Mon, 21 Mar 2005 21:34:39 GMT  
 If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell
Hi

To copy or to display? When last then:

=IF('Job Data'!B17="",'Job Data'!B25,'Job Data'!B17)

Arvi Laanemets


Quote:
> My Work Book contains work sheets "Job Data" & "Log
> Sheet".  "Job Data" contains various job related numbers,
> names, and addresses.  I'd like the data from cell B17 to
> copy to "Log Sheet" cell F2.  But if "Job Data" cell B17
> is empty, then I'd like "Job Sheet" cell B25 to copy
> to "Log Sheet" cell F2 instead.



Mon, 21 Mar 2005 21:51:23 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. XL97: How to copy into next blank cell text from 1st non-empty cell

2. Displaying the 3rd cell from the last non-empty empty cell

3. Copying Cell Contents to Large Quantity of Empty Cells Below

4. Copy a row of cells and paste it to a column of empty cells

5. empty cells between data cells

6. Making a cell look empty if there's no data in a related cell

7. Subroutine: copy into next blank cell text from 1st non-empty cell, loop-copy until next non-empty

8. Copying the data of the last cell into another cell

9. Copying data values from one cell to another, based on other cells values

10. Averaging cells and moving/copying data to other cells


 
Powered by phpBB® Forum Software © phpBB Group