Copying a range of data in a column and pasting to another sheet

I am trying to copy a range of data in a column, where not every row has data, and paste it into a column in another sheet, but I only want to paste the rows that have data. please see the attached sample. i want to copy from Range M8:M247 (or from M8 to the last row of data in column M. Please provide code for both.) in Sheet1 and paste just the data rows starting in Cell B2 on Sheet2. this would then have hexidecimal data corresponding to each Cycle in Column A of Sheet2. FYI, the data in Sheet1 cell M7 has already been parsed through and put into columns as headers starting in column B of sheet2, so it is intentional that I started with an empty cell (M8) for the data I wish to copy. Thanks in advance for your help!

hi JP777, option, code "test" - till last value in M column, code "test1" - for fixed hardcoded range

watersev,
Thanks for the reply. your code is working in the sample sheet, but it doesn't work when I copy and paste it into my project. Are there any differences between Excel 2003 and 2007 that may be factoring into it?

WasWodge,
Works like a charm. Thanks

Now that I have the hex data in place, I am going to convert it to binary and convert text to columns for each binary bit. The problem is, I can't figure out how to convert text to columns for one letter/number/character at a time. Any thoughts?

I see how that works. I will still try to figure it out with VBA as well. Thanks again for the help!