As the title says i'm trying a new macro where I high light a block of text, the macro removes what i dont need and then copies what's left and let me paste it where i need.
I know some of you might say why am i copying it to begin with,, but i dont have a choice.
I''m copying this info from a website.
All I need are the numbers from the 1st column, But there are 5 colume's most have a single digit in them, Some have 2 digits.
Also the word "status" comes up in front of the numbers i need.
I need the macro to copy all of it.. remove that i dont need and leave me with what i need.
Does anyone know what i can do ?.