Copy paste cells to another sheet when criteria met

[Closed]
Report
Posts
3
Registration date
Tuesday March 1, 2016
Status
Member
Last seen
March 8, 2016
-
Hello,

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