| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to extract data of a selected sheet
I have a w/book contains 120 sheets all contains similar data columns.I have
a anlysis sheet in which data analysis tools are placed in a1:m35.I am looking for a macro to look sheetname(in a1 sheetnames list is placed) and relevant data of that sheet be loaded to analysis sheet from N1 onwards. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to extract data of a selected sheet
Have you had a look at the INDIRECT function? I think it will do what
you want. Rgds, ScottO "TUNGANA KURMA RAJU" wrote in message ... | I have a w/book contains 120 sheets all contains similar data columns.I have | a anlysis sheet in which data analysis tools are placed in a1:m35.I am | looking for a macro to look sheetname(in a1 sheetnames list is placed) and | relevant data of that sheet be loaded to analysis sheet from N1 onwards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Linear Mode
