| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and sorting
I am trying to sort a table that uses Vlookup to fill accross.
(we type in column A and B, and columns C-F use Vlookup) When i highlight my columns (1 thru 800) accross to sort alphabetically, the sort buttom is shaded out and cannot be used. I know i had this problem in the past, and there was a work around. But for the life of me tonight, i cannot figure it out. Any help would so appreciated! Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup and sorting
Is the worksheet protected?
Do you have multiple sheets grouped together? pakmount wrote: I am trying to sort a table that uses Vlookup to fill accross. (we type in column A and B, and columns C-F use Vlookup) When i highlight my columns (1 thru 800) accross to sort alphabetically, the sort buttom is shaded out and cannot be used. I know i had this problem in the past, and there was a work around. But for the life of me tonight, i cannot figure it out. Any help would so appreciated! Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup and sorting
Yes, there are several linked but it is not protected. "Dave Peterson" wrote: Is the worksheet protected? Do you have multiple sheets grouped together? pakmount wrote: I am trying to sort a table that uses Vlookup to fill accross. (we type in column A and B, and columns C-F use Vlookup) When i highlight my columns (1 thru 800) accross to sort alphabetically, the sort buttom is shaded out and cannot be used. I know i had this problem in the past, and there was a work around. But for the life of me tonight, i cannot figure it out. Any help would so appreciated! Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup and sorting
Grouped means more than one sheet selected.
Do you see [Group] in the title bar? (I still don't have any other guesses no matter what your answer is though.) pakmount wrote: Yes, there are several linked but it is not protected. "Dave Peterson" wrote: Is the worksheet protected? Do you have multiple sheets grouped together? pakmount wrote: I am trying to sort a table that uses Vlookup to fill accross. (we type in column A and B, and columns C-F use Vlookup) When i highlight my columns (1 thru 800) accross to sort alphabetically, the sort buttom is shaded out and cannot be used. I know i had this problem in the past, and there was a work around. But for the life of me tonight, i cannot figure it out. Any help would so appreciated! Thanks -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP difficulty sorting data? | Excel Worksheet Functions | |||
| vlookup and sorting and references. | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| VLOOKUP, Sorting, Calculate | Excel Worksheet Functions | |||
| Sorting dates with Vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
