Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Convert Value to Number, Sort, then Delete
Hello,
I have a spreadsheet with copious amounts of data (10 sheets with ~80 columns x 8000 rows). The file size is so large that I need to break the data into groups and then delete the rows that do not pertain. I have identified the rows I would like to delete by writing a formula in Column A. This formula returns the word "DELETE" for the rows I want to delete. The best macro would be one that will convert these formulas to its value and then sorts the data by Column A to get the all the "DELETE"s into one grouping. I would then need this macro to delete all the Rows that have the word "DELETE" in column A. I have a macro that will delete all the rows that have the word "DELETE" in column A, however it takes forever to run. I can actually sort and delete quicker manually, however this is an ongoing project and gets repetitious quickly. Any help would be greatly appreciated! Thank you for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert (-) to a (+) number Macro | Excel Programming | |||
Macro to convert phone number to time zone | Excel Programming | |||
need help with macro to convert number to date | Excel Programming | |||
error convert to number macro | Excel Programming | |||
Convert a number formatted as text to a number in a macro | Excel Programming |