+ Reply to Thread
Results 1 to 3 of 3

Extracting data from column based on specific criteria and pasting into new column

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Extracting data from column based on specific criteria and pasting into new column

    Hi everyone,

    I've got a spreadsheet extracted from a timekeeping software. It gives me data in two columns:

    Column A lists the associate's name, tasks, and activities per task.
    Column B lists the hours entered for each.

    For example:

    Please Login or Register  to view this content.
    However, this format is not very usable for the analysis I'd like to conduct. I can manually insert the appropriate associate's name in a new column, and do the same thing for the Task #, but that takes a great deal of time. I'm looking for some way to do this automatically. I'm thinking an if() function may be useful, and then recording a macro, but I can't seem to crack this nut.

    Here's what I'd like it to look like:

    Please Login or Register  to view this content.
    I have two tabs on the attached spreadsheet, which is an example of the data I'm working with. The 'Currently' tab shows how the data is originally. The 'As Needed' tab shows how I'd like it to be, after some automated fashion.

    Thanks in advance for your help!


    test test.xls

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Extracting data from column based on specific criteria and pasting into new colum

    This macro should do the work (see also attached file):
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-13-2012
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Extracting data from column based on specific criteria and pasting into new colum

    Yep, that seems to do the trick!

    Thanks so much for your help!!!

+ 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