Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Macro for sorting
Hello:
I have data that is inserted weekly into a new worksheet in the same workbook. This data is aggregated into a single worksheet. The final worksheet is 2 columns. Column A has the person's name, and Column B has the total for the person. I have a macro set to automatically sort by Column B when the worksheet is selected. What I would like to do is have a third column that would tell me how many spots an individual gained or lost from the previous week. I would like for this process to happen automatically when the worksheet is selected if possible. For example: A B C John 27 +3 Sallie 31 -1 Any ideas? Thanks..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting with macro button | Excel Discussion (Misc queries) | |||
Sorting with a macro or a formula | Excel Discussion (Misc queries) | |||
Macro sorting by 4 columns | Excel Discussion (Misc queries) | |||
sorting using macro | Excel Discussion (Misc queries) | |||
macro for sorting | Excel Discussion (Misc queries) |