• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hi,

J

Jayapresad

New Member
Pl help me to solve the following issue.


I am having a large no of excel data in a work book.


I want to select few(10 or 15) data from the master data based on some criteria for further process.


How to do this?


Thanks


Jayapresad
 
Hi, Jayapresad!

If using filters doesn't work for you, please detail how your data is stored in the workbook, what are the conditions or how do you enter them, and where you need to get the selected values.

Regards!
 
The data is like below.


Item code Description Rate.


The total data will be around 300 lines.


I want to select 10 or 15 items based on description.


Thanks


Jayapresad
 
Are the contents of the description field such that you can easily filter them for what you need to find and then copy that set into the other worksheet?
 
Dear Olemiss,


That is difficult to do copying each item every time.


I think, if we use tick box next to each item and select the tick box.


The tick boxed items should be copied to another work sheet.


Is this possible by using excel formula or is it required to use Macro?


If macro is required, I request someone to write the macro for this.


Thanks


Jp
 
Hi, Jayapresad!

I've just uploaded a similar solution for an Istiyak problem:

http://chandoo.org/forums/topic/search-found

Check if that's suitable for you. You might need to change the output address to a different worksheet, among other little adjustments.

Regards!
 
Dear Sirjb7,


Thanks for your suggestion.


It is not like that.


Refer your example.


Search one item Sirbj7. You can find the item some where in the list.


I want to take that item Sirbj7 to left side box. The data is different items and not repeating at all.


Hope you understood this issue.


Thanks


Jp
 
Hi, Jayapresad!

The "left" box is just the design, the implementation (formulaes & data) is in the "right" box. The search argument entered in L3 with count in L5, performs a search process on worksheet Data, so the selected items are copied to another place (right box, in the example).

Have I understood wrong or it is what you're looking for?

If I'm wrong, please consider uploading a sample file with detailed explanation.

Thanks.

Regards!
 
You must log in or register to reply here.
Back
Top