| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Referencing between multiple worksheets
=INDIRECT("'sheet "&ROW()&"'!F13")
-- David Biddulph kiboypalaboy wrote: hi sheloo, how about if you if refer multiple sheet but the same cell that u want for.. like i want the cell F13 for sheet 1 up to sheet 1431.. and if input the formula for new worksheet in A1=sheet 1 F13 A2=sheet 2 F13 ........ A1431=sheet 1431 F13 thanks in advance for help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing cells in multiple worksheets | Excel Discussion (Misc queries) | |||
| Excel 2003 Referencing multiple worksheets | Excel Discussion (Misc queries) | |||
| Macro referencing multiple worksheets | Excel Discussion (Misc queries) | |||
| Formula Referencing data on multiple worksheets | Excel Worksheet Functions | |||
| Summary worksheet referencing multiple worksheets | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
