Moving columns based on text

[Closed]
Report
Posts
4
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 20, 2014
-
Posts
4
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 20, 2014
-
Suppose data is like this:

3 3 OPG 4 5 2
5 3 MCG 0 4 3
0 4 ELG 4 2 4
7 5 CTG 4 2 1

I want a macro that will look through column C and if OPG or CTG is listed, Move the entire row to the bottom of the spreadsheet. Thanks!

2 replies


OK, when should this action take place? Any time any entry is entered, should it check? Should it be a button?

What are you expecting, as making it happen when you want it to is the key.

Let us know!
Posts
4
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 20, 2014

I want it to happen when I press the button.