A1 in sheet1 =” =SUM('sheet2:sheet3'!A1)”
 

When a row is inserted above A1 for sheet 2 and sheet3, the A1 in sheet1
should automatically =” =SUM('sheet2:sheet3'!A2)”. Does anyone know how
to update this change automatically?


--
minrufeng
------------------------------------------------------------------------
minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
View this thread: http://www.excelforum.com/showthread...hreadid=515443

A1 in sheet1 =" =SUM('sheet2:sheet3'!A1)"
 

Hi minrufeng

You must select(group) sheet2 and sheet3 before you insert the row


--
Regards Ron de Bruin
http://www.rondebruin.nl


"minrufeng" wrote in message
...

When a row is inserted above A1 for sheet 2 and sheet3, the A1 in sheet1
should automatically =" =SUM('sheet2:sheet3'!A2)". Does anyone know how
to update this change automatically?


--
minrufeng
------------------------------------------------------------------------
minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
View this thread: http://www.excelforum.com/showthread...hreadid=515443