comp.apps.spreadsheets,microsoft.public.excel,microsoft.public.excel.programming

S

S.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top