Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2012
    Location
    Tampa, FL
    Posts
    3

    Unanswered: Match and Combine Function

    I am an excel VB newb and I would be very appreciative if someone could take the time to help me with what I believe to be a fairly complicated function.

    This function is to help me automate a spreadsheet that contains schedules. It includes the start and end times for employee's shifts, as well as the type of call that the employee will be receiving for a given period. The main issue I have is that the spreadsheet, which is exported from a database, does not export the subjects names and start/end times in a predictable pattern. And the employees don't always have more that one subject.. so this function needs to only affect duplicated rows.

    Here's a better breakdown of what the initial data looks like and what it should end up with:

    column A>Name column B>Subject Colum C>Start Time Column D>End Time Column E>Total Hours (formula) Column F>Comments

    Smith, John Subject 1 3:30 PM 10:00 PM 6.50
    Smith, John Subject 2 10:00 PM 11:45 PM 1.75

    Needs to become:

    column A>Name column B>Subject Colum C>Start Time Column D>End Time Column E>Total Hours (formula) Column F>Comments

    Smith, John Subject 1/Subject 2 3:30 PM 11:45 PM 7.75 subject 2 10 pm - 11:45pm

    I hope the above makes sense, and if it doesn't please let me know and I will try to explain it better. Thanks in advance!

    Mark

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Easiest I can think of for changing the column ordering is to go back to the SELECT statement that extracts the data from the database and write the columns out in the order you desire there
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2012
    Location
    Tampa, FL
    Posts
    3
    Quote Originally Posted by gvee View Post
    Easiest I can think of for changing the column ordering is to go back to the SELECT statement that extracts the data from the database and write the columns out in the order you desire there
    I've uploaded a sample spreadsheet to demonstrate what I'm trying to do. I'm not sure that I understand your response.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well, where does the data come from?
    George
    Home | Blog

  5. #5
    Join Date
    Jan 2012
    Location
    Tampa, FL
    Posts
    3
    Quote Originally Posted by gvee View Post
    Well, where does the data come from?
    The data comes from an application that the company uses... its called GMT (or Planet). So the duplicated data can only be manipulated once its been exported to excel.

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
  •