A B C D E F G
1/Microsoft/Yahoo/Google /111111 /10.05.2007 / / / /pup
2 /111111 /10.05.2007 /Microsoft /23 /56 /xyz
3 /111111 / 10.05.2007 /Yahoo /56 /89 /lol
4 /111111 / 10.05.2007/Google /52 /87 /poi
Hello. I have a spreadsheet like this (600 rows x 15 Cloumns).
Each 4 (sometimes 3, sometimes 5) rows is a "product" (here microsoft yahoo google). Each product has 3 (or 2 or 4) underlyings.
I need to sort (for example: sort all hte products with microsoft as underlying) and i need that in the result there is ALL THE PRODUCT. I mean, if i look for microsoft, i need that excel report all the 4 lines.
I found some macros to do the work "find and copy in a new sheet". The problem is: can i "glue" together 3 or 4 or 5 rows???
Thanks
1/Microsoft/Yahoo/Google /111111 /10.05.2007 / / / /pup
2 /111111 /10.05.2007 /Microsoft /23 /56 /xyz
3 /111111 / 10.05.2007 /Yahoo /56 /89 /lol
4 /111111 / 10.05.2007/Google /52 /87 /poi
Hello. I have a spreadsheet like this (600 rows x 15 Cloumns).
Each 4 (sometimes 3, sometimes 5) rows is a "product" (here microsoft yahoo google). Each product has 3 (or 2 or 4) underlyings.
I need to sort (for example: sort all hte products with microsoft as underlying) and i need that in the result there is ALL THE PRODUCT. I mean, if i look for microsoft, i need that excel report all the 4 lines.
I found some macros to do the work "find and copy in a new sheet". The problem is: can i "glue" together 3 or 4 or 5 rows???
Thanks