Hi All,
I have a table, and in one of the columns I would like to run a macro that will delete all of the cells that do not contain a certain string, lets say "PRIME".
Then to shift the values in the column up so everything is nice and neat.
The length of this column of values will vary depending on the sheets input, so I want to use the table column as the range.
I have found similar questions, but the all seem to be for raw data in a sheet, not a table, and I cant get them to work for me.
Many thanks,
I have a table, and in one of the columns I would like to run a macro that will delete all of the cells that do not contain a certain string, lets say "PRIME".
Then to shift the values in the column up so everything is nice and neat.
The length of this column of values will vary depending on the sheets input, so I want to use the table column as the range.
I have found similar questions, but the all seem to be for raw data in a sheet, not a table, and I cant get them to work for me.
Many thanks,