+ Reply to Thread
Results 1 to 5 of 5

Importing certain data to another worksheet

  1. #1
    Registered User
    Join Date
    07-20-2009
    Location
    maryland, usa
    MS-Off Ver
    Latest Excel (Excel 365)
    Posts
    29

    Importing certain data to another worksheet

    Hi all,

    Let's say in worksheet1, I have 100 clients with the following info:

    b1: Account number
    c1: Name
    d1: Male/Female

    On next worksheet, I only would like to have a list of female client, which formula do I need to use?

    Thanks.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Importing certain data to another worksheet

    H and welcome to the board
    Perhaps something like =if(sheet1!d1="female",sheet1!b1,"")

  3. #3
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Importing certain data to another worksheet

    Please see the attachment. It uses an event driven macro rather than a formula to regenerate the list on sheet 2 every time it is activated.

    Have a look on the sheet2 tab in the VBA editor (alt F11) to see the code.
    Attached Files Attached Files
    Martin

  4. #4
    Registered User
    Join Date
    07-20-2009
    Location
    maryland, usa
    MS-Off Ver
    Latest Excel (Excel 365)
    Posts
    29

    Re: Importing certain data to another worksheet

    mrice and arthurbr,

    Wow, I really appreciated your speedy response. It's great. I already tried IF fuction, However, I did not like the way it leaves blanks between column for mail clients.

    Mrice, is there any simpler version of formula to do this instead of using VBA?
    What you did for me is exactly what I wanted.
    VBA is just too much for me.

    Thanks all.

  5. #5
    Registered User
    Join Date
    07-20-2009
    Location
    maryland, usa
    MS-Off Ver
    Latest Excel (Excel 365)
    Posts
    29

    Re: Importing certain data to another worksheet

    I was trying to make it easier to explain, but I guess I could not.

    What formula should I need to use import "only client with BUY" into output worksheet?

    Thanks.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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