Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting challange
I wish to click on "Sunday"cell and perform the following:
1) The information from BY8 to DF73 is to be sorted by BZ, CA, and CC. 2) Information from CC and CE is to be copied to B and D respectively (75 rows) Then when clicking on "RESET" cell, the information BY8 to DF73 is returned to its original order by sorting on BY ( same 75 rows). The same will be applied to the "Monday" cell copying columns CK and CM to B and D. Of course this goes on for Tues, Wed.... The number of rows will not change unless many new employees are added. Is it time to learn how to design a MACRO? Thoughts appreciated -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
challange | Excel Discussion (Misc queries) | |||
Sorting | Excel Worksheet Functions | |||
a CHALLANGE using OR in an array formula | Excel Worksheet Functions |