Macro -Moving data from one sheet to another
 

I am looking for the following and am not experienced enough to figure
this out on my own and would appreciate some help.

Here's what I am looking for.
In column A find the first cell that is equal to the word 'Style' on
the following sheet name 'eWorkbook'

On the first row it finds with the word 'Style' in column A, this row
is going to be a reference row for the following...

It needs to then go to the next row below starting in column A and copy
Cells data in Column A, B, & C and paste that into Sheet named 'Results'

Starting at cell A2. Then if the next cell to the right in sheet
'eWorkbook' is equal to
ColorIndex = 6
Pattern = xlSolid

Then take the value from above in the 'Style' row in the same column it
currently is in and paste that into Sheet 'Results' cell AN2 and the
value in the cell that it originally was in paste that value into Sheet
'Results' starting in cell P2
But if the cell color is equal to
ColorIndex = 15
Pattern = xlSolid

Then keep moving right until you hit column AB in the sheet 'eWorkbook'
and copy it's value and paste that into cell BL2 in the 'Results' Sheet.
Once it is done with that row, continue with the next row doing the same
information but pasting into the next row below in the 'Results' Sheet.
Once it hits a row in Column A that is " " Then find the next cell in
column A that is equal to the word 'Style'

One other side note. When it is searching for a cell that is ColorIndex
= 6
Pattern = xlSolid and pasting it into the 'Results' Sheet it should
always start in comumn P and move right. Column P should always have
the first yellow or ColorIndex = 6 Pattern = xlSolid value.

Can anyone help? You don't understand how much this would assist me.


--
Seanzies
------------------------------------------------------------------------
Seanzies's Profile: http://www.excelforum.com/member.php...o&userid=31175
View this thread: http://www.excelforum.com/showthread...hreadid=508342