ExcelBanter - Linking Excel Worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Linking Excel Worksheets (https://www.excelbanter.com/excel-worksheet-functions/7713-linking-excel-worksheets.html)

Anne

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.

Frank Kabel

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.

Anne

"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!

All times are GMT +1. The time now is 10:41 PM.