Copy rows which contains a specific text in Excel

Question

0.00/5 (No votes)

See more:

I have huge amount of data. The data consist of College Name, their details and courses they are offered. There are about more than 500 courses. My Excel have Columns start from A to FO. Courses columns are from T to FO. I want to create seperate worksheets according to course names.
What i want is :-
When i search for the specific text (which is obviously course name) , the excel should only show those rows which contains this course name so that i can copy these rows with CTRL + A and paste onto another.

THANKS IN ADVANCE!!!

Posted 15-Oct-12 21:35pm

Member 9427602

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Joan M · Answer 1 · 2012-10-15T23:06:00

Solution 1

Select the entire set of columns and create a table.

To do that in the Spanish Excel version is Ctrl+T, in previous versions it was Ctrl+Q (http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP010073848.aspx[^]).

This will allow you to create a filter just on top of the column and then copy only the registers you will want to copy.

Good luck!

Posted 15-Oct-12 23:06pm

Joan M

Comments

Member 9427602 16-Oct-12 6:15am

Hi joan,
Thanks for reply but according to your solution it will apply filter on each column. As i said i have 5000 columns so it is not making sense to filter 500 columns each time for the one specific text

Joan M 16-Oct-12 6:21am

OK, then your best bet is making a macro to achieve that...

Member 9427602 16-Oct-12 8:28am

Can anyone provide me the macro for the same

Joan M 17-Oct-12 1:11am

That is not how we work here, we help people but we don't give codes, so, try it for yourself, and when you become stuck, come back, post a specific question and somebody will help you.

Good luck.