Results 1 to 7 of 7

Find, copy and paste specific values.

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    Poland
    MS-Off Ver
    365
    Posts
    56

    Find, copy and paste specific values.

    Hey there,
    I'm trying to pull out some data from sheet with 40,000~ rows and about 300 employees.
    example.jpg
    I need to find values >0, sort it descending (by days) and exclude few JobNames. I tried to do that with aggregate and index formulas, but it's kind of slow on weaker PCs and I'm stuck now.
    So, what I need to do is this:
    1. Find Employee from P1 cell
    2. Copy Job, Days, Sum, Average (these columns are not next to each other)
    3. Exclude few specified JobNames in R1:R2 range
    4. Paste it sorted descending by Days
    Ideally it would work on combobox change.
    Perhaps there is a better and faster way to achieve that? Any help is greatly appreciated! Thank you.
    Attached Files Attached Files
    Last edited by Pojzon; 10-14-2018 at 12:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste only specific values to the row that contains the value
    By Helensa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2018, 12:48 PM
  2. [SOLVED] Find specific text within workbook's name, copy and paste it to specific cell
    By axtryo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-09-2017, 02:57 AM
  3. Find specific Data copy and paste into Cell Macro VBA
    By kunmateo93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2014, 10:17 AM
  4. Replies: 2
    Last Post: 03-05-2013, 07:52 AM
  5. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  6. Find the specific text and copy and paste in another cell only if true.
    By SHARIB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2012, 03:14 AM
  7. Excel: Find All (specific) Copy All, Paste All ?
    By coffee_king in forum Excel General
    Replies: 1
    Last Post: 09-19-2012, 02:15 PM

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