macro to extract data of a selected sheet

T

TUNGANA KURMA RAJU

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.
 
S

ScottO

Have you had a look at the INDIRECT function? I think it will do what
you want.
Rgds,
ScottO

"TUNGANA KURMA RAJU" <[email protected]>
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.
 
Top