Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
lets not hit enter this time!!!
I have a huge dump of data which I'm using a very basic macro to pick up the columns I need, delete the top two rows and then sort the data by value. All this is working well except for the data sort. Anyone any tips? I'm new to this!!! Ta. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The best way for you to learn something like this (the same as for
everyone - myself included) is to use the Macro recorder on the Tools...Macros menu This is always the best way to start. Do sorting manual. When you have finished recording the actions that you need the code for, click Stop on the Tools..Macros menu, and use ALT-F8 to show the Macros dialog. Select the new macro that you just recorded, and choose 'Edit' then you can see the code that has been recorded, and this will help you see what action you have used, and give you a head start. Regards Yngve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting/Totalling Macro with varying rows of data | Excel Discussion (Misc queries) | |||
macro to hide data (with conditional formatting?) | Excel Worksheet Functions | |||
Formatting Rows of Data based on Column Data | Excel Worksheet Functions | |||
Data Formatting in Excel/Macro | Excel Discussion (Misc queries) | |||
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) |