Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: Visual Basic in Excel query

    I need help designing a macro in excel. I have 2 sheets in the same workbook.

    In the first sheet I have a list of names in column A and a list of dates in the column C. Each name has a specific date associated with it. The data is sorted by Column C.

    In the second sheet, I have the same list of names in column A and I need to put the appropriate dates in Column F. The data in the second sheet is sorted alphabetically by Column A.

    How can I write a macro that looks at the dates in the first sheet, and fills in Column F with the appropriate dates for each person.

    Thanks for your help.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Is there a specific need for it to be a macro? Formulas would work well in this context.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    Originally posted by shades
    Is there a specific need for it to be a macro? Formulas would work well in this context.
    No specific need. Do you have a suggestion of how to use formulas? Any help would be appreciated. Thanks.

  4. #4
    Join Date
    Dec 2003
    Posts
    5
    it looks like I just figured out the answer to my own question. I can use the INDEX and MATCH function together.

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Great. That was exactly what I would have suggested.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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