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?
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?
Hi minrufeng
You must select(group) sheet2 and sheet3 before you insert the row
--
Regards Ron de Bruin
http://www.rondebruin.nl
"minrufeng" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks