+ Reply to Thread
Results 1 to 8 of 8

Formala to take names from one sheet to another whilt dropping duplicates

  1. 02-01-2015, 03:07 PM #1
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Formala to take names from one sheet to another whilt dropping duplicates

    HI , HOPE SOMEONE CAN HELP WITH THIS ONE?

    ATTACHED IS A SAMPLE WORKBOOK WITH TWO SHEETS. tHE ACTUAL WORKBOOK HAS MULTIPLE SHEET ALL LINKED TO THE DATA ENTRY SHEET, SO THE FORMAT AND LAYOUT OF THE DATA ENTRY SHEET CANNOT BE CHANGED.

    THAT BEING SAID...... I NEED ALL THE ITEM NAMES ENTERED INTO THE DATA ENTRY SHEET TO SHOW UNDER THE SPECIFIC CATAGORY NAME IN THE INVENTORY SHEET WITH NO DUPLICATES SHOWING.

    THANKS IN ADVANCE
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-02-2015, 07:45 AM #2
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    Any takers....
    Reply With QuoteRegister To Reply
  3. 02-02-2015, 08:55 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    Yes, but. I don't think that it'll work with the volume of stuff that you have got to process. We'll see. The new formulae on the inventory sheet are Array Formulas and must be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again. The formulas on the helpers sheet are conventional formulas and shouldn't cause a problem.

    Check it over BEFORE you attempt to move htis onto your real sheet. Adjust the ranges as needed.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 02-02-2015, 09:03 AM #4
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    Thanks Glenn.

    Works perfectly. 1 x 1million rep coming your way
    Reply With QuoteRegister To Reply
  5. 02-02-2015, 09:54 AM #5
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    Hi

    in the example workbook the data goes to column "z" only.
    How would i change the formulas to search to column "aaa" or further?
    Reply With QuoteRegister To Reply
  6. 02-02-2015, 01:29 PM #6
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    ................
    Reply With QuoteRegister To Reply
  7. 02-02-2015, 01:42 PM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    It's unlikely to be really viable with a formula approach. It'd be a massively unwieldy beast. My suggestion is that you close this thread and open a new thread in the VBA forum, but explaining the VERY long rows that you have more clearly right from the outset.
    Reply With QuoteRegister To Reply
  8. 02-02-2015, 01:48 PM #8
    ANDREAAS
    ANDREAAS is offline
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Formala to take names from one sheet to another whilt dropping duplicates

    Thanks glenn

    that's what i feared, the workbook will eventually have multiple users and then the whole explination of how to enable macro's to everyone ensues , but beggers can't be choosers.

    Thanks for all your help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sumproduct select work sheet from dropping down
    By chrisg9 in forum Excel General
    Replies: 1
    Last Post: 05-20-2014, 01:53 AM
  2. [SOLVED] How to filter the names from a list of names without duplicates
    By jayait2000 in forum Excel General
    Replies: 6
    Last Post: 10-11-2012, 04:24 AM
  3. Move Names and addresses from over 3000 sheets to one sheet so I can delete duplicates
    By JERRY GENNINGS in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-09-2012, 03:12 AM
  4. Set up a formala to refer to a cell in a different sheet
    By Brian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-20-2005, 06:51 PM
  5. [SOLVED] How to create a formala in one sheet for a cell in another sheet?
    By Beth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2005, 10:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1