Excel 2007 : Creating A Macro to Auto Arrange Data

i need help with this issue if any one can help, i think its more of a challenge since i asked a few people to help and no one could.

i need a macro to help me sort information into cells,

#1) For example in the picture you see A1 has the product name and i want it to be pasted in G2. the cell A1 will always have the item name

#2) the second cell is the Product code in this case it is 5H2546YDR that was sent to sell H2

#3) Category 430 was sent to cell i2

#4) Retail price sent to cell k2

#5) Price we pay sent to j2

#6) if you notice i would like to use all the ********************************** to separate the product or have the macro recognize this as a command so that it can start the search again looking for the same information and Product Name, Product Code,Category,Price We Pay and Retail Price.



you get the idea i mind doing this because it gets boring after the first 400 items

please note the empty cells in between **************** to the next cell with information that has the item name will vary some times 1 empty row of cells up to 8 empty rows.



http://i184.photobucket.com/albums/x.../MACROHELP.jpg