# Selecting data from one worksheet to appear on a second worksheet

1. ## Selecting data from one worksheet to appear on a second worksheet

I have a membership list with all members details on one worksheet (sheet 1). I need to produce a second worksheet showing only those details members have agreed to share with others (sheet 2). I am not a regular user of Excel but am familiar with filters.

2. ## Re: Selecting data from one worksheet to appear on a second worksheet

I think my crystal ball must be in need of polishing ...

How does one know which details they have agreed to share, please?

3. ## Re: Selecting data from one worksheet to appear on a second worksheet

Sorry. Please see new attachment with codes.

4. ## Re: Selecting data from one worksheet to appear on a second worksheet

Do I take it that full name and town will come through regardless?

5. ## Re: Selecting data from one worksheet to appear on a second worksheet

Please find attached a solution, which I shall explain in my next post.

6. ## Re: Selecting data from one worksheet to appear on a second worksheet

Firstly, change the data lookup table to this:

Code Detail
Y1 V+L+M+E
Y2 V+L
Y3 V+M
Y4 V+E
Y5 V+L+E
Y6 V+L+M
Y7 V+M+E

Formulae on the summary sheet as follows:

In A2: =Sheet1!A2
In B2: =Sheet1!B2
In C2: =Sheet1!C2
In D2: =IFERROR(IF(FIND("V",VLOOKUP(Sheet1!\$K2,'Data codes'!\$E\$3:\$F\$9,2))<>0,Sheet1!F2,""),"")
In E2: =IFERROR(IF(FIND("L",VLOOKUP(Sheet1!\$K2,'Data codes'!\$E\$3:\$F\$9,2))<>0,Sheet1!H2,""),"")
In F2: =IFERROR(IF(FIND("M",VLOOKUP(Sheet1!\$K2,'Data codes'!\$E\$3:\$F\$9,2))<>0,Sheet1!I2,""),"")
In G2: =IFERROR(IF(FIND("E",VLOOKUP(Sheet1!\$K2,'Data codes'!\$E\$3:\$F\$9,2))<>0,Sheet1!J2,""),"")

The formulae use the code in the Class column on sheet 1 to determine which fields to pull through. The formulae can be drag copied down to populate the list.

7. ## Re: Selecting data from one worksheet to appear on a second worksheet

Thank you so much for the solution and for giving up your time. It is much appreciated.

8. ## Re: Selecting data from one worksheet to appear on a second worksheet

You are most welcome. I hope you were able to follow the formulae.

By the way, I'm an East Midlander by birth - come from Long Eaton. You may know it!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1