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
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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?
 
Upvote 0
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.
 
Upvote 0
Can you post a sample of your data using Colo's utility below? Then it will be much easier to understand the layout.
 
Upvote 0

Forum statistics

Threads
1,218,946
Messages
6,145,383
Members
450,613
Latest member
Chalky1982

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top