Thanks excelledsoftware, I appreciate your help. Really do! My last questions is just for me to understand a portion of the code which is "FinalRow = 3000 'Change this to the final row of data.

I changed to extend the range but was wondering if I necessarily have to change the data to the last row of data because my data grows at times so I just put 30000 - which works but is there any implications later?

"FinalRow = 30000 'so as to accomodate much range in future - is this right?

Thanks and wouldn't need the msgbox since no need for it.