+ Reply to Thread
Results 1 to 2 of 2

Pulling a report of data for a specific time range?! Need help ASAP! Thanks so very much

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    New York
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    13

    Pulling a report of data for a specific time range?! Need help ASAP! Thanks so very much

    I have a report that list every employee in the company from the start of business in the 1980's - current. I need to pull all of the employees that were here in March 2012.

    Here's my report columns: ee #'s (my unique ID), start date, termination date.

    This is what I know: I need to delete every new hire with a start date after March 2012. I believe I need to delete employees that were terminated before March 2012? That's the part I'm struggling with big time. I know it's super easy, but I'm struggling over here - please help!!! ;-) Thanks a bunch in advance!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,957

    Re: Pulling a report of data for a specific time range?! Need help ASAP! Thanks so very mu

    There are a lot of ways to do this:

    1) Copy your report to a new sheet, then sort the entire table by start date, and delete the entire row of any employee with a start date after March 2012. Then re- then sort the entire table by end date, and delete the entire row of any employee with a end date before March 2012.

    2) Apply data filters to your table, and use the same criteria as your sorting, except with reverse logic. Filter to show an with a start date before (Less than) March 2012, and an end date after (Greater than) March 2012. Then copy the table and paste elsewhere, and only those that were still visible will be copied.
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pulling a report - way to pull? Help needed ASAP!
    By Freedom041984 in forum Excel General
    Replies: 1
    Last Post: 03-31-2016, 12:26 PM
  2. Pulling specific data based on date range (formula help)
    By thatitalian in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2015, 09:45 AM
  3. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  4. Replies: 5
    Last Post: 05-04-2012, 09:04 AM
  5. Pulling data from multiple worksheets into a report
    By neverborne in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-03-2011, 08:28 AM
  6. Pulling data for a trending report
    By apcarty in forum Excel General
    Replies: 3
    Last Post: 06-17-2010, 07:43 AM
  7. Pulling data from a big report
    By nbeaird_51 in forum Excel General
    Replies: 7
    Last Post: 03-17-2005, 02:53 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