Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting cells according to all cells in column A
Let us say I have a list of over 4000 case numbers in column A. In the other
columns I also have case numbers but much less than in the column A, an average of 700 and a maximum of 2000. The idea is to sort the cell values according to the values in the first column. So what I want in my spreadsheet is to sort the cell values in colums B, C, D etc according to the list and case numbers in column A. I have tried to make a custom list, but it only reads about 180 cell values in a column. I also dont want to sort the whole sheet column by column. I tried several things in VBE but it doesnt seem to do the trick. Is it possible that I am overlooking something or is it just not possible. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
removing blank cells from a column | Excel Discussion (Misc queries) | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |