Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
bringing G1 value from 50 sheets to another sheet. Indirect comman
I have 50 sheets called run1 ... run50
In G1 of each sheat I have a number (number of rows G4:Gn, in that sheet) I want to bring the valuse of G1 from all 50 sheets to another sheet (summary Shheet). Is it possible to do it by "indirect" command to copy the (run3!G$1$) reference cell? I couldn't succeed. -- Rasoul Khoshravan Azar Civil Engineer Osaka, Japan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked sheets with sequencial order in 2ΒΊ Sheet | Excel Discussion (Misc queries) | |||
Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |