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