Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help
I need some help cleaning up a spread sheet. I have several worksheets with
data on them. I would like to delete any rows of data that don't contain one of 3 or 4 specific values in column F of that row. For example if column F of row 1 does not contain the word "RED", "WHITE" or the word "BLUE" then delete the row. Also, some of the columns have spaces in the beginning and at the end of the actual value that I need removed at the same time. For example a field may have " Free Checking is Here " and I need all of the spaces on the end of that value removed but retaining the spaces between the words. Lastly, row 1 on all of the sheets contains a header row. Any help is GREATLY appreciated!! Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |