+ Reply to Thread
Results 1 to 11 of 11

Matching Dates in Excel and Moving the rows to correspond with correct dates

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2011
    Posts
    6

    Matching Dates in Excel and Moving the rows to correspond with correct dates

    Column A has dates over a given 10 year period (Often a single date appears more than once). Column B has each date only once and Columns C-G have values corresponding to each date in column B.

    I want to create a macro or formula to identify each date in column A and align it with the corresponding date in column B as well as the corresponding values in Columns C-G.

    Column A___________Column B___________Column C

    1/1/1999___________1/1/1999___________0.45

    1/1/1999___________1/2/1999___________0.54

    1/1/1999___________1/3/1999___________0.23

    1/2/1999

    1/2/1999

    1/3/1999


    Any help or insight would be greatly appreciated, thanks.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Hello and welcome.
    Could you post your workbook?

  3. #3
    Registered User
    Join Date
    09-04-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Sure Attached
    Attached Files Attached Files

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Is column I your desired outcome?

  5. #5
    Registered User
    Join Date
    09-04-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    No, I'm sorry I meant to delete columns H and I. I would like to have the dates in the columns A and B be the same and bring the values in Columns C-G down into the same row as the corresponding dates in Columns A and B. I don't want to change anything with Column A.

  6. #6
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Could you add one example of your desired result?

  7. #7
    Registered User
    Join Date
    09-04-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Sure I apologize for not being more clear.

    If you go down to the bottom of the spread sheet, I started with the date 4/20/13 in terms of how I would like it to appear for all dates (bolded)

    I started to copy and paste for each date but realized this would take entirely too long.

    Thanks!
    Attached Files Attached Files

  8. #8
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Copy what?
    From where?

  9. #9
    Registered User
    Join Date
    09-04-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    At the very bottom of the updated excel file, you can see that there are nine dates of 4/20/13 in column A (Rows 15978-15986). I copied the values in Columns B-G from Row 1572 (corresponding to the same date of 4/20/13) into those last nine rows to match up the dates.

  10. #10
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    So are you going from bottom up?
    Why we have got 9 lines for 20/04/2013

  11. #11
    Registered User
    Join Date
    09-04-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Matching Dates in Excel and Moving the rows to correspond with correct dates

    Yeah, I started with the last date and was going to go from bottom up. There are actually more values associated with each of those 9 lines for 20/04/13 which I have in another set, I don't want to bring those values in yet until I can get values from columns C-G figured out (if that makes any sense).

+ 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. Matching Dates and Highlighting Rows
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 01:05 PM
  2. List of unique and duplicate names that correspond with dates
    By corbintx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 01:24 PM
  3. [SOLVED] dates to correspond to pay period
    By KSI_Apps in forum Excel General
    Replies: 5
    Last Post: 09-14-2012, 03:31 PM
  4. List Matching with Dates: Using Dates as filters
    By Thawk in forum Excel General
    Replies: 6
    Last Post: 02-15-2009, 05:12 PM
  5. copying rows and inserting them between correct dates
    By assileM in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-29-2008, 12:00 AM

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