| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create a formula between sheets
I am trying to create an IF formula where the data entered on sheet one, has
the result posted on sheet two. For example, if B6 on sheet 1 = 1, than C12 on sheet 2 = OVER. -- Thanks Ryan |
|
#2
|
|||
|
|||
|
Ryan, maybe one of the MVP's has a better solution, but the only way I can
think of doing it is to use a helper column in sheet 1 and Paste Link its cells to sheet 2. For example, you could use: =IF(B6=1,"over","") and then copy and Past Link this cell to sheet 2, C12. -- Sincerely, Michael Colvin "Ryan" wrote: I am trying to create an IF formula where the data entered on sheet one, has the result posted on sheet two. For example, if B6 on sheet 1 = 1, than C12 on sheet 2 = OVER. -- Thanks Ryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| In two workbooks, how do I create a formula that will look at a o. | Excel Discussion (Misc queries) | |||
Linear Mode
