copy or remove particular count of records and pasting in another excel workbook

**perusjosh** · 09-19-2013, 03:06 AM

Hi

i have a multiple records (30 k) in a excel workbook , in that i want take only 3 records of email per company,

ex: the company having 10 email in that only three email i need to copy or remove and keep in separate excel workbook.

if the company having less then three, the same count or email i need to copy or remove and keep in separate excel workbook.

i have kept the same file also.

please help me how to do.

thanks and regards
Josh

**perusjosh** · 09-20-2013, 09:32 AM

any one can help me......

**alansidman** · 09-20-2013, 09:48 AM

You have not received any responses because your explanation is not clear. Please provide a sample of the what the solution should look like. (prepared manually) No one knows what your logic is to achieve your expected solution. Help us to help you with more information and examples of the solution.

Alan

**perusjosh** · 09-21-2013, 02:32 AM

Originally Posted by alansidman

You have not received any responses because your explanation is not clear. Please provide a sample of the what the solution should look like. (prepared manually) No one knows what your logic is to achieve your expected solution. Help us to help you with more information and examples of the solution.

Alan

please find the attached file, which is colored in yellow records as to copy and past in another sheet.(<=3 records copy to another sheet)

please help me

regards
Josh

**TMS** · 09-21-2013, 09:28 AM

Use another helper column, D

Cell D4:

Formula:

Please Login or Register  to view this content.

and drag down.

Filter column D on less than or equal to 3. Copy visible records to the new sheet.

Regards, TMS

Edit: error in formula ... change $A$2,$A2,$A2 to $A$2:$A2,$A2

**Teethless mama** · 09-21-2013, 09:59 AM

See the attached file

**jaslake** · 09-21-2013, 11:34 AM

Hi perusjosh

Here's a VBA solution

Please Login or Register  to view this content.

**TMS** · 09-21-2013, 03:06 PM

Another VBA solution:

Please Login or Register  to view this content.

Regards, TMS

**perusjosh** · 09-24-2013, 12:29 AM

Hi thanks a lot
excellent solution you have given to me.

Small changes required in this.
if criteria is changing to instead of 3 , if i want 5 records how to get it.
So, please give me the option that at button 1(how many records you want __ ) if i enter the cont
according to that it will separate the records.

thanks a lot for your wonderful solution once again.

josh

**perusjosh** · 09-24-2013, 04:59 AM

Hi mama ,
Thanks a lot, i'm not able to use more records, i have 5000 records, so how extend the formula(i'm not able to copy and past the formula- when am doing the following error show's - *you cannot change part of an array*)

once again thanks a lot.

josh

**TMS** · 09-24-2013, 05:34 AM

Ah ... scope creep. In reality, you have had several solutions to your original question and, as such, this thread should now be marked solved.

I am assuming that you are only going to want to vary the number of records extracted occasionally so, rather than add the overhead of front end code which will rarely be used, you might just as well edit the filter.

For example, in my code, you would change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

You should also bear in mind that my code simply automates the manual solution offered in post #5.

If you really need the additional code, I would suggest you ask for it in a separate thread.

Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

**perusjosh** · 09-24-2013, 06:39 AM

Hi,

i have 1000 records, how can i make it,

u have given the solution but, its work only one criteria but criteria may change.

please help me solve.

josh.

**TMS** · 09-24-2013, 08:17 AM

OK, maybe this:

Please Login or Register  to view this content.

Regards, TMS

**perusjosh** · 09-25-2013, 12:43 AM

hi,
am try to do with your code but am getting the error.

please how to execute the code or

i'm attaching the file kindly insert the code and send to me.

information required: can is use any number of records in this code.

regards
Josh

**perusjosh** · 09-26-2013, 09:43 AM

Hi TMS,

Please help me to do this

regards
Josh

**TMS** · 09-26-2013, 09:55 AM

Thought I'd already done this ...

Suspect the forum problems prevented the upload.

See attached example

Regards, TMS

copy or remove particular count of records and pasting in another excel workbook

LinkBack

Thread Tools

Rate This Thread

Display

copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Re: copy or remove particular count of records and pasting in another excel workbook

Thread Information

Users Browsing this Thread

Similar Threads

Copy from another workbook and pasted to another workbook, remove duplicate and sorted

[SOLVED] Problem pasting data into new workbook when worksheet has no records

Excel 2007 : Copy Data from Sheets in one Workbook and pasting it into another Workbook Sheet

Copy Pasting data from one excel workbook to another using vba

Copy records with the same value in a column to a new sheet or workbook

Bookmarks

Bookmarks

Posting Permissions