Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros for sorting data
I want to create a macro to sort a days late column on my spreadsheet. I
have never created a macro before and I have not been able to figure this out from the help menu. Any help would be appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros for sorting data
Hi,
Why not start by recording the steps you do when you do it manually? 1. To do that choose Tools, Macro, Record New Macro, enter a name (without spaces), select In this Workbook as the location for the macro and then click OK. 2. Do the steps you normally do for sorting your data. 3. Click the Stop Macro square button or choose Tools, Macro, Stop Recording. Having said this - why bother with a macro to do sorting, in most cases you can do this with a single click. Put your cursor in a single cell of the column you want to sort on and press the Ascending Sort (or Descending Sort) button. All the contiguous data will be sorted with the column your cursor was in. -- Cheers, Shane Devenshire "Angie Luscomb" wrote: I want to create a macro to sort a days late column on my spreadsheet. I have never created a macro before and I have not been able to figure this out from the help menu. Any help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
macros entering data | Excel Discussion (Misc queries) | |||
pasting data and macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) |