Automatically updating cells in a different tab? Possible?
 

In one tab I have an active total being created throughout cells, ie: d3
= 1 so b3 = .5 (=countif/2). But I need a year to date on a seperate
tab or workbook that is counting down, ie: 12-.5. Is there anyway to
create a link so that when one cell in one tab goes up it subtracts
from a different cell in a different tab or workbook? :confused:

Thanks,
DarklyCute1


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=558926

Automatically updating cells in a different tab? Possible?
 

=1000-sheet1!a2

--
Don Guillett
SalesAid Software

"DarklyCute1"
wrote in message
...

In one tab I have an active total being created throughout cells, ie: d3
= 1 so b3 = .5 (=countif/2). But I need a year to date on a seperate
tab or workbook that is counting down, ie: 12-.5. Is there anyway to
create a link so that when one cell in one tab goes up it subtracts
from a different cell in a different tab or workbook? :confused:

Thanks,
DarklyCute1


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile:
http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=558926