Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function refering sheet index.
Dear all,
I have some 100+ sheets in a file. in the first sheet I want get a consolidated information. say count the entries in column-D. how can I write a funcion indipendant of the sheet name. for ex, normally the function will be ..... =counta('sheet1'!D:D) here we have to maually change the name for each sheets. I would like to know if the sheet index can be used in this function. [ =counta(sheet(2)!D:D) ] so that I can make the sheet index [ =counta(sheet(A5)!D:D) ] a variable and automate the same for all sheets. Thanks a lot... a quick responce will be of great help... Regards Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Max Off other sheet | Excel Worksheet Functions | |||
I have an index sheet of over 200 worksheet tabs... | Excel Discussion (Misc queries) | |||
refering to previous sheet | Excel Discussion (Misc queries) | |||
Index/Contents Sheet | Excel Discussion (Misc queries) | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |