Hi All,

I am generating large amounts of data that need to be analyzed on the fly.
To simplify the problem, consider an Excel workbook that has n number
of data sheets, S1 to Sn. Each spreadsheet has 5 columns, C1 to C5
and x number of rows, R1 to Rx, in addition to the a header row. The
workbook also has one main sheet called Smain. The workbook should
be capable of doing the following automatically, either by pressing a button
or auto-refresh when the data is updated:

1. The rows of each data sheet should be sorted max to min according to C3.

2. If the maximum value in C3 of a given sheet is less than -1, the tab color
of that sheet should be changed to red. If it is between -1 and -2 then the
tab color should be yellow. If it is between 1 and 2 it should be blue. If it is
greater than 2 it should change to green.

3. The row with max C3 value in each sheet data sheet should be automatically
copied into the main sheet, Smain. So, Smain will consist of n number of rows
with each row being one which has the max C3 in its corresponding data sheet.
All rows need to be sorted in Smain max to min according to C3. Same tab color
condition applied to Smain.

Anyone can produce such workbook?

Hi
some ideas to get started:
1. Record a macro while doing this manually and assign this macro to a
button
2. What Excel version are you using. Prior to Excel 2002: Not possible
3. See:
http://www.rondebruin.nl/copy5.htm

as a starting point

--
Regards
Frank Kabel
Frankfurt, Germany

"S." <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> Hi All,
>
> I am generating large amounts of data that need to be analyzed on the
fly.
> To simplify the problem, consider an Excel workbook that has n number
> of data sheets, S1 to Sn. Each spreadsheet has 5 columns, C1 to C5
> and x number of rows, R1 to Rx, in addition to the a header row. The
> workbook also has one main sheet called Smain. The workbook should
> be capable of doing the following automatically, either by pressing a
button
> or auto-refresh when the data is updated:
>
> 1. The rows of each data sheet should be sorted max to min according
to C3.
>
> 2. If the maximum value in C3 of a given sheet is less than -1, the
tab color
> of that sheet should be changed to red. If it is between -1 and -2
then the
> tab color should be yellow. If it is between 1 and 2 it should be
blue. If it is
> greater than 2 it should change to green.
>
> 3. The row with max C3 value in each sheet data sheet should be
automatically
> copied into the main sheet, Smain. So, Smain will consist of n number
of rows
> with each row being one which has the max C3 in its corresponding
data sheet.
> All rows need to be sorted in Smain max to min according to C3. Same
tab color
> condition applied to Smain.
>
> Anyone can produce such workbook?
>
>