Results 1 to 2 of 2

Thread: Automatically search, copy into new sheet

  1. #1

    Automatically search, copy into new sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please help.
    I want to search a document (of 20,000 contacts) remove or copy certain job functions (which are in columns) then move the whole of that row into a new spreadsheet or page.

    The sheet is a list of data, company names, individual names, job function and email address.

    So I want to find the job function "Sales manager" and then that particular row - i.e. the contact, move into a new sheet for "sales managers".

    Can this be done?

  2. #2
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    The short answer is YES, it can be done. If you want specifics, please share a piece of your file with dummy data.

Tags for this Thread

Posting Permissions

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