Possible to filter only ALL CAPS values from a column using vba?

[jrincar]

I have recently created a macro to pull specific information from a very large spreadsheet to a new page. Column A is all category codes, Column B is all Category Titles and column C is Dollar Amounts. In column B, I have Category Titles in all caps and Subcategory Titles starting with a capital then continuing in all lower case.

I have auto filters applied to A and C, one is to filter out 0 values and one to filter NULL values. What I need now is to sort through Column B and remove the entire row of data if column B's value is in all caps. If I could actually move them to a table beside the current one that would be preferable, maybe store the values removed in an array somehow?

Anyways I am a beginner and apologize if this has been asked before but I couldn't find it. All help is appreciated.

 

[wigi]

Hello

If you are using an Autofilter, I would add a column with the EXACT function.
The EXACT function can distinguish between ALL CAPS and All caps.
So return TRUE or FALSE and use that column in your autofilter.
If wanted, you can move the FALSE rows to a different table.

 

[jrincar]

Hello

If you are using an Autofilter, I would add a column with the EXACT function.
The EXACT function can distinguish between ALL CAPS and All caps.
So return TRUE or FALSE and use that column in your autofilter.
If wanted, you can move the FALSE rows to a different table.

Sounds promising, will get started on it. Thanks for the speedy reply.