populate infomation from one worksheet to another if one of the c.

G

Guest

trying to populate certain filelds from one spreadsheet into another. One
of the fields in sheet 1 will state yes(sheet 1 C2)if the yes condition is
populated i wnat to bring the name and number of to sheet 2( sheet1 a2 and
b2) if the condition is populated with a no(sheet 1 C2) the formula should
check the next cell (sheet 1 C3)to see if the condition is met with a yes
Sheet 1

NAME EXTENSION VOICE MAIL
BARBARA ABLER 2723 Yes
PHILIP DISMORE 2773 Yes
LEE CLARKSON 2748 No
DAWN BAKER 2766 No
JOE SMITH 2762 Yes
MIKE JONES 2736 Yes
HAROLD MIKES 2799 No
PAMELA OCONNOR 2712 Yes

Sheet 2
Voicemail Users Full Name: Voicemail Users Mailbox Number:
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________
 
D

Dave Peterson

How about an alternative?

Apply Data|Filter|autofilter to your range.
Filter by that yes/no columns to show just the yes's.

I find that life is much simpler if I can keep my data in one spot an apply
filters to see the data that I want to see.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to compare a row data from one worksheet to another worksheet 5
How to use the IF Function for 3 conditions 5
Copying Data from One Worksheet to Another 2
How do I coppy a range from 1 sheet to another via IF statement 2
fetching certain fields from 1 worksheet to another(if criteira me 7
to pull from multiple sheets-index,match,vlookup,if,and,or??? 10
Bringing in information from one worksheet to another dependent on the 2nd 5
Copying user profile from one user account to another user account on the same conputer ---- 3 chall 2

Top