Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidation of data from other worksheets (ras)
hi there,
i am maintaining sector wise data (stocks) in a single sheet within separate worksheets. Now i want to insert another new worksheet which gives me the consolidated report of my desired data in this worksheet. let say if the value in G7 of sheet1 is my desired value to be in B4 of sheet3, then what i should do for achieving this condition. i tried (=sheet3!G7) it works fine but looking for any better idea. waiting 4 a good1 thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of data from other worksheet | Excel Worksheet Functions | |||
A macro for data consolidation | Excel Discussion (Misc queries) | |||
Need how-to or example for data consolidation | Excel Worksheet Functions | |||
data consolidation | Excel Discussion (Misc queries) | |||
New Data Consolidation Question | Excel Worksheet Functions |