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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

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?
 

Forum statistics

Threads
1,141,429
Messages
5,706,405
Members
421,447
Latest member
arthuro2021

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
Top