Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Info between worksheets
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Info between worksheets
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Creating a log with info from worksheets...... | Excel Discussion (Misc queries) | |||
Pull info from other worksheets | Excel Discussion (Misc queries) | |||
Transfer Info From Worksheets | Excel Discussion (Misc queries) | |||
Transferring info between worksheets | Excel Worksheet Functions |