|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating colour coded columns and auto-generete statistic in separate sheet
I´ve totally got stuck on a task at work and needs help. I´m working with a large register sheet and needs to a) Colour code specific columns. At first a did this by formatting three different tables with different colures but then I realized that will mess Everything up when I sort by name . I have four columns in which the rows should alternate between red and white, four that should be blue and with and three that should be green and white. Any ideas? b) I need to make statistics on the number of positions we have in the register, both total and divided into various groups. Wants I way to do this automatically (so that as we add positions(in new rows) the statistic is auto-updated. No clue how to do this. Is there a macro for this? Or maybe a formula. The tricky thing is that I want the statistic to be on a separate sheet. Info in Sheet 1-4 should generate statistic in sheet 5. |
#2
|
||||
|
||||
Please post one question per thread and add a sample file - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to use columns like separate pages | Jamesafluke | Word | 1 | 11-06-2014 12:47 PM |
Create a New Sheet from Existing Sheet with Specific Columns | malam | Excel Programming | 1 | 10-17-2014 10:01 PM |
From an XL sheet ,how to keep the group of columns which match with other XL sheet | Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |
Columns - separate management | alvin | Word | 1 | 09-18-2012 09:02 AM |
How to separate specific columns from the data | kumar | Word | 1 | 06-04-2012 01:46 PM |