Copy paste cells to another sheet when criteria met

frank7788 Posts 3 Registration date Tuesday March 1, 2016 Status Member Last seen March 8, 2016 - Mar 1, 2016 at 12:36 PM

I'm new to Macros and can't figure this one out. The data (numbers) read
top to bottom, left to right, row by row. Some of the cells are highlighted in yellow. I need a macro to loop through the cells (in sheet 1) and copy /paste all the cells between each highlighted cell (until the last row (blank cell) into columns
in sheet 2. The range between each "yellow" cell makes up a column.
Any help would be greatly appreciated.
I run 3 different versions of excel -2003-2010-2016 on different pc's