| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| Auto-lookup values between Sheet3 & UserForm & paste to Sheet1 | Excel Programming | |||
| consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc | Excel Worksheet Functions | |||
| copy data from sheet1 based on criteria in sheet2 to sheet3 | Excel Programming | |||
| user changes sheet1 - have the macro xyz run on sheet3 | Excel Programming | |||
![minrufeng[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
