Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all
I am using this Formula in worksheet sheet 1 A690 =INDIRECT("'Road Cash Accounting'!"&ADDRESS(ROW()/6-104,(COLUMN()))) to get to A11 in Road cash accounting. I am having difficulty adapting to make it repetitive in the following manner In Worksheet sheet 1 A722 ,A690+32 Rows has to display In road cash accounting A114, A11+103 Rows and again In worksheet sheet 1 A754 , A722+32 Rows Has To Display In Road Cash Accounting A217,A114+103 Rows And so on Hope you can help Stew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
Use of 'INDIRECT | Excel Worksheet Functions | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
INDIRECT.EXT | Excel Worksheet Functions | |||
INDIRECT | Excel Discussion (Misc queries) |