Copy paste cells to another sheet when criteria met

Closed

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

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

Copy paste cells to another sheet when criteria met
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Copy cells from one sheet to another ✓ - Excel Forum
How to copy data from one sheet to another in excel automatically - Guide
Macro to copy data from one sheet to another based on criteria ✓ - Excel Forum

Subscribe To Our Newsletter!