Find & copy in a new sheet + "GLUE" relative r

placette

New Member
Joined
Sep 20, 2006
Messages
5
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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
You could put a value next to the rows (i.e in column M) so that you could sort along those criteria, therefore 'glueing' them together.

If you see what I mean, if there were five rows for google, you could put a 1 in column M for those five rows, and so long as you sorted from column M, they would stay together.

Maybe i've misunderstood, but is that what you're after?
 

placette

New Member
Joined
Sep 20, 2006
Messages
5
1/Microsoft Yahoo Google /111111 /10.05.2007 / / / /pup
2 /emptyemptyemptyempt/111111 /10.05.2007 /Microsoft /23 /56 /xyz
3 /emptyemptyemptyempt/111111 / 10.05.2007 /Yahoo /56 /89 /lol
4 /emptyemptyemptyempt/111111 / 10.05.2007/Google /52 /87 /poi

now is better

thanks but i ve already done what you suggest (11111 is the product number and there is another coumns like this for date 10.05.2007).

the problem is that i want to have a macro that find and copy in another sheet all the products with google (or another). not only 1 row (here the 4th row) but all the rows of the product. And i dont want to write the product name ("microsoft yahoo google") in every row.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

ADVERTISEMENT

Can you post a sample of your data using Colo's utility below? Then it will be much easier to understand the layout.
 

placette

New Member
Joined
Sep 20, 2006
Messages
5
im in bank network...i cannot copy the add inn in the excel folder... what could i do?
 

Watch MrExcel Video

Forum statistics

Threads
1,111,911
Messages
5,541,543
Members
410,549
Latest member
Anaarchie
Top