| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking Excel Worksheets
Is it possible to link one Excel worksheet to another Excel worksheet with
data going in one column or the other column depending it's negative or positive value. |
|
#2
|
|||
|
|||
|
Hi
on the other sheet in A1 use a formula such as =IF('other sheet'!A1<0,"",'other sheet'!A1) and in B1 use =IF('other sheet'!A10,"",'other sheet'!A1) -- Regards Frank Kabel Frankfurt, Germany "Anne" schrieb im Newsbeitrag ... Is it possible to link one Excel worksheet to another Excel worksheet with data going in one column or the other column depending it's negative or positive value. |
|
#3
|
|||
|
|||
|
"Frank Kabel" wrote: Hi on the other sheet in A1 use a formula such as =IF('other sheet'!A1<0,"",'other sheet'!A1) and in B1 use =IF('other sheet'!A10,"",'other sheet'!A1) -- Regards Frank Kabel Frankfurt, Germany "Anne" schrieb im Newsbeitrag ... Is it possible to link one Excel worksheet to another Excel worksheet with data going in one column or the other column depending it's negative or positive value. Thank You! Have a wonderful day! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I show excel worksheets on a webpage when viewed by win98 . | Excel Discussion (Misc queries) | |||
| Color of Excel BEHIND the worksheets!! | Excel Discussion (Misc queries) | |||
| Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
| Simplify Linking to several worksheets?? | Excel Worksheet Functions | |||
Linear Mode
