thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 956
- Office Version
- 365
- Platform
- Windows
**Edit - subject should read: Possible to Save a SORT pattern.
Hello all. Here is my active sheet:
The sorting pattern I have used is the following:
Is it possible to save this pattern so that anytime i make a change to the worksheet, I have this pattern to select and re-sort?
I have many sheets in this workbook and some have different sort patterns.
Any help is appreciated!!
Hello all. Here is my active sheet:
Catalog.xlsx | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |||
2 | ||||||||||||||||||||||||
3 | MaskedPartNumber | PartNumber | Indoor_Outdoor | Product_Type | Product_Subgroup | Application_Subgroup | Size | Brand | CCT | DLC/EnergyStarID | Emergency Backup | LampBase | Lamps Per Fixture | Lumens | RatedLife_for_Proposal | Voltage | Warranty Yrs | Watts_for_Incentive | Watts_for_Proposal | DLC_Category | DLC_Measure | |||
4 | EIKO 1L 24W LED 4ft T5 Lamp [5K] | LED24WT5HO/46/850-G9D | Indoor | Lamp | Linear_Lamp | T5_Linear | 4ft | EIKO | 5000K | G13 | 1 | 3500lm | 50000 | 120-277V | 5 | 24 | 24 | DLC Linear Repl. Lamps | 4’ HO Replacement Lamp | |||||
5 | EIKO 2L 24W LED 4ft T5 Lamp [5K] | LED24WT5HO/46/850-G9D | Indoor | Lamp | Linear_Lamp | T5_Linear | 4ft | EIKO | 5000K | G13 | 2 | 3500lm | 50000 | 120-277V | 5 | 24 | 48 | DLC Linear Repl. Lamps | 4’ HO Replacement Lamp | |||||
6 | EIKO 3L 24W LED 4ft T5 Lamp [5K] | LED24WT5HO/46/850-G9D | Indoor | Lamp | Linear_Lamp | T5_Linear | 4ft | EIKO | 5000K | G13 | 3 | 3500lm | 50000 | 120-277V | 5 | 24 | 72 | DLC Linear Repl. Lamps | 4’ HO Replacement Lamp | |||||
7 | EIKO 4L 24W LED 4ft T5 Lamp [5K] | LED24WT5HO/46/850-G9D | Indoor | Lamp | Linear_Lamp | T5_Linear | 4ft | EIKO | 5000K | G13 | 4 | 3500lm | 50000 | 120-277V | 5 | 24 | 96 | DLC Linear Repl. Lamps | 4’ HO Replacement Lamp | |||||
Linear Lamp |
The sorting pattern I have used is the following:
application subgroup |
size |
brand |
CCT |
Watts for proposal |
lamps per fixture |
Is it possible to save this pattern so that anytime i make a change to the worksheet, I have this pattern to select and re-sort?
I have many sheets in this workbook and some have different sort patterns.
Any help is appreciated!!