how to Extract specific data from excel spreadsheet?

hello all,

i have a requirement as to how to extract specific data from an excel sheet and copy it into the net sheet.
The background is that, i have 10 to 12 columns of various data like speed, time, angle, temperature etc. stored in a .csv format or a .xls format.
i need to get minimum and maximum values from a few columns, say column A, D and E. and these selected values should be copied into the next excel sheet.

does anybody have any idea how to go about this?

will macros or Visual basics help?

Send/ Upload your excel sheet with requirement .!

put the formula in sheet2
=MAX(Sheet1!A:A)
=min(sheet1!A:A)
=MAX(Sheet1!D:D)
=min(sheet1!D:D)
=MAX(Sheet1!E:E)
=min(sheet1!E:E)

if it was useful to you then dont forget to hit * button for user reputation...........


Regards
CA Mahaveer Somani

put the formula in sheet2
=MAX(Sheet1!A:A)
=min(sheet1!A:A)
=MAX(Sheet1!D:D)
=min(sheet1!D:D)
=MAX(Sheet1!E:E)
=min(sheet1!E:E)

if it was useful to you then dont forget to hit * button for user reputation...........


Regards
CA Mahaveer Somani

thank you
but i do not want it to be manual. i get these data from my machine and need to analyse the data in no time..
i just need a front end asking me from column i need the data and copy the same in another sheet.

will you tell me clearly what is your exact need..............tell me in details.........and what do you want after that also tell us.......did you need a macro or formula........?

watever you need...........you should tell clearly............for better answer with in short duration........

Regards
CA Mahaveer Somani

okay..
i shall upload the excel sheet which contains all the data.
the first 3 sheets contain 3 sets of data. the fourth sheet contains the min, max, avg of the 3 sheets.
i need to generate the 4th sheet automatically using macro or VB.

regards
Roopa

here is the .xls file..