Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write If proedure
I have a worksheet that has a specific row-filtered list of 4 choices in
column A. If you select choice 1 from column A, choice 1 selects rows 5 thru 4831 only which is correct. There is a sort macro button in row 4 of each column H thru S - each of the columns H thru S have been assigned a macro that will sort the selected range of rows in descending rank for the specific column and rows -- for choice 1, it will rank the rows 5 thru 4831. I'd like to be able to select choice 2 and have the rows for choice 2 which are 4832 thru 12678 selected. Then I'd like to be able to select one of the sort macro buttons in row 4 of one of the columns H thru S and have the macro sort only the selected rows for choice 2, rows 4832 thru 12678. And the same for choice 3 which refers to rows 12679 thru 19886; and the same for choice 4 which refers to rows 19887 thru 26741. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to write my own an Add-In | Excel Programming | |||
How to write an If Then VBA | Excel Programming | |||
re write | Excel Programming | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Better Way to Write This? | Excel Programming |