| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect?
hi guys , this is my problem: i got two worksheets and sheet 1 has got datas and sheet two is exactly as sheet 1 and the datas are reference to sheet 1. so in sheet 1 A1, the value is 5 in sheet 2 A1 , the formula used is =sheet1!A1 the formula applies for the column A in sheet 2 . the problem is : if i delete any rows( shift rows up) in sheet 1 , sheet 2 will return #REF! Is there any way of preventing that? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=487511 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect function - Limitations | Excel Worksheet Functions | |||
| indirect cell reference using copies of worksheets in same workboo | Excel Worksheet Functions | |||
| Indirect vs. Index | Excel Discussion (Misc queries) | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
Threaded Mode
