Quote:

I tried a macro but got stuck.

"got stuck" is rather vague. You got an error message? It did something unexpected? It did nothing at all? It may be helpful to post what code you tried...

Otherwise, we are just making wild guesses.