i have 2 sheet in file

- sheet B, i use VLOOKUP fx reference in sheetA,
- In sheet A, after cells.select and delete it, values in sheet B go
#REF

How to auto-apdate value in sheet B, after cells.select and delete it,
then replace another value ?

thank you for help.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=566673

=vlookup(A1,Indirect("SheetB!A1:Z32"),5,False)

perhaps.

--
Regards,
Tom Ogilvy


"vumian" wrote:


i have 2 sheet in file

- sheet B, i use VLOOKUP fx reference in sheetA,
- In sheet A, after cells.select and delete it, values in sheet B go
#REF

How to auto-apdate value in sheet B, after cells.select and delete it,
then replace another value ?

thank you for help.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=566673

hi man,

thank you but how about this fx: SUMPRODUCT man
ex:
SUMPRODUCT(DRP!$L$2:$L$100*(DRP!$C$2:$C$100=$B6)*( DRP!$K$2:$K$100=G$5))

after cells.delete in DRP sheet, and change another table, the present
value goes # REF. it mean, it do not update immidiately

how to do it, it mean update right now after change anything.

thank you for help 1 more.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=566673