Search matching Info in One Column and carry those rows into new worksheet

**saduff** · 09-19-2012, 08:27 PM

I am going to go crazy. I see similar issues, but cannot adjust the macros I have accordingly. I am no excel pro, but know a lot. Any help is so much appreciated! I am creating a directory and would like to search column F for matching village initials, then create sub worksheets, carry specific rows (shown in macros) over for each of the members for live in those specific villages. So I will ultimately end up having x amount of worksheets. But after I have the initial macro worked out, I can create it for each village. Thank you! This is the macros I have:

Please Login or Register  to view this content.

I had to delete a lot of the information for confidentiality. Hope it is still understandable.

DIRECTORYTEST.xls

**cjo** · 09-19-2012, 10:18 PM

Try this on a COPY of your workbook.

Please Login or Register  to view this content.

**saduff** · 09-19-2012, 10:31 PM

That was amazingly PERFECT. Exactly what I was looking to do! Thank you so much!

**Cutter** · 09-20-2012, 09:57 AM

@ saduff

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**saduff** · 09-20-2012, 04:05 PM

cjo...can you help me again, PLEASE!? I would like to add a sheet called "Master Directory" that the village sheets information would be pulled from...this in turn would be my master worksheet. My "Directory" file would be a secondary worksheet that all of the identical information from "Master Directory" is pulled from. "Directory" will almost be a carbon copy of "Master Directory"--but I need to have the capability of deleting rows in the "Directory" that will be pulled over from Master Directory and stay deleted when the macros is run. Can the worksheets all just be updates rather than deleted?

I really appreciate any help? I tried to examine the macros you created, but anything I worked out wasn't working, for fear I might make it worse, I am turning to you for more help! Thx!

**cjo** · 09-21-2012, 12:00 AM

I'm not entirely certain what you're asking...
Let me restate: sheet 'Directory' is a subset of 'Master Directory' (everything on 'Directory' is on 'Master Directory', but not everything on 'Master Directory' is on 'Directory'), and you're creating this manually by copying 'Master Directory' and deleting rows. You then want the various village sheets to be created (if not already existing) or updated (if existing) using the 'Directory' sheet as a source.

The problem I can see happening with this is the addition of duplicate records onto the various Village tabs -- as written, the macro doesn't check for uniqueness. It's quite possible to trap for this, but I don't see a (single field) unique identifier. I do notice that it appears that you have what appears to be near duplicate records already in you 'Directory' sheet, though; for example, Member ID 2435 appears twice, with the only difference being the values in the 'Title' field being slight rearrangements of each other.

**saduff** · 09-21-2012, 12:57 PM

First let me explain that I am creating a Member Directory Book for a Country Club. Some of our members own more than one property within the club, so, their name would be listed 2 or more times pending on how many properties they own in the Master Directory Worksheet. The Directory worksheet is what I am pulling from to list the members phone numbers, etc. to publish. I don't want to pull or publish their information 2 or more times if they own more than one property or not. HOWEVER...within the villages sheets, I want to pull from the Master Directory worksheet because I want their names listed in each village they do own a property. So, I want to maintain the integrity of the cells in the Master Directory Worksheet and thru out at all times.

Does that make any more sense? Sorry...I know what I want, but its hard to explain!

I'm not entirely certain what you're asking...
Let me restate: sheet 'Directory' is a subset of 'Master Directory' (everything on 'Directory' is on 'Master Directory', but not everything on 'Master Directory' is on 'Directory')(correct)[/COLOR], and you're creating this manually by copying 'Master Directory' and deleting rows. But I don't want to just copy/paste, I want to keep the integrity of the cells. You then want the various village sheets to be created (if not already existing) or updated (if existing) using the 'Directory' sheet as a source. No, using Master Directory.

The problem I can see happening with this is the addition of duplicate records onto the various Village tabs -- as written, the macro doesn't check for uniqueness. It's quite possible to trap for this, but I don't see a (single field) unique identifier. I do notice that it appears that you have what appears to be near duplicate records already in you 'Directory' sheet, though; for example, Member ID 2435 appears twice, with the only difference being the values in the 'Title' field being slight rearrangements of each other.